How can I get a report of incidents without incident tasks

[Britton]

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.

[sachin_namjoshi]

Hi,

You can create database view between incident and incident task to find out incidents with,without incident tasks.

You can mention join query in your database view.

Please check below for more details on creating database views

https://docs.servicenow.com/bundle/kingston-platform-administration/page/use/reporting/concept/c_DatabaseViews.html

Regards,

Sachin

[Adam Stout · Accepted solution]

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.

[Britton]

Very awesome, thank you!

[ddmathis]

I was able to produce a report to show Incidents with incident tasks by using the related lists and selecting when request number is not empty.   However I cannot create a report to show me when incidents do NOT have any incident tasks assigned which is the report I really want. 

Tks