All Interfaces

This wouldn’t do any of that…..agents_all_view will only show you your licensed interfaces.

Select * from interfaces where lastflow > unix_timestamp()-86400 and enabled='N';

This would give you any where the interfaces are not enabled and lastflow has seen an update in the last 24 hours.

To get it to a text file:

Mysql –P 3308 reporter
Select * from interfaces where lastflow > unix_timestamp()-86400 and enabled='Y'; (Worked)

Mysql -P 3308 reporter
select * From interfaces where lastflow> unix_timestamp()-86400 and enabled='N';  (Worked)


From Katie:

mysql -P 3308 reporter
select RouterName, Name, Enabled, from_unixtime(LastData) from agents_all_view
where LastData > unix_timestamp()-86400 and enabled='N' order by RouterName;  (not working)

mysql -P 3308 reporter
select RouterName, Name, Enabled, from_unixtime(LastData) from agents_all_view; (worked)

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; > RAInterfacesinactive.txt  (worked)