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

Issue: 

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?

Environment:  

NFA 9.x Master Console

Resolution/Workaround:

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.