DX Infrastructure Manager

Expand all | Collapse all

NetQoS: Export all enable interfaces

Jump to Best Answer
  • 1.  NetQoS: Export all enable interfaces

    Posted 04-05-2016 03:31 PM

    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



  • 2.  Re: NetQoS: Export all enable interfaces
    Best Answer

    Posted 05-10-2016 09:29 PM

    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



  • 3.  Re: NetQoS: Export all enable interfaces

    Posted 05-11-2016 07:48 AM

    Thanks a lot Marlos! it worked perfectly !