Report on Incidents without Response SLA

[kumar22]

Hi team, 

As per the current behavior in the system, while creating Incidents if we select the Assignment Group and Assigned to the Response SLAs are attached to this type of Incidents.

Now I would like to create a report that gives the list of Incidents which has no Response SLAs.

Please advise on this!

Thanks,

[AndersBGS]

Hi @SourabhAkiwate 

That will not work - incident_sla database view only contains records which is SLA, OLA or underpin contract. According to his request, he would like to see incidents without SLA  - that the database view will not show.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[kumar22]

Hi @AndersBGS  - I want to see the Incident report which has no Response SLA and in addition to that I don't want Incidents which having both Response and Resolution SLAs.

Thanks!

[AndersBGS]

Hi @kumar22 ,

Please see the solution I have provided to you in a similar question that you have asked. https://www.servicenow.com/community/developer-forum/report-on-incidents-without-response-sla/m-p/28...

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[SunilKumar_P]

Hi @kumar22, You can create a database view on incident and task_sla table with left join as true (task_sla), this will give you the list of incidnets with and without SLA definitions. You can then have a filter like 'SLA definition' is Empty, which will only list the Incidents which doesn't have the SLAs attached to it.

Regards,

Sunil

[kumar22]

Hi Sunil,

As per your suggestion, we can get the incident list without any SLA either Resolution or Response. 

In my case, I need the list of Incidents which has not Response SLA only.
For an example: 

This Incident doesn't have a Response SLA, because while creation of the Incident only it was assigned .

Thanks!