How can I get a report of incidents without incident tasks

Britton
Mega Contributor

As the title says I'm struggling to get a report that shows resolved/closed incidents with and without associated incident tasks.  I can only get it to give resolved/closed incidents with associated tasks but not when there is an incident without an incident task.

1 ACCEPTED SOLUTION

Adam Stout
ServiceNow Employee
ServiceNow Employee

This is my main use case for Related List Conditions.  Here are the docs:  https://docs.servicenow.com/bundle/kingston-platform-user-interface/page/use/using-lists-v3/task/cre...

You need to be using the Report Designer (the new UI) to get the new condition builder.  With this, you are only a couple of clicks away from your report.  You can also easily do things like having one report with "No Tasks" and other with "No Active Tasks" or perhaps "No Tasks Assigned to the Incident Assignment Group".  A whole world of possibilities.

View solution in original post

8 REPLIES 8

abehad
Tera Contributor

Here's how you return Incidents with no tasks:

In the 'Related Conditions' section, it says 'Greater than/Less than 1' by default. Click it, and select 'None', and then run the query without selecting any more sub-conditions.

 

To return the incidents with no tasks, select the incident table in step 1, and in the 'Configure' step, select the range of incidents as your primary query. In the Related List Conditions, select 'None' - 'Incident Task - Incident'. Running this query should give you the correct list.

This link doesn't work anymore ... can we have a new link ?

Nadia6
Tera Contributor

Same thing here, I'm not able to build a report for incidents with NO ITASK ...

abehad
Tera Contributor

Here's how you return Incidents with no tasks:

In the 'Related Conditions' section, it says 'Greater than/Less than 1' by default. Click it, and select 'None', and then run the query without selecting any more sub-conditions.

 

To return the incidents with no tasks, select the incident table in step 1, and in the 'Configure' step, select the range of incidents as your primary query. In the Related List Conditions, select 'None' - 'Incident Task - Incident'. Running this query should give you the correct list.