calculate incident resolve time without onhold time in reports

madhu25
Tera Contributor

Hi All,

 

How can we calculate incident resolve or close time without Onhold time in reports.

opend at:10:00 AM

Onhold at:11:00AM

In progress: 11:15AM

Resolved:11:30 AM

Total time: 1hr+15min(exculding onhold to inprogress)

 

 

5 REPLIES 5

AnubhavRitolia
Mega Sage
Mega Sage

Hi @madhu25 

 

Generally SLA Definition have pause condition as State=On Hold.

 

You can have an SLA for Resolution and there you can set Start Condition as "State=New OR Active=True" , Pause Condition as "State=On Hold" and Stop Condition as "State=Resolved".

 

AnubhavRitolia_0-1669455867698.png

 

AnubhavRitolia_1-1669455908242.png

AnubhavRitolia_3-1669455975647.png

 

 

 

Now the Task SLA of any Incident will show Resolved time excluding On Hold time in "Business Elapse Time" field as below:

 

AnubhavRitolia_5-1669456254527.png

 

 

Then generate report as below or based on your requirement:

 

AnubhavRitolia_6-1669456434628.png

 

 

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

Thanks
Anubhav Ritolia
ServiceNow Rising Star 2023

Good one! 

Hope this helps!
BR.
Ishaan Shoor

Thanks @Ishaan Shoor 

Please mark this as correct answer and helpful if it resolved, or mark this helpful if this help you to reach towards solution.

Thanks
Anubhav Ritolia
ServiceNow Rising Star 2023

madhu25
Tera Contributor

Thanks for your reply @AnubhavRitolia 

Can we implement without sla creation?