On 05/30/2017 05:02 PM, Nicolas Ecarnot wrote: > Hello, > > I'm trying to find a way to clean up the VMs list of my DCs. > I think some of my users have created VM they're not using anymore, but > it's difficult to sort them out. > In some cases, I can shutdown some of them and wait. > Is there somewhere stored in the db tables the date of the last VM > exctinction? > > Thank you. >
Did you consider using the API? There is a 'stop_time' attribute that you can use. For example, to list all the VMs and sort them by stop time you can use the following Python script: ---8<--- import ovirtsdk4 as sdk import ovirtsdk4.types as types # Create the connection to the server: connection = sdk.Connection( url='https://engine.example.com/ovirt-engine/api', username='admin@internal', password='...', ca_file='/etc/pki/ovirt-engine/ca.pem' ) # List the virtual machines: vms_service = connection.system_service().vms_service() vms = vms_service.list() # Sort the them by stop time: vms.sort(key=lambda vm: vm.stop_time) # Print the result: for vm in vms: print("%s: %s" % (vm.name, vm.stop_time)) # Close the connection to the server: connection.close() --->8--- _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users