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! Smile

Vincent