Re: [ovirt-users] SQL : last time halted?

On 07/06/2017 02:07 PM, Nicolas Ecarnot wrote:

[For the record]

Juan,

Thanks to your hint, I eventually found it more convenient for me to use a SQL query to find out which VM was unsed for months :

SELECT vm_static.vm_name, vm_dynamic.status, vm_dynamic.vm_ip, vm_dynamic.vm_host, vm_dynamic.last_start_time, vm_dynamic.vm_guid, vm_dynamic.last_stop_time FROM public.vm_dynamic, public.vm_static WHERE vm_dynamic.vm_guid = vm_static.vm_guid AND vm_dynamic.status = 0 ORDER BY vm_dynamic.last_stop_time ASC;

Thank you.

That is nice. Just keep in mind that the database schema isn't kept backwards compatible. A minor change in the engine can make your query fail or return incorrect results.