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?

Article Id: 36900
Status: Published
Updated On: 13-04-2020 10:47
Products:
CA Network Flow Analysis (NetQos / NFA)
Issue/Introduction:



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

Resolution:

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 -D reporter -t -e "select ID, RouterAddress, ifindex, RouterID, RouterName, Name, Description, from_unixtime(LastData), HarvesterAddress from agents_all_view where lastdata < (unix_timestamp() -86400) order by RouterAddress;" > C:\interface_last_data_over24hours.txt