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

[mansigoel]

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?

[Dr Atul G- LNG]

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.

[PritamG]

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.