Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

CI relationship upload to CMDB

Highlighted
Sandeep Kanchal
Occasional Advisor

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
Acclaimed 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
Esteemed 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
Occasional Advisor

Re: CI relationship upload to CMDB

Many Thanks Avinash, It worked!!
Sam decosta
Esteemed Contributor

Re: CI relationship upload to CMDB

Hi Sandeep,

If worked you can assogn the points :)

Thanks,
Avinash
Sandeep Kanchal
Occasional Advisor

Re: CI relationship upload to CMDB

I'll be happy to do that, pls let me know how to.
Sam decosta
Esteemed 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
//Add this to "OnDomLoad" event