Jump to content

Summary Report for Incident, Problem & Change


Recommended Posts

Hi all,

Before I spend hours potentially reinventing the wheel, does anyone have a monthly overview/summary report showing some of the below in one report that they can share?

  • No. Incidents Logged
  • No. P1/P2 Incidents Logged
  • No. Incidents Resolved
  • No. Service Requests Logged
  • No. Service Requests Resolved
  • % Within SLA (Inc & SR)
  • No. Changes Logged
  • No. Changes Closed
  • No. Problems Logged
  • No. Problems Resolved

Thanks in advance

Link to comment
Share on other sites

@dwalby - if you need monthly numbers my advice would be to use measures...

So, for logged and resolved requests (incidents, service requests, changes and problems):


* for Logged: have separate measures for each request type and change the "Query where clause" to match each request type
* for Resolved: in addition to the above, change "Date Ranging Column" to Date Resolved (h_dateresolved)
* for P1/P2 incidents logged: in the "Query where clause" add this: AND h_fk_priorityname IN ('P1', 'P2')


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...