question Re: List of CI.s Upstream and downstream in ITSM forum

List of CI.s Upstream and downstream

pramn — Fri, 30 Jan 2026 16:55:14 GMT

Hi Mates,

one of my clients needs for reporting purpose List of CI.s Upstream and downstream data ..

Is there any possibility to get those data .

or need to write any scripting .

Need your help !

Thanks

Re: List of CI.s Upstream and downstream

Dr Atul G- LNG — Fri, 30 Jan 2026 17:07:05 GMT

Hi @pramn

https://www.servicenow.com/community/itsm-forum/ability-to-export-all-upstream-and-downstream-ci-s-for-a/m-p/519983

https://www.servicenow.com/community/itom-forum/how-to-get-data-cmdb-ci-upstream-and-downstream-data-in-audit/m-p/3333020

https://www.servicenow.com/community/platform-analytics-forum/hi-all-is-there-a-way-to-report-on-the-quot-upstream-downstream/m-p/1279254

Re: List of CI.s Upstream and downstream

Its_Sagnic — Fri, 30 Jan 2026 19:07:37 GMT

Hi @pramn ,

In ServiceNow, all CI relationships are stored in the CI Relationship table (cmdb_rel_ci).
Whenever a relationship is created between two CIs, the platform automatically inserts a record into this table with:

a Parent CI
a Child CI
and the Relationship Type (e.g., Depends on, Contains, etc.)

✅ Creating a Report

If your requirement is to report on upstream/downstream CIs, you can build a report directly on the cmdb_rel_ci table.
To get all CIs related to a specific parent CI, set:

Table: cmdb_rel_ci
Group By: Parent
Apply filters as needed.

This will give you a list of all child CIs related to each parent CI.

✅ Retrieving Child CIs via Script

If you want to programmatically list the child CIs and print their names in the logs, you can use the following script:

var gr = new GlideRecord('cmdb_rel_ci'); gr.addQuery('parent','14bca7efdb0c10104779141b13961998');//the sys_id of parent CI . var count = 0; gr.query(); while(gr.next()){ count++; gs.print ('The Child name ' +gr.child.name+' is '+count+' th child'); }

This script loops through all relationship records where the specified CI is the parent, counts them, and prints each child CI’s name and order.

If this solution helps, please mark it as Helpful and Accept the Solution to close the thread.

Regards,

Sagnic

Re: List of CI.s Upstream and downstream

pramn — Mon, 02 Feb 2026 04:00:11 GMT

HI,

This script is not printing the records , looks like its executing .

Re: List of CI.s Upstream and downstream

Its_Sagnic — Mon, 02 Feb 2026 14:49:22 GMT

Hi @pramn ,

Is it possible to share the code that you used in your case..

Because in the 2 nd line of the code I mentioned that you need to replace the sys_id of the parent with your Ci's sys_id

gr.addQuery('parent','14bca7efdb0c10104779141b13961998');//the sys_id of parent CI .