Migrate Software Installs take long time to completeDescription<!-- div.margin{ padding: 10px 40px 40px 30px; } table.tocTable{ border: 1px solid; border-color:#E0E0E0; background-color: rgb(245, 245, 245); padding-top: .6em; padding-bottom: .6em; padding-left: .9em; padding-right: .6em; } table.noteTable{ border:1px solid; border-color:#E0E0E0; background-color: rgb(245, 245, 245); width: 100%; border-spacing:2; } table.internaltable { white-space:nowrap; text-align:left; border-width: 1px; border-collapse: collapse; font-size:14px; width: 85%; } table.internaltable th { border-width: 1px; padding: 5px; border-style: solid; border-color: rgb(245, 245, 245); background-color: rgb(245, 245, 245); } table.internaltable td { border-width: 1px; padding: 5px; border-style: solid; border-color: #E0E0E0; color: #000000; } .title { color: #D1232B; font-weight:normal; font-size:28px; } h1{ color: #D1232B; font-weight:normal; font-size:21px; margin-bottom:-5px } h2{ color: #646464; font-weight:bold; font-size:18px; } h3{ color: #000000; font-weight:BOLD; font-size:16px; text-decoration:underline; } h4{ color: #646464; font-weight:BOLD; font-size:15px; text-decoration:; } h5{ color: #000000; font-weight:BOLD; font-size:13px; text-decoration:; } h6{ color: #000000; font-weight:BOLD; font-size:14px; text-decoration:; } ul{ list-style: disc outside none; margin-left: 0; } li { padding-left: 1em; } --> Description 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. Procedure Attached 2 scripts that will help to improve the migration. "SAMPMigration" script include: sys_script_include_ac7ac9d4c38132002757dccdf3d3ae1c.xml2. "Create a Software Normalization" Business Rule: sys_script_9ec2b34d37101000deeabfc8bcbe5d43.xml 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. Applicable Versions Kingston and above Additional Information 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