Difference between Incident_sla and task_sla Table

[EKTA2]

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

[Ankur Bawiskar]

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

[Jaspal Singh]

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]

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

[Javier Pelaez]

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