On Wed, Apr 21, 2021 at 8:17 PM Dominique D < dominique.desche...@gcgenicom.com> wrote:
> 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 > That SQL command can be executed via a PostgreSQL client. Alternatively, you can look at the virtual machine's permissions (sub-)tab in the webadmin. > _______________________________________________ > Users mailing list -- users@ovirt.org > To unsubscribe send an email to users-le...@ovirt.org > Privacy Statement: https://www.ovirt.org/privacy-policy.html > oVirt Code of Conduct: > https://www.ovirt.org/community/about/community-guidelines/ > List Archives: > https://lists.ovirt.org/archives/list/users@ovirt.org/message/DPCDBK4LNEKJTKG6HFT4GXBHUV3TYDE2/ >
_______________________________________________ Users mailing list -- users@ovirt.org To unsubscribe send an email to users-le...@ovirt.org Privacy Statement: https://www.ovirt.org/privacy-policy.html oVirt Code of Conduct: https://www.ovirt.org/community/about/community-guidelines/ List Archives: https://lists.ovirt.org/archives/list/users@ovirt.org/message/AUM7HTWSTPZ5OMKN53YP5DX5XJZX3SK7/