- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-07-2024 12:48 AM
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.