The “Enable Interfaces” screen in the NFA Administration GUI displays a list of all routers with Enabled Interfaces. Is there a way to run a query to export this list to a file?
NFA 9.x Master Console
Log on the NFA Master Console machine and enter the following command at a Command Prompt to get a list of "Total Interfaces" and "Enabled Interfaces" on each router:
mysql -P3308 -D reporter -t -e "SELECT SQL_CALC_FOUND_ROWS v.ID, v.routerAddress, v.routerSysName, v.harvester, count(i.id) as 'totalInterfaces', sum(if(enabled='Y', 1, 0)) as 'enabledInterfaces' FROM routers_all_view v INNER JOIN interfaces i on i.routerId = v.ID GROUP BY routerAddress ORDER BY routerAddress asc;" > Enabledinterfaces.txt
The output of the command will appear in the file "enabledinterfaces.txt" in the current directory.