We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

Need the Response and Resolution SLA timeline

nameisnani
Giga Sage

Hi Team 

 

can anyone please help me on this - 

 

we Need the Response and Resolution SLA timeline data 

 

from i can find this please provide me steps , i have to extract that data . 

 

from which table i can find this data .

 

Thanks

5 REPLIES 5

VaishnaviK3009
Kilo Sage

1. task_sla

  • Main SLA record

  • Start time, end time, breach, duration, stage

  • Use this table for reports and exports

Steps to get the data:

  • Go to All → Service Level Management → SLA → Task SLAs

  • Filter by:

     
    task = <your incident/change/etc>
  • Export the list (Right-click header → Export → Excel/CSV)

2. task_sla_history

  • SLA timeline events

  • Pause, resume, start, stop history

Steps:

  • Open any task_sla record

  • Scroll to the related list

  • Open SLA History (task_sla_history)

  • Export if needed

If You Want to Extract the Data for Reporting

Step-by-step

  1. Go to Reports → Create New

  2. Table = task_sla

  3. Add conditions like:

     
    SLA = Response OR SLA = Resolution
  4. Add columns:

    • Task

    • SLA

    • Stage

    • Start time

    • End time

    • Actual duration

    • Business duration

    • Breached (true/false)

 

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for.

Thank You