Software Installation Deduplication

aswath
Tera Contributor

Hi

 

I'm working on to find the root cause for software installation duplicate records, I'm aware that due to multiple discovery sources it may populate duplicate records and "SAM - Deduplicate Install Table" job will mark the field "Active Install" as True for 1 record and False for other records. 

 

For a computer, my assumption for finding duplicate records is to group by "primary key."I discovered that "Active Install" is set to True for all duplicate entries (Discovery Source - Servicenow).

 

can anyone help me to answer this questions.

 

1.How the software installation records are getting populated in that table.

2. How to identify the duplicate Software installation record.

3. Why did servicenow discovery produce multiple entries with the same field values and some of the identical records with different field values (for example, installed on,created date,updated date)?

 

Thanks

 

 

6 REPLIES 6

SrinivasRamanu1
ServiceNow Employee
ServiceNow Employee

Hi aswath

This is interesting, could you find if there are "actual" duplicates for the software. SAM Pro automatically does deduplication while performing reconciliation so only 1 license would be consumed.

regards

Srinivas

Hi @SrinivasRamanu1 

 

Thanks for your reply

After grouping the records in my PDI by the "primary key" attribute, I observed that the "Active Install" field is set to true for duplicate records. Then these records will be considered for reconciliation because of this marking.

 

I am interested in understanding how these duplicate records are generated for the same discovery source and why the "Active Install" field is marked as true for these duplicate records.

 

aswath_1-1683698476383.png

Hi @aswath ,

Did you execute the scheduled job before taking this screenshot?

Regards,

Lithesh

Hi @aswath,

 

Did you activated this system properties by navigating software asset->properties. and making this property as true "Enable scheduled jobs when using third party Datasource Integration Framework". Because only if it is true the scheduled job will work fine.

Lithesh_0-1683718855606.png