How do I report on incidents that have multiple Affected CIs?

fthomas
Kilo Contributor

‎02-06-2018 02:51 AM

Hi, this may be a stupid question so bear with me...

I am attempting to report on the incident table and want to only see incidents that have a specific CI in the related Affected CIs list. This will normally be the second entry in this list.

How do I do this?? I can filter out by any CIs that are on the actual form but not the ones that are on the related Affected CIs.

Thanks in advance

Labels:
0 Helpfuls
  • 1,512 Views
2 REPLIES 2

Josh Cooper
ServiceNow Employee
ServiceNow Employee

‎02-06-2018 11:38 AM

In later versions of ServiceNow that use "List v3" - you have the option of reporting using "Related List Conditions".  



find_real_file.png



Here's the link to the Docs site that discusses it:



Add related list conditions



Hopefully that helps!



If you're already on Istanbul or Jakarta, you may already have access to List v3, you may just have the system property disabled.   You'll want to test it out though, if your instance is VERY busy, it might have some performance implications


Preview file
237 KB

fthomas
Kilo Contributor
In response to Josh Cooper

‎02-07-2018 01:21 AM

Thanks Josh, that's very helpful.



We are currently on Istanbul patch9a but I cant see the identifiers for List v3. I will briing this up with our SN Development guys when I next meet them to see what they recommend.



When you say it may have some performance issues, is this for the person running the report or overall for the whole service?


0 Helpfuls