Two CIs with the same name in the CMDB, how can I ensure the correct CI get the relationship?

[Med99]

If I have two Configuration Items (CIs) with the same name in the CMDB but from different classes, and I need to import relationships using a cmdb_rel_ci Excel file — how can I ensure the correct CI get the relationships assigned? I'm asking because I don't see parent.sys_id or child.sys_id fields available in the transform map.

[Shivalika · Accepted solution]

No @Med99 

You didn't get what I meant. I meant "parent" and "child" both are reference fields. So in the "excel" sheet - you don't need to pass their "names" - you pass their "sys_id". Because they are refernece fields it will work. I hope you understand what I meant now. 

I know that sys_id field in the dropdown is for relationship because that is in relationship table so one field is for sys_id representing record. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[Med99]

Thank you.

[Shivalika]

I am glad you found my answer helpful 😊 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[Shivalika]

Additionally @Med99 sys_id can never be same so no problem dealing with that. You don't need to dot walk parent.syd_id for reference fields, they themselves are sys_id. I hope you got the logic now. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY