Create report with all snmp profiles

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

We need to know the snmp profiles of all the routers discovered in NFA

Environment

Component : NQRPTA - REPORTERANALYZER

Resolution

Here's a way to get the info you are looking for on the NFA Console:

The following command will give you the list of the SNMP Profiles and the corresponding Profile IDs on the NFA Console:

mysql reporter -t -e "select id, name from snmpprofiles;" > snmpprofiles.txt



THEN, the following command will list out all routers and the corresponding profileIDs :

mysql reporter -t -e "select inet6_ntoa(routeraddress), profileid from routers;" > routerprofiles.txt



The routers that have profileid=0 have no profile ID at all, the others should show you a number corresponding to the ID from the snmpprofiles table.