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?
Any version of RA/NFA
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.
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