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,

[Dr Atul - LNG]

Hi @kumar22 

Try on list view

If Assignment group and assigned to is empty, means those incidents dont have any Response SLA.

[kumar22]

Hi Atul, do we have any other options to create a report on task_sla / incident_sla tables or any database views to create a report on this?

[Dr Atul - LNG]

Hi @kumar22 

No, because we are checking incident on INC table itself. If you have issue with SLA ( like not working  or something else)then we need DB view. 

As you need only Incident which dont have SLA. If you want you can create DB view and check. 

[SourabhAkiwate]

Hello @kumar22 ,

You can create a report on incident_sla table by applying below filter condition:

Also, you can add conditions like SLA  Definition > is not >(Name of your Response SLA ).

Remaining condition you adjust as per your requirement.

If my solution helped to you, then please mark my answer as Helpful.

Thanks