[ovirt-users] Re: local on host storage domain full, how to clean up

2022-06-07 Thread Gianluca Cecchi
On Sun, Jun 5, 2022 at 7:00 PM Patrick Hibbs wrote: > You can use the all_disks_for_vms view, instead of all_disks. Then add the > vm_id and / or vm_names columns. > > For example: > > /usr/share/ovirt-engine/dbscripts/engine-psql.sh -c "select >

[ovirt-users] Re: local on host storage domain full, how to clean up

2022-06-05 Thread Patrick Hibbs
You can use the all_disks_for_vms view, instead of all_disks. Then add the vm_id and / or vm_names columns. For example: /usr/share/ovirt-engine/dbscripts/engine-psql.sh -c "select disk_id,image_guid,disk_alias,disk_profile_name,vm_id,vm_names from all_disks_for_vms where disk_content_type='0'

[ovirt-users] Re: local on host storage domain full, how to clean up

2022-06-05 Thread Gianluca Cecchi
On Mon, May 30, 2022 at 4:44 PM _isi _ wrote: > Do you mean something like this ? > > /usr/share/ovirt-engine/dbscripts/engine-psql.sh -c "select > disk_id,image_guid,disk_alias,disk_profile_name from all_disks where > disk_content_type='0' order by disk_alias" > /root/disk_ids-to_vms.txt > >

[ovirt-users] Re: local on host storage domain full, how to clean up

2022-05-30 Thread _isi _
Do you mean something like this ? /usr/share/ovirt-engine/dbscripts/engine-psql.sh -c "select disk_id,image_guid,disk_alias,disk_profile_name from all_disks where disk_content_type='0' order by disk_alias" > /root/disk_ids-to_vms.txt isi ___ Users

[ovirt-users] Re: local on host storage domain full, how to clean up

2022-05-30 Thread Gianluca Cecchi
On Mon, May 30, 2022 at 7:56 AM Yedidyah Bar David wrote: > On Fri, May 27, 2022 at 11:04 AM Gianluca Cecchi > wrote: > > > > Hello, > > I have a local based storage domain that has got full, so that it is now > inactive and virtual machines that are on it are paused (vm paused due to > lack of

[ovirt-users] Re: local on host storage domain full, how to clean up

2022-05-29 Thread Yedidyah Bar David
On Fri, May 27, 2022 at 11:04 AM Gianluca Cecchi wrote: > > Hello, > I have a local based storage domain that has got full, so that it is now > inactive and virtual machines that are on it are paused (vm paused due to > lack of storage space). > Any advice on how to clean up, eventually