11:20 a.m.
Is there a way to know how to see who the vm of a pool assigned to?
I am able on the portal to see those who are "logged-in user" but the others VM
I don't know to whom they are assigned.
12: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
5:12 a.m.
On Wed, Apr 21, 2021 at 8:17 PM Dominique D <
dominique.deschenes(a)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(a)ovirt.org
To unsubscribe send an email to users-leave(a)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/DPCDBK4LNEK...
1079
days inactive
1101
days old
3 comments
2 participants
participants (2)
-
Arik Hadas -
Dominique D