Avik2
Giga Guru

Hi,

 

While there might be no other table apart from the sys_audit or sys_history_audit table and it might still not work since reporting directly on these fields can bring in performance issues.

Alternatively you can try the following

1. Create a Custom table with the below fields -

     Incident - reference to Incident record

     Assignment Group - reference to group

     Start Date - date/time field to hold start time

     End date - date/time field to hold end time

     Duration - hold the duration

 

2. Create BR to create entry to above table whenever there is change in Assignment Group

3. Create Data Base view between Task_sla table - Incident Table and the above custom table

4. Generate report on database view

 

Please mark this response as correct or helpful if it assisted you with your question.