We need to know the snmp profiles of all the routers discovered in NFA
Component : NQRPTA - REPORTERANALYZER
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.