The CreatorCon Call for Content is officially open! Get started here.

Which table to use to batch upload CI Relationships?

jancaasi
Mega Expert

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

1 ACCEPTED SOLUTION

larstange
Mega Sage

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

5 REPLIES 5

jancaasi
Mega Expert

Thanks for the information. 🙂