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.

[craigsnowadmin2]

Chuck , Pradeep ,

How do you export these consistently ? to another datasource like sql database or bmc atrium cmdb ?

[Chuck Tomasi]

To export these, take a look at the cmdb_rel_ci table. That's the table that maps the connections between the CIs.

http://wiki.servicenow.com/index.php?title=Exporting_Data

[HARSHIT7]

Hi Chuck,

Can you post any sample video example for this import set for mass import to add a relationship 

[Philip Hulshize]

Chuck,

I know this is an old post, and I can't get to the wiki. Here is my problem with importing relationships.

Many times, the server and the VM instance have the same name. So, when I go to import through a transform, I have no control over where this goes. I have the same issue when association a Business Capability to a Business Application or a Business Service. I cannot control which CI it chooses.

Suggestions?

[Pradeep Sharma]

Hi Dustin,

For reference you can refer learning module "Importing legacy data" on developers portal helpful.

ServiceNow Developers