Determining time to acknowledge a problem

[cwscribner]

Hi all.

The title pretty much says it all. Is there a way to show average response time to an incident? A report would be perfect. Thoughts?

[agriffin]

XI currently can't do this. It's a request we've been hearing a lot though, and it's on our radar for a future version.

[cwscribner]

Okay, thanks. The time an alert occurs and the time its acknowledged must be captured in a database right? Would it be feasible to grab that data from a database and perhaps have a custom PHP report?

[agriffin]

Yep, and that's pretty much how we would implement it ourselves.

[cwscribner]

Can you offer some insight as to what tables/fields I need to look for? Would those numbers be in the nagios or nagiosql database?

[mguthrie]

The nagios database stores status information, includes acknowledgments and state changes. The nagiosql database stored the object configurations. You'd need the nagios database for that info. Hope that helps!