Forum Discussion
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. ...
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] SAnd ofcourse added some magic making sure i had the correct names etc and not the cryptic id's 🙂
Hi Anonymous ,
Sorry for that, but we did not familiar with the SCOM, are you meaning something like the report in this showcase? https://powerbi.microsoft.com/en-us/partner-showcase/data-maru-inc-system-center-operation-manager-dashboard/
Best regards,
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] SAnd ofcourse added some magic making sure i had the correct names etc and not the cryptic id's 🙂
