Customer tried to run the "Migrate Software Installs" module but it takes long time (ie:6 days) to complete and it creates million of records in the Software Installations (cmdb_sam_sw_install) table.
Attached 2 scripts that will help to improve the migration.
After the migration complete, please revert the scripts to out of the box version.
Although there is no known harm to have the modified scripts on the SN platform, it is advised to revert them to their original version to avoid unintended consequences on Software Asset Management. This also helps in smooth transitions to future upgrades of the SN platform.
Kingston and above
When run "Migrate Software Installs" module, it will
- create a new record in the [cmdb_sam_sw_install] table and run all the business rules defined.
- Create software Discovery Model for non-existing records
- Normalize software Discovery Model