Please note this article is out of date; links/downloads may no longer work as originally intended.
Traditionally, getting the most out of reporting in Service Manager (SCSM) can be challenging. Gaining the visibility and information out of the reports can be time consuming and difficult, using SQL reports or excel pivot tables to get the information required.
At PowerON we’ve been working hard to make reporting more accessible and take the pain out of System Center reporting. With the success of our community Power BI Configuration Manager Dashboard, I felt it was a good time to give back to the community and release PowerON BI Service Manager SCSM Dashboard – Community Edition!
With feedback from our customers and using our expert knowledge of SCSM, we’ve adapted our PowerON BI Service Manager Pro Dashboard to give the community a snippet of what is capable with Power BI and SCSM.
PowerON BI Service Manager SCSM Dashboard – Community Edition
This Power BI report enables you to view Incident and Service Request information from System Center Service Manager 2012 R2 and above.
It queries the SCSM DWDataMart SQL database to retrieve SCSM information and presents it in Power BI Desktop. This then allows you to dynamically filter your data in a more visual way.
SCSM Dashboard Version
– 1711 Release Version
– Incident Overview
– Service Requests Overview
– Edit Language in settings
– Edit Company in settings
– Filter number of days returns from DW data.
Incidents (IR)
This provides an overview for incident management around:
– IR by Classifications
– IR by Support Group
– Total IR by Status
– IR by Affected Users
– IR by Assigned to Users
– IR by Urgency
– IR by Impact
– IR by Month and Year
– IR by Time Blocks *Allows you to see IR’s by raised time giving you visibility of how busy you Service Desk is by time.
– Table overview
Service Requests (SR)
This provides overview information for service requests around:
– SR By Classifications
– SR By Support Group
– Total SR by Status
– SR by Affected Users
– SR by Assigned to Users
– SR by Urgency
– SR by Priority
– SR by Month and Year
– SR by Time Blocks *Allows you to see SR’s by raised time giving you visibility of how busy you Service Desk is by time.
– Table overview
SCSM Dashboard Installation Guide
DOWNLOAD the Dashboard Ensure you have at least read access to the SCSM SQL Database and you can access the Internet from the machine running Power BI Desktop. Download the file and the latest Power BI desktop ( find the lastest BI desktop ). Once installed Open Power BI. 1. Go to File > Options and Settings > Options. 2. Under Privacy enable Fast Combine to file privacy. 
3. Under Security untick “Require user approval for native SQL database queries”. 
4. Select Edit Queries to load the Query Editor. 
5. Supply parameter information in the Setup section. 
– SCSM DW SQL ServerSpecify the SCSM Data Warehouse SQL Server name or instance. – SCSM DW SQL DatabaseSpecify the SCSM Database name (you shouldn’t need to change this unless you’ve changed the name from default). – LanguageSpecify language if not using default. (Note: this is as is and not fully supported as not had chance to test) – Organisation NameSpecify your Organisation name. – Filter Days By default “0” will return all the records from the SCSM DWDatamart, if you want to limit the data returned, you can specify the number of days to returned with this field (for example, 365 days would bring back the last 365 days worth of records.
6. Select the “Incident” or “Service Request” query under the Service Manager folder and supply any credentials required to access the database. 
7. If prompted, Click OK on the encryption support message. 
8. Close the Query Editor and load the data
