Search found 4 matches

by tsterite
Mon Jul 28, 2014 7:38 am
Forum: Nagios XI
Topic: SQL Query to report downtime
Replies: 7
Views: 2490

Re: SQL Query to report downtime

I will share this information - thank you!!
by tsterite
Fri Jul 25, 2014 8:07 am
Forum: Nagios XI
Topic: SQL Query to report downtime
Replies: 7
Views: 2490

Re: SQL Query to report downtime

Yikes! I thought so - I saw the start & stop points in the table for some of the outages. We have used the provided reports, however, I was asked to provide something that will allow us to remove the "scheduled" or planned outages from the report; or at least report the 2 separately - ...
by tsterite
Thu Jul 24, 2014 3:27 pm
Forum: Nagios XI
Topic: SQL Query to report downtime
Replies: 7
Views: 2490

Re: SQL Query to report downtime

Thank you for your help. I am reviewing the description of the downtimehistory table; and it apepars that this is specifically for scheduled downtime. I should have been more specific; I am also looking for information on when hosts and/or services go down outside of a scheduled downtime. Thoughts?
by tsterite
Thu Jul 24, 2014 9:28 am
Forum: Nagios XI
Topic: SQL Query to report downtime
Replies: 7
Views: 2490

SQL Query to report downtime

Hello - I'm looking for a stepping stone, a SQL statement that someone has used to query for planned & unplanned downtime. I found the post in technical support where the tables needed were identified: hoststatus, servicestatus, statehistory and logentries. Each time I try linking tables in our ...