Log in  \/ 
x
x
x
Register  \/ 
x

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.
 SCSM Manual Activity SLA

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

Categories: System Center 2012 Service Manager

Yuriy Nizhnikov

Comments (2)

  • Ozge Ozkaya

    Ozge Ozkaya

    29 July 2017 at 11:15 |
    Hi, i deployed the MP and after 2 days, i ran the report. it gave me the following error. Any ideas what could be the reason?

    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

    Marat Kuanyshev

    29 July 2017 at 11:29 |
    Hi,
    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

Leave a comment

You are commenting as guest.

This is the default dialog which is useful for displaying information. The dialog window can be moved, resized and closed with the 'x' icon.