Aging report - 30/60/90 days for Incidents and Changes

cdula1
Kilo Explorer

I want to generate ONE report that covers aging for Incidents and Changes. Can anyone tell me how to do that? Thanks!

8 REPLIES 8

Taarik
Kilo Explorer

This may be possible using some extra fields and business rules. Basically, create one field (multiple fields may work too) with the aging status. Then use a business rule to update the field after the time has passed. You can then build a report using the aging field(s).

HTH..


williamsun
Mega Guru

The way I did it was with a Gauge on a Homepage, modifying the current Task Gauge for ITIL Summary Counts make one line for each aging level adding the appropriate filters using the existing Last 30 days, Last 60 days and Last 90 days options for each.

I have attached an image of what the output looks like, unsure if this would suffice.
It is nice as you can click and drill into these as links as well.


Hi William,



Can you please show us step by step how did you achieve the above result.



Thank you.


Hi Namrata,



To implement what William has mentioned above, you need to goto Gauges in the left nav. Create a new Gauge with Type as Count and Aggregate as Count and table as Incident(or Change). Submit the form, then go to the related list Count Gauges, create a new one with table as Incident(or Change) and provide the filter as per your requirement say created last month and status is not resolved etc. Add Count gauges for 30,60 and 90 days like this.



You can then go to your homepage and add this gauge to that. Below link can guide you on how to do that.



http://wiki.servicenow.com/index.php?title=Adding_Existing_Gauges_to_a_Homepage#Adding_Existing_Gaug...



Hope this helps



Thanks & Regards,


Hari