SLA report on RITM

Heisenberg
Tera Contributor

‎02-17-2020 07:35 AM

Hi Experts,

We have SLAs on RITM, need to fetch a last one month report on set of assignment group and assigned to user, since there is no reference field for SLA in RITM form and SLA comes in related list how can I fetch the report where it shows both RITM fields and SLA fields, I also dont know much about database view for my requirement what should be the where clause and should I join task_SLA and sc_req_item table.

Also note we have Performance analytics in our Servicenow can I able to get the SLA report based on the mentioned requirement.

Please advice!

0 Helpfuls
  • 1,071 Views
2 REPLIES 2

Michael Fry1
Kilo Patron

‎02-17-2020 07:56 AM

There is a database view set-up out of the box to combine those 2 tables together. Table name is called: sc_req_item_sla

Slawek_Radziewi
Kilo Sage

‎02-18-2020 12:20 AM

You can use table sc_req_item_sla as Michael suggested. 

You can also use just task_sla table as I do and dot walk to display any data related to SLA or RITM fields.

0 Helpfuls