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

kkcommunity
Tera Expert

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
1 REPLY 1

Nayan Mahato
Tera Guru

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