Nagios Support Forum

This is exactly what I was looking for. Thank you very much!

HI Support,

Could you please assist in creating a sql query which will output all Hosts and Services with scheduled downtime, and include the downtime window?

Thanks,

Otto

I see. Thanks.

Hi, We are expanding our deployment of mod_gearman workers and need to switch several 100s of hosts to a new worker. To do this, we need to remove a mg_objects_ hostgroup currently set on each host (not inherited) and add a new, different mg_objects hostgroup. What would be the easiest way to do thi...

No, that's not going to work for our purposes. However, some more work with jq produced what we need. Anyone else looking to generate lists of GUI-disabled Host and Service notifications may probably find the below two API queries useful: curl -XGET -k -L --silent "http://nagiosserver.corp.com/...

That is just some stuff to clean up the output.
The issue exists even without |tr -d '"' |paste - -

It is also worth pointing out that users could just disable active checks through the UI, and not in the CCM, these can be found by navigating to the following URLs /nagiosxi/includes/components/xicore/status.php?show=services&serviceattr=16 /nagiosxi/includes/components/xicore/status.php?show=...

This is what I call a gem of a post. I plan to take all those queries, turn them into what I call Finder tests. I'll make them special services that are not activated, but can be run from the GUI to see the result. Then, I can open the Finder service test in the CCM, click the "Run Check Comma...

Thanks, this is what I was looking for but your answer also made me realize there are other ways admins could avoid following instructions to use Scheduled Downtime... Subsequently, I'd appreciate if your could help with SQL queries listing Hosts and Services with Notifications disabled, and also Ho...

Hi, We are finding that despite repeated instructions to not do it, some of our admins like to disable hosts and services rather than use the Schedule Downtime feature. This presents a problem if they forget to re-enable... Could you please help us define a SQL or API query that will list all disabl...