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/
