Query to list the devices which has sent flow in last 24 hours.

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

How can we get the status of interfaces and their parent router which has sent flow in the last 24 hours?

Environment

CA Network Flow Analysis - All Versions.

Resolution

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;

Additional Information

For list of all routers with Enabled Interfaces:

https://knowledge.broadcom.com/external/article?articleId=47345