Reporting Business Elapsed Time for Requested Items

[HARITHA KHAREED]

Hi All,

  I need report for all requested items Business Elapsed Time.

Thanks,
Haritha

[AndersBGS]

Hi @HARITHA KHAREED ,

Based on your requirement, I guess that you have created an SLA definition for the sc_req_item table - correct. If yes, then you can create a report based on the task_sla table and then dot-walk to the sc_req_item table. 

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

best regards

Anders

[HARITHA KHAREED]

Hi Kilo,
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

[AndersBGS · Accepted solution]

Hi @HARITHA KHAREED 

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

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

best regards

Anders

[Dr Atul G- LNG]

Hi @HARITHA KHAREED 

Do you have SLA on RITM? If yes, then you can create the report on SLA table and if need more, then better to create Database view of SLA table and RITM table.