Some times Norm product/publisher is incorrectly stamped on the installs of a non-licensable product - Known Error

Some times Norm product/publisher is incorrectly stamped on the installs of a non-licensable product Description Who is affected?

You are impacted by this issue if you have install records that meet the following criteria:

Discovery Model.norm_type !== licensable AND

Publisher IS NOT EMPTY AND

Product IS NOT EMPTY

Why should publisher and product be empty?

Software Asset Reconciliation is only applicable for licensable software i.e. software that a customer pays for. The way reconciliation identifies what installs it should consider is by looking at the Publisher and Product fields. If these fields are stamped, then reocn may create a non-compliant product result with some unlicensed installs.

Impact

If these fields are stamped for products whose license type !== licensable, then reocn may create a non-compliant product result with some unlicensed installs.

How does this issue surface?

We have seen this issue occur when a new Product Exception Rule is shipped from ServiceNow content for which an install record may already exist. We have also observed this issue in situations where a Discovery Model gets re-normalized by a package map at some point after it's creation. Steps to Reproduce

Steps to reproduce if caused by Product Exception Rules

Create Discovery models and Installs for SQL Server Developer edition Create a Product Exception Rule for Product = SQL Server, Edition = Developer and License Type = Not licensable Observe that Norm product/publisher is not cleared on few installs when Product Exception Rule is created

Steps to reproduce if caused by Package maps

Unknown.

Workaround The problem is fixed in Zurich and is backported to Xanadu Patch 10 and Yokohama Patch 7.

This script will only clear norm values on installs if those should be empty but had a value set.

This script can run for long time, so better to run it in background via fix script or a one time job

Workaround script:

var model = new GlideRecord('cmdb_sam_sw_discovery_model'); model.addEncodedQuery('norm_productISNOTEMPTY^norm_type!=licensable^NQnorm_productISNOTEMPTY^norm_type=licensable^norm_product.ignore_installs=true'); model.query(); while (model.next()) { var install = new GlideMultipleUpdate('cmdb_sam_sw_install'); install.addNotNullQuery('norm_product'); install.addQuery('discovery_model', model.getUniqueValue()); global.SAMPremiumUtils.clearNormFieldsForInstallGr(install); install.execute(); }