Report on ITASKs without an SLA Definition applied

[Roberto D_Amato]

Hi Experts,

Our Stakeholders noticed that many ITASKs do not have an SLA Definition applied to them.
Upon inspection we've noticed that those records have been created directly in State 'Closed Complete', therefore didn't match the SLA Definition conditions.

We tried to report against those records via "task_sla" Table ('Task Type IS Incident Task' / 'SLA Definition IS EMPTY'), however it doesn't give us any results.

Is there a way to fetch those records?
If a new database view is required, would you know how to properly configure it?

Thanks!
Roberto

[Dr Atul G- LNG · Accepted solution]

Hi @Roberto D_Amato 

Thanks for update and Happy New  Year.

FOR DB

https://docs.servicenow.com/bundle/vancouver-platform-administration/page/use/reporting/task/t_Creat...

Also you can check OOTB DB to get an idea

The important point is where Clause.