How can we get the status of interfaces and their parent router which has sent flow in the last 24 hours?
CA Network Flow Analysis - All Versions.
Here is the query which should show interfaces and their parent router who has sent flow in the last 24 hours.
select r.ID as RouterID, r.deviceName, i.ID, i.ifIndex, i.ifdescr, i.enabled, i.updatedon, i.LastFlow from interfaces i join routers r on i.routerId=r.id where i.LastFlow > (unix_timestamp() -86400) order by r.routeraddress;
For list of all routers with Enabled Interfaces:
https://knowledge.broadcom.com/external/article?articleId=47345