Auto Populate Affected CIs - Change Management

[abhinav_khanna]

Hi all,

This is an urgent requirement and I am unable to find a solution.

Query -

Based on the CI selected in the "cmdb_ci" field in the Change Request form, all the downstream and upstream CIs should auto populate in the Affected CI's related liste

Currently this functionality is through the BSM Map, where we have to go one by one and right click on the CI and the add the CI to the affected CIs.
I want to automate this whole process .
Kindly help me out with this one.

Regards
Abhinav Khanna

[PeterWiles]

The table "cmdb_ci_rel" holds the relationships between CIs.

You could look at this table. along with the relationships you want to add, and loop through each one.

Pete

[Mark Stanger]

This SNGuru post should be exactly what you need.   There's no need to get all downstream AND upstream CIs though.   What you're looking for with BSM relationships is impact so you'll only want to go in one direction to show the CIs that are potentially impacted by a change.

http://www.servicenowguru.com/scripting/script-includes-scripting/walking-servicenowcom-cmdb-relatio...

[abhinav_khanna]

Impacted Services is a UI action which is already available
but yes the walking through of the CMDB relationship tree is really helpful.

What is required for me is to grab all the downstream and upstream CIs, what can I say they want it.

[mathankumar2]

Hi Abhinav,

Please post the solution if in case you have implemented it.

Thanks,

Mathan