How can I get a list of all interfaces in NFA that are disabled?

book

Article ID: 105873

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction



How can I get a list of all interfaces in NFA that are disabled?

Environment

Release: RAIB1H99000-9.3-Network Flow Analysis-Interface Bundle-Hardware
Component:

Resolution

RDP to the NFA console server, open a command prompt and run the command below:
mysql -D reporter -t -e "select inet6_ntoa(r.routerAddress), i.name, i.description, i.enabled, i.ifindex, i.ifdescr, i.ifname from interfaces i join routers r on r.ID=i.routerId where i.enabled='n' order by r.routeraddress;" > c:\disabled_interfaces.txt

This will generate a list of all interfaces in NFA that are marked as disabled, sorted by router address.