The functionality of Active install flag on cmdb_sam_sw_install table

Community Alums
Not applicable

‎02-15-2022 02:46 AM

How OOB de-duplication process works for Software Installation. There is documentation on same provided by Servicenow but what is the calculation Mechanism behind this ?

 

https://docs.servicenow.com/bundle/sandiego-it-asset-management/page/product/software-asset-management2/task/remove-duplicate-installs.html

 

Regards,

Gundeep Singh

0 Helpfuls
  • 1,405 Views
1 REPLY 1

Scott Halverso1
Mega Guru
Mega Guru

‎02-15-2022 08:48 PM

I'll give it a shot from reverse enginering the code.  It would be great to get a write up from ServiceNow.

Dups are defined as:

If Licensable Software:

  • Multiple software installs for one device where the below fields are same
    • cmdb_samp_sw_install.norm_publisher
    • cmdb_samp_sw_install.norm_product

 

If Non-Licenseable Software

  • Multiple software installs for one device where the below fields are same
    • cmdb_samp_sw_install.discovery_model.norm_publisher
    • cmdb_samp_sw_install.discovery_model.norm_product

Which dup wins and the rest get marked not active?

Complex logic, but weighting looks to based upon source, edition, version, language.  If the source is Pattern(ServiceNow's Discovery) it gets heavily scored (8 points).  Next up is edition, if there is an edition present it is scored with 4 points, then if version is present it gets 2 points and lastly if language is present it gets 1 point.