Difference between Incident_sla and task_sla Table

EKTA2
Tera Expert

Hey Team,

What is the Difference between Incident_sla and task_sla Table? Am I correct in assuming that task_sla will contain all the Incidents, Catalog Tasks and RITMs which have SLA attached to them?

Thanks,

Ekta

4 REPLIES 4

Ankur Bawiskar
Tera Patron
Tera Patron

Hi Ekta,

incident_sla is basically a database view which stores information about joining task_sla and incident table

task_sla is basically a table which stores sla information for either incident, change etc; it stores which sla is attached to which task record

Mark Correct if this solves your issue and also mark 👍 Helpful if you find my response worthy based on the impact.
Thanks
Ankur

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Jaspal Singh
Mega Patron
Mega Patron

Hi Ekta,

 

As Ankur said incident_sla is simply an OOB database view available that stores incident & related SLA while task_sla has every entry for any record that has SLA associated irrespective of Task Type.

 

Thanks,

Jaspal Singh

 

Hit Helpful or Correct on the impact of response.

Darshani Sambar
Giga Contributor

Hi Ekta,

Incident SLA will show the SLA which has been attached to the incidents.

incident SLA table stores each of  the individua SLAs attached to particular incidents.

 

Task SLA will show the SLA which has been attached to task of that request.

The Task SLA [task_sla] table stores each of the individual SLAs attached to particular task.

 

Regards 

Darshani Sambare

 

 

 

Thank you for the info.

I had the same doubt.

However, how can be explained that for a particular incident# we have more entries in TASK_SLA than in INCIDENT_SLA ?

Isn't it the ticket number the only field for joinning in the view?

Any additional condition?

 

Thanks in advance,

Javier Pelaez