Software installation table have duplicates data

shivani42
Tera Contributor

‎02-23-2024 09:33 AM

Hello All,

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. 

 

Has anyone seen this before. Please help!!

We have 4 million data, and we can't run script for that much data.

 

Thanks,

Shivani

0 Helpfuls
  • 557 Views
1 REPLY 1

Community Alums
Not applicable

‎02-23-2024 08:42 PM

Hi @shivani42 ,

  1. Navigate to All > Software Asset > Properties.
  2. Select Yes to select the Enable scheduled jobs when using third party Datasource Integration Framework [com.snc.samp.ire.datasource.integration] property.
  3. Execute the scheduled job SAM - Deduplicate Install Table.
    Based on the deduplication logic, only one software installation record is marked true and the other duplicate records are marked false. In the Software Installation [cmdb_sam_sw_install] table, the value in the Active installs column for only one of the duplicate record is true.
  4. Navigate to the Software Installation [cmdb_sam_sw_install] table.
    The value in the Active Installs column for only one of the duplicate record is set to true. The remaining duplicate entries for the software installation record is set to false.

 

0 Helpfuls