Nagios Support Forum

Posted: **Mon Nov 25, 2019 9:02 pm**

Hi Team,

We have faced one issue with downtime. We have enabled the one server in scheduled downtime. we are sure that when the server in downtime we will not receive any alerts. But post downtime also we have not received any alert. Could you please tell me that the host which is in scheduled Maintenance mode what is the start and end time scheduled down time. I know once scheduled down time is end the entries will go in scheduled down time option.

but i have seen there is table nagios_scheduleddowntime , can we grep the details on host from start and end time. I have seen in the table there is no hostname, I want to grep the details with hostname.

Posted: **Tue Nov 26, 2019 1:42 pm**

I'm not fully understanding your question but I can show you how to connect that table to the objects table

Code: Select all

select nagios_scheduleddowntime.*, name1 as host, name2 as service from nagios_scheduleddowntime, nagios_objects where nagios_scheduleddowntime.object_id=nagios_objects.object_id ;

Posted: **Tue Nov 26, 2019 9:26 pm**

we want start time and endtime for the schedule downtime for the testing1 host name could you please provide mysql query please.

Posted: **Wed Nov 27, 2019 7:34 am**

Code: Select all

select scheduled_start_time,scheduled_end_time, name1 as host, name2 as service from nagios_scheduleddowntime, nagios_objects where nagios_scheduleddowntime.object_id=nagios_objects.object_id and name1='testing1';

Nagios Support Forum

scheduled downtime on host

scheduled downtime on host

Re: scheduled downtime on host

Re: scheduled downtime on host

Re: scheduled downtime on host