Software installation table has duplicates record with same installed on name, display name, source but with different versions. For e.g. SCCM they have duplicates records but different versions. They are having the lower and latest version both. When we checked with SCCM they confirmed that the duplicates are there end source only. They are keeping the data in this way only that is why ServiceNow fetching the duplicates. But this is creating discrepancy on license workbench as we have two records for same software but different version and both are active.
Deleting the registry keys from the computers of old software versions I feel is going to be very time-consuming process and waste of effort once the software updates again and another version is added to the registry.
Any help would be greatly appreciated.
