How can I create a report that shows all of the licensed interfaces in NFA and the last time a flow was received for each interface?

Document ID : KB000036900
Last Modified Date : 22/05/2018
Show Technical Document Details
Question:

How can I create a report that shows all of the licensed interfaces in NFA and the last time a flow was received for each interface?

 

 

Environment:
Any version of RA/NFA
Answer:
There's no way to create a report like this from within NFA, but you can query the database directly to get a list of interfaces and the last time they received data.

You can run the command below from a command prompt on your NFA Console server and it will generate a file with a list of all licensed interfaces in NFA and the last time data was seen on that interface.
 
mysql -P3308 -D reporter -t -e "select ID, RouterAddress, ifIndex, Name, Description, from_unixtime(lastData)  from agents_all_view order by routeraddress;" > C:\interface_last_data.txt
Additional Information:
If you only wanted to get a list of licensed interfaces which have not seen data in greater then 24 hours you could use a query like below:
mysql -P3308 -D reporter -t -e "select ID, RouterAddress, ifIndex, Name, Description, from_unixtime(lastData)  from agents_all_view where lastdata < (unix_timestamp() -86400) order by routeraddress;" > C:\interface_last_data_over24hours.txt