I am trying to build a report that shows RITMs that have breached the SLAs and associated SC tasks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-03-2023 07:12 PM
Hi,
I am trying to build a report that shows RITMs that have breached the SLAs and associated SC tasks. So far I am only able to build a report that show RITMs that have breached SLAs using the sc_req_item_sla table but not able to pull the sc_task information in the report.
I also tried to build a report using task_sla table that shows SLA breach for incident as well as RITM but I am not able to show what sc tasks were under the RITM.
Note: We do not have SLAs for SC tasks and SLAs are only associated with RITMs and Incidents.
However, I am able to show RITM SLA on the SC task related item list.
So how can I show a list of RITMs that have breached the SLA and their SC tasks (with task information of assignment group and assignee)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-04-2023 02:25 AM
Hi @AmolP ,
Hope you are doing well.
I guess you have to join sc_req_item_sla and sc_task table by creating a database view.
Please mark this response as correct or helpful if it assisted you with your question.
Regards,
Harshal