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

2017-07-09 Thread Eli Mesika
On Thu, Jul 6, 2017 at 6:48 PM, Juan Hernández wrote: > 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 :

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

2017-07-06 Thread Juan Hernández
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,

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

2017-07-06 Thread Nicolas Ecarnot
[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,

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

2017-05-30 Thread Juan Hernández
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