SCOM SLA Dashboards with Power BI for O365 – Part 1

First I would like to mention that if you don’t need connectivity to On Premise data you can sign up for a free Power BI account read more about it here.

Before you can jump into building these reports you will need to configure the Service Level Target (SLT) and Service Level Objectives (SLO) in SCOM here is a good walk through by Kevin Green of how to configure the SLT and SLO.

Part 1 – Setting up the data for our dashboard

First we are going to create a table to store our data for this report.

Next create the following stored procedure.

Now run the following query to get the information about the SLTs and SLOs that are configured in SCOM, we will use this information to build another stored procedure.

The results will look something like this

clip_image002

This provides the mapping for each SLT to SLOGUID and ManagedEntityRowID, if you are using more than one SLO per SLT you may need to modify the query a bit more, I am only reporting on one SLO so this query works for my dashboards.

In the next blog post I will show you how to use the stored procedure in this post to populate the table we created and then build a Power BI dashboard with your SCOM SLA data.

2 comments

    1. Part two is in progress but I want to port the solution to the Power BI designer/powerbi.com, currently it is built on Power BI for O365.

Leave a Reply

Your email address will not be published. Required fields are marked *