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='N' " > interfaces.txt

Mysql –P 3308 reporter "Select * from interfaces where lastflow > unix_timestamp()-86400 and enabled='N' " > interfaces.txt

Mysql -P 3308

select * From interfaces where lastflow> unix_timestamp()-86400 and enabled='N'