List of Inactive enabled interfaces in RA 9.0

From MSO Wiki

List of Inactive and Enabled interfaces in Reporter Analyzer 9.0

mysql -P 3308 reporter

select RouterName, Name, Enabled, from_unixtime(LastData) from agents_all_view where LastData < unix_timestamp()-86400 and 

enabled='Y' order by RouterName; > RAInterfaces.txt

mysql -P 3308 reporter 

select RouterName, Name, Enabled, from_unixtime(LastData) from agents_all_view;  > RAInterfacestotal.txt