How to report on time between state changes

StewartF
Tera Expert

One of our managers is requesting SLA timelines/reporting on how long it is between an Incident being opened, to the state changing to In Progress. So not the base SLA timer that starts once the state changes, but some way of reporting on how long between the ticket being opened, and the state changing to In Progress.

OOB I can't see a way of doing this via reporting, so hoping someone can shed some light for me?

1 ACCEPTED SOLUTION

Ankur Bawiskar
Tera Patron
Tera Patron

Hi,

you can report on incident_metric table and use the metric capability and give condition as Definition = Incident State Duration

find_real_file.png

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

View solution in original post

6 REPLIES 6

if we wanted to achieve same on customer service case sn_customerservice_case table how to do it 

suvro
Mega Sage
Mega Sage

You can create a duration type field and whenever state changes to in Progress from New a business rule can set the duration field with the difference of created on and current date. 

That field can be used for reporting

You can also check out Metrics