calculate incident resolve time without onhold time in reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-25-2022 09:41 PM
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)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-26-2022 01:54 AM
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".
Now the Task SLA of any Incident will show Resolved time excluding On Hold time in "Business Elapse Time" field as below:
Then generate report as below or based on your requirement:
Thanks
Anubhav Ritolia
ServiceNow Rising Star 2023

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-26-2022 05:35 AM
Good one!
BR.
Ishaan Shoor
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-26-2022 06:20 AM
Thanks @Ishaan Shoor
Thanks
Anubhav Ritolia
ServiceNow Rising Star 2023
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-26-2022 08:48 PM - edited 11-26-2022 08:50 PM
Thanks for your reply @AnubhavRitolia
Can we implement without sla creation?