How to export events / tasks info for a VM ?

[TonyJK]

We would like to get a copy of the events / tasks for a paricular VM for reference in the future (Instead of a screen print). Is there any way for us to export those information ?

Besides, I would like to know how long those information will be kept ? This is because when I migrate the VM to another host in the cluster, I find that the information (Task / Event) starts from scratch.

Moreover, does the log file stored in VC Server Database or they are stored with the VM ?

Thanks

[Dave_Mishchenko · Accepted solution]

You can get that from your VC database. The sample queries below will get you started. You'll just have to substitue VM_name for the VM you want to query about. The number for the 3rd query you can get by using the VMID number in the VPX_EVENT table.

There's a good description of the VC database tables here: http://vmware-land.com/Vmware_Tips.html#VC6

SELECT *

FROM VPX_TASK

where ENTITY_NAME = 'VM_name'

select * from VPX_EVENT

where VM_NAME = 'VM_name'

select * from VPX_event_arg

where VM_ID =