CMDB Relationship Cleanup

[_bhishek]

Hi All,

In CMDB relationship table (cmdb_rel_ci),I have total of 4 Million relationships for which parent is non-operational /retired or child is non-operation/retired .SO we want to clean this data with removing these stale/orphan relationships. Also in for future want to make a automatic process if any parent or child is updated as non-operation /retired ,then respective relationship should be removed .What should be the best practice to deal with this data and Do we have functionality from service now to deal with this clean up process.Please suggest .

[_bhishek]

@srinija_itom Thanks for your response .This article is to retire/delete configuration items but my requirement is to delete existing relationships of CIs(in cmdb_rel_ci table) for which parent CI or child ci is decommissioned(approx count 3M).

I am not able to find in CMDB Data Manager ,we can use cmdb_rel_ci table for policy creation .Please confirm .

Thanks & regards,

Abhishek

[_bhishek]

hello @srinija_itom Is there any further suggestions for me .Any input would be helpful here. Thank you.

[srinija_itom]

hi @_bhishek , 

Yes, you cant find cmdb_rel_ci table directly in the data manager but then you find an option called delete related entry while creating a new policy. plea se find the below screenshot.

If you find this answer insightful, please mark it as helpful or accept the solution. 

Regards, 

Srinija Amisthapur

Rising Star 2025

[abt1639]

What discovery tool(s) are you using to populate the CMDB? 

[_bhishek]

I am using flexera to import CMDB data.