Hi All,
I have NFA 9.3.2 installed in my environment. Is there any option that we can pull a report for the interfaces which got inactive due to some reason.
It would help to figure out if any changes on the router affects Netflow configuration and it takes no less time to fix it.
Hora,
What about a query to show all Interfaces which have not had flow in the last 30 days:
mysql reporterselect inet_ntoa(routeraddress) from routers where id in (select routerid from interfaces where lastflow < (unix_timestamp() -2592000)) and id not in(select routerid from interfaces where lastflow > (unix_timestamp() -2592000));
Hi Justin,
Thanks for the response. I am getting errors while running this query.
What does "2592000" signifies in the above query.
Run this:
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() -2592000) order by r.routeraddress;