How can I Search for a Change using an Affected CI?

[robbfreeman]

I posted this earlier but without my title as a question.   It garnered over 600 views, so I know people are interested in this topic - but no one left any replies.   So I'm reposting with a title indicating this is really a question.   If you have an answer - please share it.   If you're having the same problem, please indicate that also so we know how many people are having the same issue.

I truly hope I'm missing something obvious here.   In a Change, there is the "Configuration Item" field... that when an item is placed in it - it also populates a row in the "Affected CI" tab of the change.   That's all well and good - and - as long as the CI I'm looking for is the ONE noted in the "CI" field of the ticket, I can search for it.

But what happens in the case of having multiple CIs affected by a Change?   We can easily add more CIs in the Affected CIs tab, but searching for them from the Change list view never finds them.

I checked a Demo instance to make sure we didn't break anything in our instance and it functions the same in Demo (no manually added Affected CIs will be found when searching for a change from the list view).

Can someone please educate me how to find a change based on a CI that was manually added to the Affected CIs tab please?

Thanks,

Robb

[mottag]

Affected CIs is a many-to-many relationship...it lives in another table (that is, there is no field in the Change record to look at).

Depending on what you want to accomplish, you might try Hierarchical Lists - ServiceNow Wiki.   Alternatively, you might add the "Change Request -> Configuration Item" related list to the CIs, the look at the CI record find related Changes.