Iniciar sesión
 
InicioBibliotecaAprendizajeDescargaSoporteComunidadForos
Recursos para Profesionales de TI >
> 
> 
How to run reports for Problems based on specific criteria

Respondida How to run reports for Problems based on specific criteria

  • jueves, 12 de julio de 2012 18:53
     
     
    Inicie sesión para votar
    0

    Hi there,

    I am trying to run a custom report based on very specific criteia using Service Manager 2012. I want to be able to run a report with Service Manager that will give me all of the problems (active or otherwise) that specifically have this box checked in the template "Requires Major Problem Overview". Essentially, we want our manager to be able to get a report all of the problems that were marked as requiring a major problem overview.

    Thanks!

     

Todas las respuestas

  • jueves, 12 de julio de 2012 19:01
    Moderador
     
     
    Inicie sesión para votar
    0

    In the Data Warehouse, view ProblemDimVw, column RequiresMajorProblemReview, so it is very easy to report on.

    Rob Ford scsmnz.net

     
  • jueves, 12 de julio de 2012 21:08
     
     
    Inicie sesión para votar
    0

    Thanks for you fast response.

    I am still fairly new to Service Manager, and I just wanted to clarify what you mean by viewing ProblemDimVw? I included a screen shot of the Data Warehouse view, which makes sense, but where do you go from there?

     
  • jueves, 12 de julio de 2012 21:12
    Moderador
     
     
    Inicie sesión para votar
    0

    In SQL Management Studio, check the DWDataMart database. There is a view called ProblemDimVw. This contains all the problem properties, including the one you are after.

    What you can do is copy an out-of-the-box problem report and stored procedure to create a new report that can be shown in the console.

    I have some advice on creating/customising a report on my blog here:
    http://scsmnz.net/how-to-get-your-incident-logs-from-the-data-warehouse-into-your-report/

    There is also a link near the end to the SCSM blog with a further example on this subject.

    Rob Ford scsmnz.net

     
  • jueves, 12 de julio de 2012 21:13
    Moderador
     
     Respondida
    Inicie sesión para votar
    1
    P.S. You could also use the analysis cubes as you are on 2012.

    Rob Ford scsmnz.net


     
  • viernes, 13 de julio de 2012 0:04
     
     
    Inicie sesión para votar
    0
    Great, thanks a lot Rob!