I am trying to build a report that shows RITMs that have breached the SLAs and associated SC tasks

AmolP
Tera Expert

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)

1 REPLY 1

Harshal Aditya
Mega Sage
Mega Sage

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.

https://docs.servicenow.com/en-US/bundle/utah-platform-administration/page/use/reporting/concept/c_D...

 

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

Regards,
Harshal