Page 1 of 1
List all passive verifications in XI
Posted: Fri Jun 30, 2017 1:27 pm
by 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.
Re: List all passive verifications in XI
Posted: Fri Jun 30, 2017 2:25 pm
by 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.
Re: List all passive verifications in XI
Posted: Mon Jul 03, 2017 9:59 am
by vmesquita
Thanks! I will try it.
Re: List all passive verifications in XI
Posted: Mon Jul 03, 2017 10:51 am
by 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?
Re: List all passive verifications in XI
Posted: Wed Jul 05, 2017 12:00 pm
by 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.
Or you can search for the NSCA password in the command to get the hostname as well.
Re: List all passive verifications in XI
Posted: Mon Jul 10, 2017 2:06 pm
by 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?
Re: List all passive verifications in XI
Posted: Mon Jul 10, 2017 3:04 pm
by 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