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 Community Dashboard!
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 Community Dashboard
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.
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
