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

Med99 · ‎03-31-2025

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 · ‎03-31-2025

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

View solution in original post

Shivalika · ‎03-31-2025

Hello @Med99

There should also be serial number. As per identification rules, two CIs cannot have same name as well as same serial number unless they have modified the identification rule.

So you can instead go by serial number and CMDB ci name combo.

Or definitely you can create these fields.

These two solutions will work when with TM surely.

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 · ‎03-31-2025

I only find these fields when trying to field map , i don't find serial number or parent/child sys id to identify the CI, is this normal ?

Shivalika · ‎03-31-2025

Okeh @Med99 Now I got your issue.

If that's the case, the parent field is originally a reference field and child field is also originally a reference field. So you don't need to pass names, directly pass "sys_id" . Problem solved !

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 · ‎03-31-2025

In photo i've sent, syd_id references the relationship not the parent or the child