Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

SCOM Availability report query

I am just wondering if anyone ever made a query to create a SCOM Availability report in Power BI. I basically want to rebuild the SCOM report where it shows the % availability of each application.  ...
Interesting Links
Show and Tell
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks for trying to help, but no i was not looking for that.

    For other people looking for availability i fixed it with this query:

    Select
S.ManagedEntityMonitorRowId,
S.DateTime,
S.Date,
S.InRedStateMilliseconds,
S.InYellowStateMilliseconds,
S.InGreenStateMilliseconds,
S.InWhiteStateMilliseconds,
S.InDisabledStateMilliseconds,
S.InPlannedMaintenanceMilliseconds,
S.InUnplannedMaintenanceMilliseconds,
S.HealthServiceUnavailableMilliseconds
FROM [OperationsManagerDW].[dbo].[vStateDailyFull] S

    And ofcourse added some magic making sure i had the correct names etc and not the cryptic id's 🙂


Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for trying to help, but no i was not looking for that.

For other people looking for availability i fixed it with this query:

Select
S.ManagedEntityMonitorRowId,
S.DateTime,
S.Date,
S.InRedStateMilliseconds,
S.InYellowStateMilliseconds,
S.InGreenStateMilliseconds,
S.InWhiteStateMilliseconds,
S.InDisabledStateMilliseconds,
S.InPlannedMaintenanceMilliseconds,
S.InUnplannedMaintenanceMilliseconds,
S.HealthServiceUnavailableMilliseconds
FROM [OperationsManagerDW].[dbo].[vStateDailyFull] S

And ofcourse added some magic making sure i had the correct names etc and not the cryptic id's 🙂


Deb_123's avatar
Deb_123
New Member
3 years ago

Hi. Just stumbled across this post. Do you know how can I modify the query so that I can get the info extracted hourly instead of daily?