which table shall I use to find history task sla

[RoxRen]

I tried sc_task_sla table, and found there are only records in this year. Is there a table contains historical data?

[GlideFather]

Hi @RoxRen,

I believe that [sc_task_sla] is a child of [task_sla], you can check that as well. The difference is that "sc_" will contain just and only catalog tasks, wheil task_sla all task records (inc, req, ritm, prb, chg, sc_task, ......).

As a starter, you can compare whether there are some older SLA data for non SC task...

Eventually there might be some archivisation in place that removes the older data. I checked in some of the instances I have currently access and the oldest records were of different age, that makes me thing that each instance may have this set differently as well.

[SwamyM]

Hi @RoxRen ,

Generally sc_task_sla records wont be deleted unless there are some data management rule defined. 
Check in you system for below rule are defined or not.

• Data Archiving is configured

• Data Retention / Data Management policies are configured

• A custom cleanup job exists

Data Management → Data Retention Rules

System Archiving → Archive Rules

System Diagnostics → Stats → Table Sizes

Please click the “Accept Solution” or “Helpful” button, if my response helped you resolve the issue.

Thanks,

Swamy