I recently ran this migration script for a new SAM Pro deployment and noticed that most of the discovery models it was creating were not getting normalized. The reason is because the 'discovered product' field in the discovery model record is mapped to the package name field in the cmdb_ci_spkg table, and the package name is a concatenation of both the product name and software version value. The additional version info being included in this field breaks the product normalization step for most entries. To fix the problem I modified this script:
https://<instance>.service-now.com/sys_script_include.do?sys_id=ac7ac9d4c38132002757dccdf3d3ae1c
and changed line 59
from: install.display_name = si.software.package_name;
to: install.display_name = si.software.name;
The name field in the cmdb_ci_spkg table contains the discovered product name without the version string appended to the end of it. Hope this helps.
