Service Manager Billable Time Reports – Part 2: Incident Billable Time Report

Author by Christopher Mank

In the first part of this blog series, I introduced how billable time is tracked on Incidents and will show in further posts how to expand that functionality to track billable time on other Work Items and use it to track total time worked in a given time period. Part 1:  Introduction to Billable Time Reports Part 2:  Incident Billable Time Report (This post) In this second part, I am going to show how to deploy a custom Incident Billable Time Report in SSRS that shows the time worked on an Incident, using out of box functionality. The report file can be found in the Microsoft Gallery. You can download it from there to follow along with this post.  In a later post, I will show you exactly how to build custom reports (with dynamic filters) in SSRS.  But for now, I just want to show you how you can deploy this existing report. 1.  Browse out to your Reporting Services Report Manager URL.  If you are unsure of what this is, you can: 1a. Login to the server where SSRS has been configured for Service Manager.  Most people put this on the same server that contains the Data Warehouse databases. 1b. Browse to Start --> All Programs --> Microsoft SQL Server 2008 R2 --> Configuration Tools --> Reporting Services Configuration Manager. 1c. This will open the SSRS Configuration Manager.  Browse to the Report Manager URL tab and note the URLs that are listed. SSRS Reporting Services Configuration Manager image 2.  From Reporting Services, browse to the SystemCenter --> ServiceManager --> ServiceManager.Console.Reporting.IncidentManagement folder.  In here you will see all of the out of box Incident reports.  Click on the Upload file button. SSRS Incident Management Folder Reports image 3.  Browse to the report file and click OK. 4.  You will now see the report listed in the folder. SSRS Incident Billable Time Report Incident Folder image 5.  If you have the SCSM console open, close it and reopen it.  Browse to the Reporting tab and you will now have your new Incident Billable Time Report. SSRS Incident Billable Time Report Reporting tab image And give it a Run! SSRS Incident Billable Time Report SCSM Console image But Wait, There's More! If you want to be able to add your own reporting folder in the Reporting tab in the SCSM console, it's super easy to do. 1.  Browse again to the SystemCenter --> ServiceManager folder in SSRS and click on the New Folder button.  Give your new folder a name and click OK. 2.  Once you've created your custom folder, you can upload reports to it just like what's mentioned above. 3.  If you have the SCSM console open, close it and reopen it.  Browse to the Reporting tab and you will now have your new Incident Billable Time Report in your very own folder. SSRS Incident Billable Time Report Custom Folder image Stay tuned for Part 3 where we'll dive into customizing Service Manager to support the tracking of Billable Time on other Work Items and time worked in a given period. Until the Whole World Hears (and Happy Easter!!), Christopher
Author

Christopher Mank

Systems Architect