Nagios Support Forum

Hello,

This question is related to the following article:

https://support.nagios.com/forum/viewto ... 16&t=44399

When I run the query to see what hosts have notifications disabled I see a handful. When I go in XI UI I manually enable notifications for the host that have notifications disabled. All is good.

However when I run the query:

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

These hosts that were just enabled still show up in the query as still being disabled....

echo 'select host_name from tbl_host where notifications_enabled=0\G;' | mysql -uroot -pnagiosxi nagiosql (I still get same hosts disabled, any idea why?)

Brdr

This is because what you are querying in the database is the config value. However there is also a runtime value that takes precedence over the config value.

Hi Scott, thanks for the reply.

Is there a way to force runtime to be the config value? Or, another option to see present value after I have renabled the hosts and services that were previously disabled?

brdr wrote:Is there a way to force runtime to be the config value?

no

brdr wrote:Or, another option to see present value after I have renabled the hosts and services that were previously disabled?

You can see the runtime values on the Status Detail Page -> Advanced Tab -> "Service Attributes" or "Host Attributes"

okie. Let me ask the question a different way:

We have 2000+ plus hosts, and 20,000+ services across our prod/non-prod XI instances. Within this domain roughly 80 users. These users schedule downtime, and acknowledge alerts. Occasionally, they will disable notifications for hosts/services; sometimes by design, sometimes by accident.

As a Nagios administrator how can I query Nagios system to find out hosts/services that have notifications disabled?

Thx

The current running status for hosts and services are stored in the nagios database.
The status of the hosts are in the nagios_hoststatus table and services are in the nagios_servicestatus table.
I think the query you have ran before would work but the database and tables would have to be adjusted. Then the output of that command would have to be linked to the nagios_hosts table in the nagios database.

That works. As always, thanks tgriep!

Please close.