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

The following command will give you the list of the SNMP Profiles on the NFA Console:


mysql -unetqos -pnetqos -D reporter -t -e "select inet6_ntoa(r.routeraddress) as 'Router Address', s.name as 'SNMP Profile Name' from routers r inner join snmpprofiles s on r.profileid=s.id;" > RouterProfiles.txt