<div dir="ltr"><div><div><div>Hi Sven,<br><br></div>On your engine you can run the following to get the vms info from the engine database:<br><br>su - postgres -c "psql -U postgres engine -c 'select * from vms;'" |less -S<br><br></div>You may also find some info on the specific vm in the engine log and the libvirt log:<br><br></div>On the engine - /var/log/ovirt-engine/engine.log (this will probably have been rotated in your case. Check to see the oldest engine.log in the directory). <br><div><div style="margin-left:40px"><br></div>On the host the the vm runs on - /var/log/libvirt/qemu/vm111.log<br><br><br></div><div>Hope this helps,<br><br><br></div><div>Kevin<br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Mar 21, 2017 at 9:45 AM, Gianluca Cecchi <span dir="ltr"><<a href="mailto:gianluca.cecchi@gmail.com" target="_blank">gianluca.cecchi@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra"><div class="gmail_quote">On Tue, Mar 21, 2017 at 8:42 AM, Sven Achtelik <span dir="ltr"><<a href="mailto:Sven.Achtelik@eps.aero" target="_blank">Sven.Achtelik@eps.aero</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div link="#0563C1" vlink="#954F72" lang="DE"><div class="m_9084488506430733388m_5824757911453024932WordSection1"><p class="MsoNormal"><span style="color:#1f497d">Hi,<u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-US">does anyone know if this information is pulled from the logs and if it’s related to the log-rotation or if this is part of the Engine DB. I need to know if it’s possible to read this information like 2 or 3 years later for some auditing purpose. It might help if you could let me know where to look at. <u></u><u></u></span></p><p class="MsoNormal"><a name="m_9084488506430733388_m_5824757911453024932__MailEndCompose"><span style="color:#1f497d" lang="EN-US"><u></u> <u></u></span></a></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-US">Thank you, <u></u><u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span style="color:#1f497d" lang="EN-US">Sven<u></u><u></u></span></p><div><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0cm 0cm 0cm"><p class="MsoNormal"><b><span>Von:</span></b><span> <a href="mailto:users-bounces@ovirt.org" target="_blank">users-bounces@ovirt.org</a> [mailto:<a href="mailto:users-bounces@ovirt.org" target="_blank">users-bounces@ovirt.or<wbr>g</a>] <b>Im Auftrag von </b>Sven Achtelik<br><b>Gesendet:</b> Donnerstag, 16. März 2017 11:54<br><b>An:</b> <a href="mailto:users@ovirt.org" target="_blank">users@ovirt.org</a><br><b>Betreff:</b> [ovirt-users] Event History for a VM<u></u><u></u></span></p></div></div><div><div class="m_9084488506430733388h5"><p class="MsoNormal"><u></u> <u></u></p><p class="MsoNormal"><span lang="EN-US">Hi All, <u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">I would need to have an Event-History of our VMs for auditing purposes that is able to go back until the moment the VM was created/imported. I found the Events Tab in the VM view and found that this is not showing everything to the moment of creation. Things that are important for me would be any change in CPUs or Host that the VM is pinned to. Are the Events stored in the Engine DB and can I read them in any way ? Is there a value that needs to be changed in order to keep all Events for a VM ? <u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">Thank you for helping, <u></u><u></u></span></p><p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p><p class="MsoNormal"><span lang="EN-US">Sven<u></u><u></u></span></p><p class="MsoNormal"><u></u> <u></u></p></div></div></div></div></blockquote></div><br></div><div class="gmail_extra">+1</div><span class="HOEnZb"><font color="#888888"><div class="gmail_extra"><br></div><div class="gmail_extra">Gianluca</div></font></span></div>
<br>______________________________<wbr>_________________<br>
Users mailing list<br>
<a href="mailto:Users@ovirt.org">Users@ovirt.org</a><br>
<a href="http://lists.ovirt.org/mailman/listinfo/users" rel="noreferrer" target="_blank">http://lists.ovirt.org/<wbr>mailman/listinfo/users</a><br>
<br></blockquote></div><br></div>