Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

How we can calculate business elapsed time from servicenow incident_sla table ?

somya-gupta25
Tera Contributor

‎05-19-2025 04:07 AM

 
0 Helpfuls
  • 675 Views
9 REPLIES 9

Brian Lancaster
Kilo Patron

‎05-19-2025 09:39 AM

Why wouldn't you just display the business elapsed time field?

0 Helpfuls

somya-gupta25
Tera Contributor
In response to Brian Lancaster

‎05-19-2025 11:04 AM

Hi Brian ,

 

When i am creating report i am getting difference in business elapsed time which incident_sla is display and the business elapsed time which i am calculating manually .

 

So just want to know why i am facing this issue . 

 

Regards, 

Somya 

0 Helpfuls

AndersBGS
Tera Patron
Tera Patron

‎05-19-2025 12:01 PM

Hi @somya-gupta25 ,

 

 business elapsed is available OOTB. What is it that you’re missing?

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

0 Helpfuls

somya-gupta25
Tera Contributor
In response to AndersBGS

‎05-20-2025 02:57 AM

Hi Ander , 

 

Thanks for your response . 

 

I am getting duration difference in business elapsed time in incident_sla table and the business duration for a ticket.

 

Regards, 

Somya 

0 Helpfuls