Dear all, I have a question concerning the creation of VM's. Is there a way to see which user (Ldap login) created wich VM? Can we somehow query this trough the API? Kind regards, Koen
----- Original Message -----
From: "Koen Vanoppen" <vanoppen.koen@gmail.com> To: users@ovirt.org Sent: Friday, November 7, 2014 1:01:13 PM Subject: [ovirt-users] User management
Dear all,
I have a question concerning the creation of VM's. Is there a way to see which user (Ldap login) created wich VM? Can we somehow query this trough the API?
Well, at first I thought this should be done by browsing the permissions collection in REST-API, but then I realized that we can get this info from the events for example - <YOUR_URL>:/api/events then you will see something like - Vm my-vm-13 was created by abc@acme.com Cheers, Yair
Kind regards,
Koen
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
On 07/11/14 12:18, Yair Zaslavsky wrote:
Well, at first I thought this should be done by browsing the permissions collection in REST-API, but then I realized that we can get this info from the events for example -
<YOUR_URL>:/api/events
then you will see something like -
Vm my-vm-13 was created by abc@acme.com
imho this is not sufficient, because the events are just stored for the last 30 days by default. If you want to collect this information for a 31 days old vm, afaik you will get no information via this method. -- Mit freundlichen Grüßen / Regards Sven Kieske Systemadministrator Mittwald CM Service GmbH & Co. KG Königsberger Straße 6 32339 Espelkamp T: +49-5772-293-100 F: +49-5772-293-333 https://www.mittwald.de Geschäftsführer: Robert Meyer St.Nr.: 331/5721/1033, USt-IdNr.: DE814773217, HRA 6640, AG Bad Oeynhausen Komplementärin: Robert Meyer Verwaltungs GmbH, HRB 13260, AG Bad Oeynhausen
Ok, so, is there a other way? So we can query also vm's who are created more than 30 days? 2014-11-07 14:17 GMT+01:00 Sven Kieske <s.kieske@mittwald.de>:
On 07/11/14 12:18, Yair Zaslavsky wrote:
Well, at first I thought this should be done by browsing the permissions
collection in REST-API, but then I realized that we can get this info from the events > for example - > > <YOUR_URL>:/api/events > > then you will see something like - > > Vm my-vm-13 was created by abc@acme.com
imho this is not sufficient, because the events are just stored for the last 30 days by default. If you want to collect this information for a 31 days old vm, afaik you will get no information via this method.
-- Mit freundlichen Grüßen / Regards
Sven Kieske
Systemadministrator Mittwald CM Service GmbH & Co. KG Königsberger Straße 6 32339 Espelkamp T: +49-5772-293-100 F: +49-5772-293-333 https://www.mittwald.de Geschäftsführer: Robert Meyer St.Nr.: 331/5721/1033, USt-IdNr.: DE814773217, HRA 6640, AG Bad Oeynhausen Komplementärin: Robert Meyer Verwaltungs GmbH, HRB 13260, AG Bad Oeynhausen _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
This is a multi-part message in MIME format. --------------080702060903080001080206 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 8bit On 11/07/2014 10:36 AM, Koen Vanoppen wrote:
Ok, so, is there a other way? So we can query also vm's who are created more than 30 days?
We have it on database, but I don't see it exposed on API: engine=# select vm_static.vm_name, users.name, users.domain from vm_static, users where vm_static.created_by_user_id = users.user_id; -[ RECORD 1 ]----- vm_name | vm01 name | admin domain | internal -[ RECORD 2 ]----- vm_name | test name | admin domain | internal ... Please open a bugzilla ticket for it.
2014-11-07 14:17 GMT+01:00 Sven Kieske <s.kieske@mittwald.de <mailto:s.kieske@mittwald.de>>:
On 07/11/14 12:18, Yair Zaslavsky wrote: > Well, at first I thought this should be done by browsing the permissions collection in REST-API, but then I realized that we can get this info from the events > for example - > > <YOUR_URL>:/api/events > > then you will see something like - > > Vm my-vm-13 was created by abc@acme.com <mailto:abc@acme.com>
imho this is not sufficient, because the events are just stored for the last 30 days by default. If you want to collect this information for a 31 days old vm, afaik you will get no information via this method.
-- Mit freundlichen Grüßen / Regards
Sven Kieske
Systemadministrator Mittwald CM Service GmbH & Co. KG Königsberger Straße 6 32339 Espelkamp T: +49-5772-293-100 <tel:%2B49-5772-293-100> F: +49-5772-293-333 <tel:%2B49-5772-293-333> https://www.mittwald.de Geschäftsführer: Robert Meyer St.Nr.: 331/5721/1033, USt-IdNr.: DE814773217, HRA 6640, AG Bad Oeynhausen Komplementärin: Robert Meyer Verwaltungs GmbH, HRB 13260, AG Bad Oeynhausen _______________________________________________ Users mailing list Users@ovirt.org <mailto:Users@ovirt.org> http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
--------------080702060903080001080206 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: 8bit <html> <head> <meta content="text/html; charset=windows-1252" http-equiv="Content-Type"> </head> <body text="#000000" bgcolor="#FFFFFF"> <div class="moz-cite-prefix">On 11/07/2014 10:36 AM, Koen Vanoppen wrote:<br> </div> <blockquote cite="mid:CACfY+MYXa0fh-Pkp=iHU8=ny_-yE_sm2fzEZnSe_d5fyrMmCow@mail.gmail.com" type="cite"> <div dir="ltr">Ok, so, is there a other way? So we can query also vm's who are created more than 30 days?<br> </div> </blockquote> <br> <br> We have it on database, but I don't see it exposed on API:<br> <br> engine=# select vm_static.vm_name, users.name, users.domain from vm_static, users where vm_static.created_by_user_id = users.user_id;<br> -[ RECORD 1 ]-----<br> vm_name | vm01<br> name | admin<br> domain | internal<br> -[ RECORD 2 ]-----<br> vm_name | test<br> name | admin<br> domain | internal<br> ...<br> <br> Please open a bugzilla ticket for it.<br> <br> <br> <blockquote cite="mid:CACfY+MYXa0fh-Pkp=iHU8=ny_-yE_sm2fzEZnSe_d5fyrMmCow@mail.gmail.com" type="cite"> <div class="gmail_extra"><br> <div class="gmail_quote">2014-11-07 14:17 GMT+01:00 Sven Kieske <span dir="ltr"><<a moz-do-not-send="true" href="mailto:s.kieske@mittwald.de" target="_blank">s.kieske@mittwald.de</a>></span>:<br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class=""><br> <br> On 07/11/14 12:18, Yair Zaslavsky wrote:<br> > Well, at first I thought this should be done by browsing the permissions collection in REST-API, but then I realized that we can get this info from the events<br> > for example -<br> ><br> > <YOUR_URL>:/api/events<br> ><br> > then you will see something like -<br> ><br> > Vm my-vm-13 was created by <a moz-do-not-send="true" href="mailto:abc@acme.com">abc@acme.com</a><br> <br> </span>imho this is not sufficient, because the events are just stored for the<br> last 30 days by default. If you want to collect this information for<br> a 31 days old vm, afaik you will get no information via this method.<br> <br> --<br> Mit freundlichen Grüßen / Regards<br> <br> Sven Kieske<br> <br> Systemadministrator<br> Mittwald CM Service GmbH & Co. KG<br> Königsberger Straße 6<br> 32339 Espelkamp<br> T: <a moz-do-not-send="true" href="tel:%2B49-5772-293-100" value="+495772293100">+49-5772-293-100</a><br> F: <a moz-do-not-send="true" href="tel:%2B49-5772-293-333" value="+495772293333">+49-5772-293-333</a><br> <a moz-do-not-send="true" href="https://www.mittwald.de" target="_blank">https://www.mittwald.de</a><br> Geschäftsführer: Robert Meyer<br> St.Nr.: 331/5721/1033, USt-IdNr.: DE814773217, HRA 6640, AG Bad Oeynhausen<br> Komplementärin: Robert Meyer Verwaltungs GmbH, HRB 13260, AG Bad Oeynhausen<br> <div class="HOEnZb"> <div class="h5">_______________________________________________<br> Users mailing list<br> <a moz-do-not-send="true" href="mailto:Users@ovirt.org">Users@ovirt.org</a><br> <a moz-do-not-send="true" href="http://lists.ovirt.org/mailman/listinfo/users" target="_blank">http://lists.ovirt.org/mailman/listinfo/users</a><br> </div> </div> </blockquote> </div> <br> </div> <br> <fieldset class="mimeAttachmentHeader"></fieldset> <br> <pre wrap="">_______________________________________________ Users mailing list <a class="moz-txt-link-abbreviated" href="mailto:Users@ovirt.org">Users@ovirt.org</a> <a class="moz-txt-link-freetext" href="http://lists.ovirt.org/mailman/listinfo/users">http://lists.ovirt.org/mailman/listinfo/users</a> </pre> </blockquote> <br> </body> </html> --------------080702060903080001080206--
On 07/11/14 14:53, Amador Pahim wrote:
Please open a bugzilla ticket for it.
done: https://bugzilla.redhat.com/show_bug.cgi?id=1161625 -- Mit freundlichen Grüßen / Regards Sven Kieske Systemadministrator Mittwald CM Service GmbH & Co. KG Königsberger Straße 6 32339 Espelkamp T: +49-5772-293-100 F: +49-5772-293-333 https://www.mittwald.de Geschäftsführer: Robert Meyer St.Nr.: 331/5721/1033, USt-IdNr.: DE814773217, HRA 6640, AG Bad Oeynhausen Komplementärin: Robert Meyer Verwaltungs GmbH, HRB 13260, AG Bad Oeynhausen
bug created: https://bugzilla.redhat.com/show_bug.cgi?id=1161629 Thanks for the info! 2014-11-07 14:53 GMT+01:00 Amador Pahim <apahim@redhat.com>:
On 11/07/2014 10:36 AM, Koen Vanoppen wrote:
Ok, so, is there a other way? So we can query also vm's who are created more than 30 days?
We have it on database, but I don't see it exposed on API:
engine=# select vm_static.vm_name, users.name, users.domain from vm_static, users where vm_static.created_by_user_id = users.user_id; -[ RECORD 1 ]----- vm_name | vm01 name | admin domain | internal -[ RECORD 2 ]----- vm_name | test name | admin domain | internal ...
Please open a bugzilla ticket for it.
2014-11-07 14:17 GMT+01:00 Sven Kieske <s.kieske@mittwald.de>:
Well, at first I thought this should be done by browsing the
On 07/11/14 12:18, Yair Zaslavsky wrote: permissions collection in REST-API, but then I realized that we can get this info from the events
for example -
<YOUR_URL>:/api/events
then you will see something like -
Vm my-vm-13 was created by abc@acme.com
imho this is not sufficient, because the events are just stored for the last 30 days by default. If you want to collect this information for a 31 days old vm, afaik you will get no information via this method.
-- Mit freundlichen Grüßen / Regards
Sven Kieske
Systemadministrator Mittwald CM Service GmbH & Co. KG Königsberger Straße 6 32339 Espelkamp T: +49-5772-293-100 F: +49-5772-293-333 https://www.mittwald.de Geschäftsführer: Robert Meyer St.Nr.: 331/5721/1033, USt-IdNr.: DE814773217, HRA 6640, AG Bad Oeynhausen Komplementärin: Robert Meyer Verwaltungs GmbH, HRB 13260, AG Bad Oeynhausen _______________________________________________ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
_______________________________________________ Users mailing listUsers@ovirt.orghttp://lists.ovirt.org/mailman/listinfo/users
participants (4)
-
Amador Pahim -
Koen Vanoppen -
Sven Kieske -
Yair Zaslavsky