Disable Notifications query or report

[brdr]

Hi,

Is there a data base query that can be constructed (or even a report available) that shows hosts and services checks that have been disabled? We have about 2500 hosts/15,000 service checks and many users. Some times users will disable notifications (rather than acknowledge alerts) by accident. It would be nice to run query to find out which checks have been disable...

Thanks

[cdienger]

This information can be pulled from the nagiosql db with;

Code: Select all

echo 'select host_name from tbl_host where notifications_enabled=0\G;' | mysql -uroot -pnagiosxi nagiosql
echo 'select service_description from tbl_service where notifications_enabled=0\G;' | mysql -uroot -pnagiosxi nagiosql

[brdr]

sweet. gracias.

please close