Clean up VM instances

1. Create a new Scheduled Script Execution (sysauto_script) record in the Global scope and name the record: FlexeraOne job to remove VM from VMI table. 

2. Set the Run option to On Demand. 

3. In the Script field, add the following cleanup script: 

var deletedCount = 0; 

var guestVM = new GlideRecord('cmdb_ci_vm_instance'); 

guestVM.addQuery('discovery_source', 'FlexeraOne'); 

guestVM.query(); 

 

while (guestVM.next()) { 

    guestVM.deleteRecord(); 

    deletedCount++; 

} 

gs.info('[Cleanup Job] Deleted ' + deletedCount + '  VM  records from cmdb_ci_vm_instance where discovery_source=FlexeraOne'); 

4. After entering the script and configuring required fields, select Save. 

5. Click Execute Now to run the script. 

6. Monitor script progress: 

1. • Navigate to System Scheduler > Progress Worker to track the execution status. 

1. • You can also monitor System Logs > System Log > All for entries from the script. Look for log entries like:  
     [Cleanup Job] Deleted X VM records from cmdb_ci_vm_instance where discovery_source=FlexeraOne 

7. Validate the cleanup:  

1. 1. Navigate to the cmdb_ci_vm_instance table. 

1. 2. Apply the filter: discovery_source=FlexeraOne 

1. 3. Confirm that no records are returned. This result indicates the cleanup was successful. 

8. Run the Snapshot Job.