View tasks were SLA's were not attached

Gerald13
Giga Contributor

Is it possible to view tasks (incident, ritm etc) where SLA's were not attached?

7 REPLIES 7

-O-
Kilo Patron
Kilo Patron

You could create a simple report of type list with a No related list condition:

find_real_file.png

Here I have created one that lists all Incidents with no SLAs attached. You can - of course - e.g. select an SLA defintion condition in the Related List Conditions so that you only check for certain SLAs. And you can report on Task directly and limit the records to include by Task type (Incident, Requested Item, etc).

I found this helpful thank you for answering this question @-O- 

You're welcome! 🙂

Community Alums
Not applicable

Hi @Gerald ,

You create a database view between sc_req_item and task_sla. It needs to have a left join of the sc_req_item table - this will make the view display all items, mo matter if they have a sla or not.

 

find_real_file.png

 

Then you can simply search in the view for all the ritm which have no sla definition

find_real_file.png

 

Mark my answer correct & Helpful, if Applicable.

Thanks,

Sandeep