Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
If you already have a query like this it would be a great help to share it. Else i start building and hope for the best, as im not into SCOM whatsoever.
Thankyou.
Quality over Quantity
Solved! Go to Solution.
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 🙂
Quality over Quantity
Hi @EricHulshof ,
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-d...
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] S
And ofcourse added some magic making sure i had the correct names etc and not the cryptic id's 🙂
Quality over Quantity
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?
Hi!
I'm trying to do that report with Power Bi, but the query take a lot of time to complete. Do you have a new version of the query?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |