Re: [ovirt-users] Event History for a VM
On Thu, Mar 16, 2017 at 12:54 PM, Sven Achtelik wrote: > Hi All, > > > > 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 ? IIUC that's AuditLogAgingThreshold (in engine-config), defaults to 30 days. IIUC it's not designed to be extended "forever" - doing so will likely have a significant impact on performance. You might also want to have a look at Event Notifications: http://www.ovirt.org/documentation/admin-guide/chap-Event_Notifications/ Best, > > > > Thank you for helping, > > > > Sven > > > > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > -- Didi ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Event History for a VM
Hi Kevin, thank you for the details on this. Do you also know how and where things like changes to the VMs CPUs or preferred host or Ram are stored ? I’m looking for the ability to show the history of a VM. Example: I have a VM that has 4 vCPus, 64GB Ram and is pinned to host 1. 2 or 3 years later I need to be able to show an auditor that this has not changed throughout that time. Are those changes recorded ? an if that’s the case are the recorded in the DB ? Thank you, Sven Von: Kevin Goldblatt [mailto:kgold...@redhat.com] Gesendet: Dienstag, 21. März 2017 09:32 An: Gianluca Cecchi Cc: Sven Achtelik ; users@ovirt.org; Raz Tamir ; Goldblatt, Kevin Betreff: Re: [ovirt-users] Event History for a VM Hi Sven, On your engine you can run the following to get the vms info from the engine database: su - postgres -c "psql -U postgres engine -c 'select * from vms;'" |less -S You may also find some info on the specific vm in the engine log and the libvirt log: 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). On the host the the vm runs on - /var/log/libvirt/qemu/vm111.log Hope this helps, Kevin On Tue, Mar 21, 2017 at 9:45 AM, Gianluca Cecchi mailto:gianluca.cec...@gmail.com>> wrote: On Tue, Mar 21, 2017 at 8:42 AM, Sven Achtelik mailto:sven.achte...@eps.aero>> wrote: Hi, 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. Thank you, Sven Von: users-boun...@ovirt.org<mailto:users-boun...@ovirt.org> [mailto:users-boun...@ovirt.org<mailto:users-boun...@ovirt.org>] Im Auftrag von Sven Achtelik Gesendet: Donnerstag, 16. März 2017 11:54 An: users@ovirt.org<mailto:users@ovirt.org> Betreff: [ovirt-users] Event History for a VM Hi All, 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 ? Thank you for helping, Sven +1 Gianluca ___ 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
Re: [ovirt-users] Event History for a VM
Hi Sven, On your engine you can run the following to get the vms info from the engine database: su - postgres -c "psql -U postgres engine -c 'select * from vms;'" |less -S You may also find some info on the specific vm in the engine log and the libvirt log: 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). On the host the the vm runs on - /var/log/libvirt/qemu/vm111.log Hope this helps, Kevin On Tue, Mar 21, 2017 at 9:45 AM, Gianluca Cecchi wrote: > On Tue, Mar 21, 2017 at 8:42 AM, Sven Achtelik > wrote: > >> Hi, >> >> >> >> 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. >> >> >> >> Thank you, >> >> >> >> Sven >> >> *Von:* users-boun...@ovirt.org [mailto:users-boun...@ovirt.org] *Im >> Auftrag von *Sven Achtelik >> *Gesendet:* Donnerstag, 16. März 2017 11:54 >> *An:* users@ovirt.org >> *Betreff:* [ovirt-users] Event History for a VM >> >> >> >> Hi All, >> >> >> >> 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 ? >> >> >> >> Thank you for helping, >> >> >> >> Sven >> >> >> > > +1 > > Gianluca > > ___ > Users mailing list > Users@ovirt.org > http://lists.ovirt.org/mailman/listinfo/users > > ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Event History for a VM
On Tue, Mar 21, 2017 at 8:42 AM, Sven Achtelik wrote: > Hi, > > > > 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. > > > > Thank you, > > > > Sven > > *Von:* users-boun...@ovirt.org [mailto:users-boun...@ovirt.org] *Im > Auftrag von *Sven Achtelik > *Gesendet:* Donnerstag, 16. März 2017 11:54 > *An:* users@ovirt.org > *Betreff:* [ovirt-users] Event History for a VM > > > > Hi All, > > > > 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 ? > > > > Thank you for helping, > > > > Sven > > > +1 Gianluca ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
Re: [ovirt-users] Event History for a VM
Hi, 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. Thank you, Sven Von: users-boun...@ovirt.org [mailto:users-boun...@ovirt.org] Im Auftrag von Sven Achtelik Gesendet: Donnerstag, 16. März 2017 11:54 An: users@ovirt.org Betreff: [ovirt-users] Event History for a VM Hi All, 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 ? Thank you for helping, Sven ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users
[ovirt-users] Event History for a VM
Hi All, 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 ? Thank you for helping, Sven ___ Users mailing list Users@ovirt.org http://lists.ovirt.org/mailman/listinfo/users