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

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

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

Environment

NFA

Resolution

RDP to the NFA console server, open a command prompt and run the command below:

mysql -D reporter -unetqos -pnetqos -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.