Which table to use to batch upload CI Relationships?

jancaasi · ‎06-26-2016

Hi Everyone, I am trying to locate the table to use to update the relationships of the CIs that we have. May i know which table to use? Thanks, Jan Raphael Caasi

larstange · ‎06-26-2016

Hi Jan

There are no OOTB table you can use for this purpose.

You will have to create your own import table and a transform map to create the relationships.

The relationships must be imported into the cmdb_rel_ci table and there are three fields to fill out - Parent, Child and Type.

The full way is to create a data import set

- Import Sets - ServiceNow Wiki

A quicker way is to create an "Easy import" if you are not familiar with the transform engine

- Easy Import - ServiceNow Wiki

View solution in original post

jancaasi · ‎06-26-2016

Thanks for the information. 🙂