Deleting records no longer needed from "cmdb_software_instance"

[CadeC]

I'm trying to remove records in the "cmdb_software_instance" where two rows indicate that a device has two versions of the same application, but I want to delete the row with the oldest version of that application. Similarly, I want to remove rows where an application is no longer on a device. Is there a standard way to go about doing so?

[Abbas_5]

Hello @CadeC,

I think we can achieve this through the De-duplication activity: First, you can pull the report from prod, then test in a lower instance.

Step-1:

In cmdb table, you can apply the filter condition by selecting the class and operational status is one of Non-operational, being assembled, Deployed extract the report
step -2:
Go to duplicate_audit_result.LIST table 

select the Duplicate ID = sys id

Extract the report; you will find the duplicate task numbers
Step -3:
In the application navigator, type 'De-duplication search with duplicate task numbers'.

duplicate the task, and do some analysis like the most recent discovery, the most recent creation, and the relationship count. Based on that, you can select the main CI

Compare the main CI and Duplicate CI, then select whether to merge the relationship or not

merge related items
attributes

action set to retire or delete
A duplicate task is automatically set to closed complete.

If it is helpful, please hit the thumbs-up button and accept the correct solution; by referring to this solution in the future, it will be beneficial to them.

Thanks & Regards,

Abbas Shaik