How to create a report that will just show the first Response SLA attached to the incident?

mansigoel
Tera Contributor

‎02-05-2025 11:30 PM

Hi,

 

As per the requirement, we had made the retrospective start unticked in Response SLA. Now, I want the report of the incident SLA's (Response) which was first attached to the ticket.

 

Can someone help me in this?

0 Helpfuls
  • 500 Views
6 REPLIES 6

Dr Atul G- LNG
Tera Patron
Tera Patron
In response to mansigoel

‎02-05-2025 11:46 PM

Hi @mansigoel 

 

There is no way to do or you can sort by created time and then group by task. Let's wait for other inputs.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls

PritamG
Mega Guru

‎02-05-2025 11:54 PM

you can generate a report for the first attached Response SLA in ServiceNow using Report Designer or Database Query.

steps to create the report

  1. go to reports → create new.
  2. select table: choose task SLA [task_sla] table.
  3. Apply Conditions:
    • SLA definition = response SLA
    • sort by start time (ascending) to get the first attached SLA.
    • filter by task type = Incident (if needed).
  4. choose type: use a list report or pivot table.
  5. run & save the report.

alternatively, use a scripted report or query on task_sla table to fetch the first SLA per incident.

 

0 Helpfuls