Duplicate CI(s) relationships in CMDB

[Sergei3]

Hello,

I am dealing with the issue where existing CIs duplicate relationships are causing the SN Discovery to fail to update a scanned CI.

Does anyone happen to know how to query CMDB CI relationships table (cmdb_rel_ci) and produce a report to list all duplicate CI relationships?

Thank you!

[Frank Tate]

Here's a previous post similar to yours. The script that answers your question (reply from @jochen.larbig ) is far down the replies, so I'm including it here:

var gaDupCheck = new GlideAggregate('cmdb_rel_ci');
gaDupCheck.groupBy('parent');
gaDupCheck.groupBy('child');
gaDupCheck.groupBy('type');
gaDupCheck.addHaving('COUNT', '>', 1);

Frank

[Sergei3]

Thank you Frank for the prompt response!

Do you happen to know, which group/role can work with GlideAggregate/create the scripts?

Is it CMDB Admin team?

Thank you!

[Frank Tate]

The CMDB Admin team probably has authority to create scripts, or they will know who in your organization does have that authority.

Frank

[mikkojuola]

Hi Sergei,

This question inspired me to write a short blog post on "how to find duplicate CI relationships without scripting". You can find the post here: https://datacontentmanager.com/best-way-to-find-duplicate-ci-relationships

If you want to know more or give it a try yourself, you can reach out to me via the same link.

Cheers,

--Mikko