How to reload data from cmdb SW to SAM Pro sw table installation table

[kkcommunity]

Hello,

when we activate the SAM Professional plugin, ServiceNow automatically runs a migration script to move data from cmdb table(cmdb_software_instance) to SAM Pro  (cmdb_sam_sw_install) table for installed sw. After load there is no option to rerun/reload data. What if CMDB data is not cleaned and if we want to re-load data again from CMDB to SAM tables? 

Note: It is not possible to stop migration script auto run to load data as soon as SAM Pro plugin is activated

[Nayan Mahato]

No, not possible automatically. Once SAM Pro is activated, ServiceNow runs a one‑time migration script that copies data from.
You should clean the CMDB and repopulate SAM Pro manually

You can write a custom script or Transform Map to push fresh data from cmdb_software_instance (or your discovery source) into cmdb_sam_sw_install.

• Typical approach:
  Identify stale or incorrect SAM Pro install records.
  Delete or deactivate them.
  Reinsert clean data using a scripted job or import set.

Regards,

Nayan