SCOM 2007: Availability Report – Downtime reference matrix

If one day, you try to develop an availability report from scratch for your organization it might be a bit confusing to navigate through the SCOM reporting datawarehouse.

To help you, I formalized the different references according to downtime type.

	SCOM Legend Color	Enum value used by native SCOM stored procedures	Database reference
(Downtime)	Red	0	InRedStateMilliseconds
(Uptime)	Green	1	InGreenStateMilliseconds
Warning	Yellow	2	InYellowStateMilliseconds
Unmonitored	White	3	InUnmonitoredStateMilliseconds
Monitor disabled	Light gray	4	InDisabledStateMilliseconds
Unplanned maintenance	Black	5	InUnplannedMaintenanceMilliseconds
Planned maintenance	Blue	6	InPlannedMaitenanceMilliseconds
Monitoring unavailable	Gray	7	HealthServiceUnavailableMilliseconds

Enjoy reporting availability with SCOM!

Vincent