How can I get a list of routers in NFA that do not have any active interfaces in a specific period of time?
NFA 10.x and up
Below are the steps to generate a list of routers that do not have any interfaces that have any flow data in the last week. You can change 604800 to any amount of seconds to adjust this to any time frame you are looking for:
mysql -P3308 -D reporter -unetqos -pnetqos -t -e "select distinct inet6_ntoa(routerAddress), devicename, id from routers where id not in (select routerid from interfaces where lastflow >= (unix_timestamp() -604800)); " > RoutersWithoutFlow1week.txt