NetQoS: Export all enable interfaces

[d.pereyra]

Hi everybody, I will like to export all enable interfaces in NetQOS, I can list the "Available Interfaces" but only expandning each device and interfaces, sn see wich one is active enable and with netflow. It is posible export ir all in a csv for example?

 

Thanks

Diego MP

[MarlosBarroso]

Hello Diego,

 

You cannot export that information directly from the GUI. You can though extract that information directly from the MySQL database. RDP to the NFA Console and issue the command below from the Windows prompt. This will create a text file with the list of all enabled interfaces along with the IP address of the routers they belong to:

 

mysql reporter -t -e "select inet_ntoa(r.routeraddress),i.ifindex,i.ifname from routers r join interfaces i on r.id=i.routerid join agent_definitions a on i.id=a.interfaceid where i.enabled='Y';" > interfaces.txt

[d.pereyra]

Thanks a lot Marlos! it worked perfectly !