11
May
2016
A report for Manual Activities with SLA details including Duration and Active Duration
One our potential customer has asked us about a report with SLA details including durations for Manual Activities in SCSM 2012 like the ones we built for Incidents and Service Requests. The customer employed SLO for Manual Activities and wanted to get a clear picture for each SLO instance.
Our developer realized the idea and the result you see on the screenshot below.
To start using the report, simply import SCUtils.ManualActivityWithSLAInformation.Report.Library.mpb management pack and wait until the Service Manager management server synchronizes with the Data Warehouse.
The archive with the management pack is here.
Comments (2)
Ozge Ozkaya
Date: 7/29/2017 8:10:42 AM
Application:
Application Version: 7.5.2905.0
Severity: Error
Message:
System.Exception: An error has occurred during report processing. ---> System.Exception: Query execution failed for dataset 'Table_Activities'. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at Microsoft.Reporting.WinForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension)
at Microsoft.Reporting.WinForms.ProcessingThread.ProcessThreadMain(Object arg)
System.Exception: Query execution failed for dataset 'Table_Activities'. ---> System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
--- End of inner exception stack trace ---
System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors
reply
Marat Kuanyshev
This report uses the information about SLA instance's duration so SCUtils SLAInstanceDuration is required. You can customize the report for your own purpose.
reply