List all passive verifications in XI

[vmesquita]

Is there a way to list all passive verifications in Nagios XI? More specifically, we would like to change the NCSA password, but we would need to change on the clients and I can't find a specific way to list all the clients.

[dwhitfield]

Do you want a list of all passive checks that have ever come in?

Log in to mysql as root or the nagiosql user. Get into the nagiosql db with use nagiosql;

The following two may be slightly over-inclusive, but should give you a pretty close list:

Code: Select all

select config_name from tbl_service where passive_checks_enabled='1';
select config_name from tbl_service where passive_checks_enabled='2';

If you want a little more detail, you could go with config_name, service_description in the select part of the query.

[vmesquita]

Thanks! I will try it.

[vmesquita]

I tried the command, however some of the hosts I know they have passive checks are not listed. Would there be a way of getting a comprehensive list?

[tgriep]

Another way to check for Passive Only checks is to open the objects.cache file and see if the active checks are disabled.
The objects.cache file is usually in the /usr/local/nagios/var folder.
Open it up and search for the following option to be set to zero.

Code: Select all

active_checks_enabled   0

Or you can search for the NSCA password in the command to get the hostname as well.

[vmesquita]

Hi,

I found the file, however its fairly old:

Code: Select all

2040 -rw-r--r--. 1 nagios nagios 2087957 Jun 26  2014 objects.cache

Maybe there would be a newer version somewhere else?

[tgriep]

The latest file should be here

Code: Select all

/usr/local/nagios/var/objects.cache

Or here if the system was setup for a ramdisk, here

Code: Select all

/var/nagiosramdisk/objects.cache