Search found 4 matches
- 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!!
- 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 - ...
- 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?
- 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 ...