How can I get a list of Router Addresses and Names that are on a Harvester?

Document ID : KB000121642
Last Modified Date : 28/11/2018
Show Technical Document Details
Question:
How can I get a list of Router Addresses and Names that are on a Harvester?
Environment:
9.3.6 and later. 
Answer:
RDP to the Harvester server, open a cmd prompt, and run the command below:

mysql -D harvester -t -e "select inet6_ntoa(r.router)as IP_Address, s.sysname as RouterName, s.SysDescr from routers r join routers_snmp s on r.RouterID=s.RouterID;" > RouterList.txt
 
This will create a RouterList.txt file in the directory where you ran the command, with the Router IP address, Router Name and System Description.