Reputation: 11
I'd like to create a report in ServiceNow to list all incidents for a specified Assignment Group which do not have any Affected CIs.
I can create a report of incidents that do have Affected CIs using the task_ci table, but entries are only added to that table if a CI is affected. Is there a way to list incidents that do not appear in this table?
Upvotes: 1
Views: 3004
Reputation: 166
There is another way to do this directly on the List view if you have list v3 plugin enabled in your instance.
You can navigate to the incident list view and apply this filter on the related list
Make sure you specify the condition for Related list as Affected CIs Equal to 0
Upvotes: 1
Reputation: 11
Using the Report Designer interface that was introduced in Jakarta, you can add filters on Relationships.
Simply add the relationship filter for no Affected CIs (you do not need any conditions) under the main filter on the Incident table. (refer screenshot below)
The ability to report on record relationships is not available without using the Report Designer.
For future ServiceNow questions, you're more likely to get an answer by creating a community account and posting there: https://community.servicenow.com
Upvotes: 0