Service Level Agreements have garnered a lot of attention over the last few years. Reaching (and even going beyond) SLA goals is a core responsibility for IT monitoring experts. Savision continues to lead this charge by creating essential tools for IT experts to monitor and report on their SLAs.
Recently, Savision released an MP that gives users the capability to run detailed SCOM reports. These reports help users pinpoint the cause of why their SLA is lower than expected (If you haven’t yet, you can download the SCOM SLA Reporting MP here).
This article will focus on something different, specifically how to show historical SLA trends in Live Maps using the Summary Dashboard feature. Below, you can see an example of the end result of this tutorial which will provide a monthly overview of the SLAs for all your services in one dashboard.
Updated Scripts for the SCOM SLA Reporting MP
After receiving a ton of feedback from our users, we created several scripts based on common scenarios that we see with our users (see below). On top of this, we’ve also created some additional enhancements, such as giving users the capability to control the number of decimal places.
- SLA Monthly All SLO objects
- SLA Monthly Services Only
- SLA Monthly End User Only
- SLA Monthly Application Only
- SLA Monthly Infrastructure Only
- SLA Monthly Single Service
1. To add any of these scripts to a Summary Dashboard, start by opening an existing dashboard or creating a new summary dashboard. If you are opening an existing dashboard, make sure you are in Edit Mode.
2. Add a SQL Widget
3. Give your Widget a name.
4. Leave it on the Operations Manager Data Warehouse.
5. Copy the script into the Query section.
6. Click on SAVE.
You’re Done! But if you want to do some cool things…
Here Are a Few Things You Can Change in the Script
- Near the top, there are two (2) Variables that you can adjust.
SET @num_historical_months = 4 — Number of Months to display
SET @decimalplaces = 2 — Values 0 – 4
The “num_historical_months” lets you set how many months’ worth of data you wish to show. It is pulling the data from the DW database, so that will determine how far back you can go.
The “decimalplaces” variable gives you the option to show as many decimal places you want. Putting a “0” here will round the value to the nearest whole number. If you put a 2, you will get something like 99.89.
- Near the bottom of the script, you can adjust the order to have it sort the way you want.
–ORDER BY ‘ + @Last_Month + ‘ — Order by SLA for the last month
ORDER BY Name — Order by Name Alphabetically
When you are done making your changes you will get something like this:
If you have any feedback, suggestions, or questions, please reach out to email@example.com.