Service Desk Practitioners Forum
cancel

CI relationship upload to CMDB

Highlighted
Sandeep Kanchal
Contributor.

CI relationship upload to CMDB

Hi, We have HPSD 4.5 SP25. I'm trying to upload CI relationships to the existing CIs using DE. It finds 'CI from', puts 'Connected' into the 'CI Relation type' field, but when tries to search 'CI to' SearchCode, throws error, found multiple items. Upon investigating I found we have CIs named e.g ABC01 & ABC010, ABC011 as well. That's the reason it throws error like that. What to do? I have 1000s of records to be updated, pls help.
6 REPLIES
Aleksey.Demidov
Contributor.

Re: CI relationship upload to CMDB

Hi

As for workaround you can use advanced mass update to change SearchCode of all CI's from "ABC01" to something more long "ABC01-100".
Then use your Data Exchange. After this you can change your SearchCode names back to original state.
Sam decosta
Outstanding Contributor.

Re: CI relationship upload to CMDB

Hi Sandeep,

You need to modify the Import mapping which you are using to import Ci relation.

Select both CI To and CI From as unique key and try to import.

Thanks,
Avinash
Sandeep Kanchal
Contributor.

Re: CI relationship upload to CMDB

Many Thanks Avinash, It worked!!
Sam decosta
Outstanding Contributor.

Re: CI relationship upload to CMDB

Hi Sandeep,

If worked you can assogn the points :)

Thanks,
Avinash
Sandeep Kanchal
Contributor.

Re: CI relationship upload to CMDB

I'll be happy to do that, pls let me know how to.
Sam decosta
Outstanding Contributor.

Re: CI relationship upload to CMDB

You just need to use drop down listed infront of my name.

Refer the attached sheet :)

Thanks,
Avinash