Nagios Support Forum

Posted: **Fri Jun 23, 2017 9:20 am**

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

Posted: **Fri Jun 23, 2017 11:32 am**

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

Posted: **Fri Jun 23, 2017 11:55 am**

sweet. gracias.

please close

Nagios Support Forum

Disable Notifications query or report

Disable Notifications query or report

Re: Disable Notifications query or report

Re: Disable Notifications query or report