Is there a way to output a list of Total Interfaces and Enabled Interfaces to a file?

Document ID : KB000047345
Last Modified Date : 14/02/2018
Show Technical Document Details


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( 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.