
21 Apr
2021
21 Apr
'21
8:16 p.m.
I found this a "select command" on this link https://bugzilla.redhat.com/show_bug.cgi?id=1462236 I use ovirt 4.4 But where I execute this command : engine=# select s.vm_name, d.status, u.name from vm_static s, vm_dynamic d, permissions p, users u where s.vm_guid = d.vm_guid and u.user_id = p.ad_element_id and p.object_type_id = 2 and p.object_id = s.vm_guid and s.vm_name ilike '%VMPOOL%' ORDER BY vm_name; vm_name | status | name --------------+--------+-------------- VMPOOL-1 | 1 | ADRIAN VMPOOL-10 | 1 | ADRIAN