[Nagios-db-devel] availability reports

[Ben <be...@si...>]

So I was looking over the historical availability reports I'd created, and 
realized they were confusing me. I had two of them, Historical 
Availability by Service, and Historical Availability by Hostgroup. The 
former would let you get service stats for a given set of services, and 
the latter would give you host stats for a given set of hostgroups. What I 
*really* wanted was 4 reports: Host Availability by Hostgroup, Host 
Availability by Service, Service Availability by Service, and Service 
Availability by Hostgroup.

Host Availability by Hostgroup does just what you'd expect.

Host Availability by Service finds all hosts running a given set of
services and reports on host availability for those hosts. Instead of 
grouping hosts by hostgroup, it groups hosts by service.

Service Availability by Service does just what you'd expect.

Service Availability by Hostgroup reports on all services run by a given
set of hostgroups. Grouping is done first by hostgroup, then by service.
We plan to use this to compare the services on similar servers running in
different regions.

Anyway, to get all this stuff to work I had to redo the four availability
stored procs and alter some database types. And of course do the necessary
web alterations. If nobody has a problem with that, I'll go ahead and
check it all in.

Going once, going twice.....