Reporting Business Elapsed Time for Requested Items

HARITHA KHAREED
Tera Contributor

Hi All,

  I need report for all requested items Business Elapsed Time.

 

Thanks,
Haritha

1 ACCEPTED SOLUTION

Hi @HARITHA KHAREED 

 

allright, then just utilize the OOTB database view sc_task_sla as table (shown below):

 

AndersBGS_0-1711012189785.png

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

 

best regards

Anders

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/

View solution in original post

8 REPLIES 8

Hi @Dr Atul G- LNG ,

 

No database view is needed - all fields can be obtained by dot-walking.

 

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

 

best regards

Anders

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/

Hi Atul,

I have created an SLA definition for the sc_task  table, but I want  report on requested item details with Business Elapsed time.

Thanks

Haritha

Jaspal Singh
Mega Patron
Mega Patron

Hi Haritha,

You can check for comments from Deepak on thread for detailed steps.

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @HARITHA KHAREED 

AGLearnNGrow_0-1711012195517.png

 

A sample view.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************