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 .

[srinija_itom]

Hi @_bhishek Data Manager is the best out of the box approach for your scenario. Please check out this reply from @ Tony Branton in the below community Post. 

 https://www.servicenow.com/community/cmdb-forum/need-help-with-cmdb-cleanup-options/m-p/3407785#M181...

You can use CMDB Data Manager to create a policy to retire CIs. Data Manager will use the Retirement Definition corresponding to the CIs' classes to set the appropriate field to a retired state.  Data Manager executes retirement policies on a daily basis, so whenever CIs meet the filter criteria in a policy, the CI will be retired - it's automated.

Retired CIs can then be processed by Archive or Delete policies.  If for example you wanted to delay archiving retired CIs for 7 days, you can include that as part of the filter condition.  As with Retire policies, Data Manager executes Archive (and Delete) policies on a daily basis and processes retired CIs as they meet the policy's filter criteria.  Once setup, the archive/delete process is automated and will process retired CIs.

You can learn more about CMDB Data Manager here.

Regards, 

Srinija

[_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?