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?
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