Query to list the devices which has sent flow in last 24 hours.
Article ID: 242717
CA Network Flow Analysis (NetQos / NFA)
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;