How can I get a list of routers in NFA that do not have any active interfaces in a specific period of time?

Document ID : KB000044127
Last Modified Date : 14/02/2018
Show Technical Document Details

Question: 

How can I get a list of routers in NFA that do not have any active interfaces in a specific period of time?

Answer

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:

 

1. Open a command prompt on the NFA Console server.

2. Run the command below:

mysql -P3308 -D reporter -t -e "select distinct inet_ntoa(routerAddress), sysname, devicename, devicealias from routers where id not in (select routerid from interfaces where lastflow >= (unix_timestamp() -604800)); " > RoutersWithoutFlow1week.txt

3.  This will create a text file in the directory where you run the command.