SCSM Reporting: Dataset for Incident Requests

It’s Christmas time again, and that means it’s time for another SQL query for Service Manager reporting. 🙂

This query gives you a dataset in list form to work with in Excel or PowerBI, containing the following informations related to Incident Requests.

ID
Classification
Closed Date
Created Date
Created Day
Created Month
Created Year
Created Week
First Response Date
Priority
Resolution Category
Resolved Date
Resolved Day
Resolved Month
Resolved Year
Resolved Week
Source
Status
TargetResolutionTime
TierQueue

You will need to run the SQL query against the Service Manager Data Warehouse database DWDataMart.

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

Untitled

Mary Christmas

By | 2015-12-07T13:00:00+00:00 December 7th, 2015|Service Manager (SCSM), SQL|2 Comments

About the Author:

Brian Fahrenholtz

2 Comments

  1. Hunter May 3, 2017 at 20:19 - Reply

    This seems pretty useful, is there a way where this incident dataset is available for download? thanks

    • Brian Fahrenholtz May 4, 2017 at 13:50 - Reply

      You can mark and copy the SQL query, and then paste it into a SQL query or Excel data connection.

Leave A Comment