1. Create a Scheduled Script Execution

   In the Global application scope, create a new Scheduled Script Execution (sysauto_script) record.

   Use the following name:

   Cleanup Software Model Records for Windows Servers and Products Impacted by Technopedia Consolidation

2. Configure the execution

   Set the Run option to:

   On Demand

   This ensures that the cleanup script is executed only when explicitly triggered and allows the identified Software Model records to be reviewed and validated before deletion.

3. Add the cleanup script

   Add the following script to the Scheduled Script Execution.

   CAUTION: This script deletes data when EXECUTE_DELETION is set to true. Keep the flag set to false for the initial execution and review the complete dry-run output before enabling deletion.

   (function() {
   
     // SAFETY FLAG:
   
     // false = Dry run only. No records are deleted.
   
     // true = Delete the validated records.
   
     var EXECUTE_DELETION = false;
   
     var PRODUCTS = [
   
       'Windows Server 2016',
   
       'Windows Server 2019',
   
       'Windows Server 2022',
   
       'Windows Server 2025',
   
       'Windows 10',
   
       'Windows 11'
   
     ];
   
     var model = new GlideRecord('cmdb_software_product_model');
   
     if (!model.isValid()) {
   
       gs.error(
   
         '[Technopedia Cleanup] Invalid table: cmdb_software_product_model'
   
       );
   
       return;
   
     }
   
     if (!model.isValidField('x_fls_flexeraone_technopedia_id') ||
   
       !model.isValidField('product')) {
   
       gs.error(
   
         '[Technopedia Cleanup] Required fields are missing. Cleanup aborted.'
   
       );
   
       return;
   
     }
   
     model.addNotNullQuery('x_fls_flexeraone_technopedia_id');
   
     model.addQuery(
   
       'product.prod_name',
   
       'IN',
   
       PRODUCTS.join(',')
   
     );
   
     model.query();
   
     gs.info(
   
       '[Technopedia Cleanup] Mode=' +
   
       (EXECUTE_DELETION ? 'DELETE' : 'DRY RUN') +
   
       ' | Total matching records=' +
   
       model.getRowCount()
   
     );
   
     var deletedCount = 0;
   
     while (model.next()) {
   
       gs.info(
   
         '[Technopedia Cleanup] ' +
   
         (EXECUTE_DELETION ? 'Deleting: ' : 'Matched: ') +
   
         'Sys ID=' + model.getUniqueValue() +
   
         ' | Display Name=' + model.getValue('display_name') +
   
         ' | Technopedia ID=' +
   
           model.getValue('x_fls_flexeraone_technopedia_id') +
   
         ' | Product=' + model.product.prod_name +
   
         ' | Version=' + model.getValue('version') +
   
         ' | Edition=' + model.getValue('edition')
   
       );
   
       if (EXECUTE_DELETION) {
   
         model.deleteRecord();
   
         deletedCount++;
   
       }
   
     }
   
     if (EXECUTE_DELETION) {
   
       gs.info(
   
         '[Technopedia Cleanup] Cleanup completed. ' +
   
         'Deleted records=' + deletedCount
   
       );
   
     } else {
   
       gs.info(
   
         '[Technopedia Cleanup] DRY RUN completed. ' +
   
         'No records were deleted. Review and validate the output ' +
   
         'before setting EXECUTE_DELETION=true.'
   
       );
   
     }
   
   })();

   The cleanup script targets Software Model records that:

   • Have a FlexeraOne Technopedia ID.
   • Are associated with one of the Windows products impacted by the Technopedia consolidation:
     • Windows Server 2016
     • Windows Server 2019
     • Windows Server 2022
     • Windows Server 2025
     • Windows 10
     • Windows 11
   • Pass validation of the required table and fields before processing begins.

   The EXECUTE_DELETION flag provides a controlled two-stage cleanup process so that all identified records can be reviewed before any deletion occurs.

4. Run the cleanup in dry-run mode

   For the initial execution, keep the safety flag set to:

   var EXECUTE_DELETION = false;

   Run the Scheduled Script Execution On Demand.

   In dry-run mode, no records are deleted.

   The script logs the total number of matching Software Model records and the following information for each identified record:

   • Sys ID
   • Display Name
   • Technopedia ID
   • Product
   • Version
   • Edition

   The dry run must be reviewed before enabling deletion.

5. Review and validate the dry-run results

   After the Scheduled Script Execution completes, navigate to:

   System Logs > System Log > All

   To locate only the logs generated by this cleanup script, apply the following filter:

   Message contains [Technopedia Cleanup]

   Review the following information before proceeding with deletion.

   1. Validate the execution mode and record count

      At the beginning of execution, the script generates a summary log similar to:

      [Technopedia Cleanup] Mode=DRY RUN | Total matching records=25

      Confirm that:

      • Mode = DRY RUN, confirming that deletion was disabled.
      • Total matching records represents the expected number of Software Model records identified by the cleanup criteria.

      An unexpected record count should be investigated before proceeding.

   2. Validate each matching Software Model

      The script generates a separate log entry for every Software Model identified for cleanup.

      Example:

      [Technopedia Cleanup] Matched: Sys ID=xxxxxxxx | Display Name=Windows Server 2019 Standard | Technopedia ID=xxxxxxxx | Product=Windows Server 2019 | Version=2019 | Edition=Standard

      Review the records and confirm that:

      • The target record has a FlexeraOne Technopedia ID.
      • The Product belongs to one of the affected legacy Windows products.
      • The Display Name, Version, and Edition correspond to the expected legacy Software Model.
      • The record is no longer required following the Technopedia product consolidation.

   3. Validate customer-specific dependencies

      Before deleting the identified Software Models, verify that they are not required by customer-specific configurations or processes.

      Review, where applicable:

      • Customer-specific entitlements
      • Discovery mappings
      • Manually maintained relationships
      • Custom integrations
      • Custom scripts or business logic
      • Other processes that may depend on the identified Software Models

      Any Software Model that is still required by a customer-specific process should be investigated before deletion.

   4. Validate dry-run completion

      At the end of the execution, confirm that the following log is present:

      [Technopedia Cleanup] DRY RUN completed. No records were deleted.

      This confirms that the validation execution completed successfully without deleting any Software Model records.

6. Enable deletion

   Proceed only after:

   • The dry-run output has been completely reviewed.
   • The identified records have been confirmed as legacy Software Models.
   • Customer-specific dependencies have been reviewed.
   • The results have been approved for deletion.

   Change:

   var EXECUTE_DELETION = false;

   to:

   var EXECUTE_DELETION = true;

   Save the Scheduled Script Execution.

7. Run the cleanup

   Run the Scheduled Script Execution again On Demand.

   With EXECUTE_DELETION = true, the script deletes the Software Model records that match the cleanup criteria.

   For each record being processed, a log entry similar to the following is generated:

   [Technopedia Cleanup] Deleting: Sys ID=xxxxxxxx | Display Name=Windows Server 2019 Standard | Technopedia ID=xxxxxxxx | Product=Windows Server 2019 | Version=2019 | Edition=Standard

   At the end of the execution, the script generates a summary similar to:

   [Technopedia Cleanup] Cleanup completed. Deleted records=25

   Review the logs and confirm that the number of deleted records matches the records approved during the dry-run validation.

8. Validate the cleanup

   1. Navigate to the Software Model (cmdb_software_product_model) table.
   2. Verify that the validated legacy Software Models have been removed.
   3. Confirm that Software Models outside the affected Windows product list remain unchanged.
   4. Navigate to System Logs > System Log > All.
   5. Filter using Message contains [Technopedia Cleanup].
   6. Confirm that the cleanup completed successfully and that the expected number of records was deleted.

After successful completion of the cleanup:

• Validated legacy Software Models associated with the affected Windows and Windows Server products are removed.
• Software Models outside the defined cleanup criteria remain unchanged.
• The cleanup is performed only after the records have been reviewed through the dry-run process.
• The environment no longer retains the targeted legacy Software Models created from the pre-consolidation Technopedia product structure.