Sign in
 
Home2012Previous VersionsLibraryForumsGallery
System Center TechCenter >
> 
> 
SCSM Dashboards

Answered SCSM Dashboards

  • Tuesday, March 01, 2011 11:05 AM
     
     
    Sign In to Vote
    0

    Hi,

    Is there a way to use the SCSM Dashboards but narrow down the results according to certain people.

    For Example, i would like to use "Incidents within Target Resolution Time (%)" and "Time to Resolution" for departments as well as overall, is this at all possible?

     

     

All Replies

  • Tuesday, March 01, 2011 8:11 PM
     
     Answered
    Sign In to Vote
    0

    You can open the page in Edit mode, then edit the approriate dataset.  Hint.  Just type in "Incident" in the Dataset configuration name box, and it will automatically show all incident data sets. 

    Select the dataset you want to edit, click Create/Edit button, then expand the minimzed Dataset pane (click on the plus icon).  When the pane expands, you will see a "SQL query" text box where you can edit the query.  Don't forget to click the Save and Close button at the bottom of the webpart when you are done.

     
  • Thursday, March 03, 2011 6:04 AM
     
     
    Sign In to Vote
    0

    I realise I am pushing my luck, would it be possible to get a sample of the SQL query to "limit" my selection.

     

    :)

     
  • Friday, March 04, 2011 8:38 AM
     
     
    Sign In to Vote
    0

     

    Giving an example without knowing your actual situation (i.e. department names; variables etc.) is a little bit hard.

    What you should do is have your (or a) DBA / SQL help you in creating the proper query. You can than easily add that query to the dashbaord as described above...

     
  • Friday, March 04, 2011 5:17 PM
     
     Answered
    Sign In to Vote
    0

    Hey Fletcher

     

    I assume that your not a DBA...apologies if i have miss assumed..... I am not a DBA either but if you look at the blog written by Chris Lauren @ MSFT, this will hep you achieve what your trying to do. I am on a train at the moment so cannot access my Test Lab but it should put you on the right track. Its helped me out no end in the past.

    http://blogs.technet.com/b/servicemanager/archive/2010/06/29/new-system-center-service-manager-webcasts.aspx

    Reporting and Business Intelligence with Service Manager 2010 (with Chris Lauren, Monday, June 28th @ 1pm (PT)).
    Microsoft System Center Service Manager 2010 includes an extensible data warehouse and reporting platform with many reports out of the box. In this demo-packed webcast, I’ll show you how to use and customize these reports as well as create your own using Report Builder. To wrap up the session, I’ll show you how to setup the Service Manager dashboards. This will be a moderately technical session.

    Regards

    JR52MAR

     
  • Monday, March 07, 2011 3:35 PM
     
     
    Sign In to Vote
    0

    The Link s perfect but i am getting different data, it isbringing back the "enum" value for the IncidentClassificationValue

    What have i done wrong?

     It is only displaying some of the names correctly.

    Please , any advice on this.?