Do you use System Center Service Manager, and do you or your boss want to know how many Incident Requests the support team are resolving within the same day as it was created? If yes, then you are on the right blog post.

Run the query below against the Data Warehouse database DWDataMart, and you will get a monthly trend report on resolved Incident Requests.

Configure variables in the Query
There are two variable in the Query you need to configure before you run it.

SET @Year = 2014; define the year the request was resolved

SET @Supportgroup = ‘1. Level Support’; define the support group you want analyze

The output will be like below, when you using it in Excel.



Mary Christmas