scheduled downtime on host

[udaykumar]

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.

[scottwilkerson]

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 ;

[udaykumar]

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

[scottwilkerson]

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';