Software Installation Deduplication

[aswath]

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

[Lithesh]

If you find any difficulties kindly go through this product documentation."https://docs.servicenow.com/bundle/utah-it-asset-management/page/product/software-asset-management2/....
If this answer is correct kindly mark as correct.

[Lithesh]

Hi @aswath ,
Answering your questions,
1. The records are populated by the discovery sources for e.g. SCCM, SN discovery etc..

2. The duplicate records are identified by some duplication logic that are configured in the OOB itself.
3. The Multiple entries are populated because if any of the fields following fields changed like Publisher name,Version,Display name.

Regards,

Lithesh