How can I query the NFA database to see all Protocol ID's and Ports in the database?
Article ID: 97288
Updated On:
Products
CA Network Flow Analysis (NetQos / NFA)
Issue/Introduction
How can I query the NFA database to see all protocol ID's and ports detected by NFA in the database?
Environment
NFA Any Version
Resolution
The protocol identifier in the reporter.protocol_definitions table is what holds this data, however it is stored in hex, so it must be converted into a readable format to see the protocol ID and port number.
To convert the data, open a command prompt and run the command below to export the list to a csv file:
mysql -D reporter -t -e "select ID, IfNull(pd.Name, p.Name) as 'Name', IfNull(pd.Description, p.Description) as 'Description', Encapsulation, conv( mid( identifier, 19, 8 ), 16, 10 ) as proto1, conv( mid( identifier, 27, 8 ), 16, 10 ) as port from protocol_definitions p left outer join protocol_domains pd on pd.protocolId = p.id;" > protocol_definitions.csv
To convert the data, open a command prompt and run the command below to export the list to a csv file:
mysql -D reporter -t -e "select ID, IfNull(pd.Name, p.Name) as 'Name', IfNull(pd.Description, p.Description) as 'Description', Encapsulation, conv( mid( identifier, 19, 8 ), 16, 10 ) as proto1, conv( mid( identifier, 27, 8 ), 16, 10 ) as port from protocol_definitions p left outer join protocol_domains pd on pd.protocolId = p.id;" > protocol_definitions.csv
Feedback
Yes
No
Powered by
