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

Document ID : KB000105873
Last Modified Date : 10/07/2018
Show Technical Document Details
Question:
How can I get a list of all interfaces in NFA that are disabled?
Answer:
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.