Reporting Business Elapsed Time for SRs

[ranabiswas]

Hi All,

Could anyone please let me know how the "Business Elapsed Time" can be reported for SRs.

Requirement in Detail:

User will be reporting using the sc_req_item table and needs to know the Business Elapsed Time for all the SRs.

Thanks in advance.

[Deepak Kumar5]

[ranabiswas]

Hi Deepak,

User will be using the sc_req_item table, neither sc_req_item_sla nor task_sla.

Could you please let me know using this table how Business Elapsed Time can be added to the report.

Thanks.

[Deepak Kumar5]

if you are not using SLA then from where you want to pull Business Elapsed Time ?

[ranabiswas]

Yeah, I also thought of that.

I just wanna know if the following approach is correct.

• Create a custom field in Requested Item table.
• Query the task_sla with the Number (here which is actually the Task) field.
• Get the value of Business Elapsed Time from there and map the value to custom created field for reporting purpose.

Will this work or are there better options to achieve the same.