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?
