Import CMDB CI relationships

[dustin_hux]

I am currently populating a very simple CMDB and for this step, I am dealing with Applications and their Application Servers.   I have imported all of the applications and all of the severs into their respective tables in my ServiceNow instance, but I was wonering if there was a way now to import the desired relationships into my instance just like i did with the CI's.   I have an excel sheet already filled with all of the correct information that looks like this:

App Service (Parent)	App Server (Child)
Application	App Server

All i need to do is be able to do a mass import to add a relationship to pre-existing apps and app servers to tie the two together.   Is this possible in ServiceNow?

Thanks for the help.

[Chuck Tomasi]

Hi Dustin,

Yes, you can do this with an import set. Your target table is going to be cmdb_rel_ci. See the link below for instructions and examples.

Import Sets - ServiceNow Wiki

[Chuck Tomasi]

Also worth taking a look... Import Set Performance Best Practices - ServiceNow Wiki

[dustin_hux]

Chuck,

The instructions on this page are somewhat unclear to me.   Am I supposed to create a Transform Map in order for this process to be carried out?   If so, what would be source table be?

[Chuck Tomasi]

Hi Dustin,

The source is the import set table. When you upload your spreadsheet, it gets saved in an import set table. This is a staging area of the raw data.

The transform map is used to map the fields and massage any data before sending to the target table. If you walk through the process manually from System Import Sets> Load Data, you can get a feel for the flow.