Need to Migrate cmdb_software_instance to cmdb_sam_sw_install table.

sandeep srivas2
Tera Contributor

‎09-15-2022 09:52 PM

Hello,

I need to migrate data from cmdb_software_instance table to cmdb_sam_sw_install table . For this I went to module "Migrate software install" and  run that/toggled that. First time data is exactly the same in install table from instance table but the count seems to go down when I checked cmdb_sam_sw_install after some time. I need to know that, why this happened ,Whether there is any scheduled job or anything that is running

 

Thanks in advance.

0 Helpfuls
  • 1,142 Views
1 REPLY 1

Daniel Slocum
ServiceNow Employee
ServiceNow Employee

‎09-16-2022 04:48 PM

When SAM is installed installations are written to the cmdb_sam_sw_install table. 

Records in this table are removed by the SCCM Service Graf integration when software is uninstalled from a device. Similarly, records are removed by the ServiceNow Discovery integration when software is uninstalled from a device. Records are also removed when a CI is updated to Retired, Lost, or Stolen.