auditing or reporting on when hosts were in maintenance

[tim.mooney]

We've been using Zabbix for about a year, mostly with good success. We started with 2.0.3 and are currently running 2.2.2.

I'm trying to find a way to audit or report on when hosts were (past tense) in maintenance. I know that if a host is currently in maintenance, you can see that in the Configuration->Hosts area, and if there are triggers that are firing on the host, that will also show up in the Monitoring->Dashboard with the wrench symbol next to the item(s).

However, I'm interested in auditing or reporting on when hosts were included in a maintenance period in the past -- a period that has expired.

Is there a way to report on this through the interface? If not, is there a way to get this information directly from the database?

Any tips or suggestions on how to get this information would be greatly appreciated.

Thanks,

Tim

[tim.mooney]

Is there no way to do this?

I'm still looking for thoughts on how to do this. I would appreciate any tips people could give on how I can audit whether a host *was* in maintenance at any particular date & time.

[steveboyson]

select h.name, from_unixtime(m.active_since), from_unixtime(m.active_till), m.description from hosts h, maintenances_hosts mh, maintenances m where mh.hostid = h.hostid and mh.maintenanceid = m.maintenanceid order by h.name;