Thanks, I see it there now. However, Virtual Center only shows about the last day of events and I am looking for reboots that occured a few months ago. Are these still in the VC database and not shown by VC or have they been purged.
It is stored in the dbo.VPX_EVENT_ARG.
This table is contains the event information. Getting the information out, not so easy. This query will give you all the string arg_types. This will contain any message typed in for reason during reboot
SELECT EVENT_ID, ARG_ID, ARG_TYPE, ARG_DATA, OBJ_TYPE, OBJ_NAME, VM_ID, HOST_ID, COMPUTERESOURCE_ID, DATACENTER_ID,
RESOURCEPOOL_ID, FOLDER_ID, ALARM_ID, SCHEDULEDTASK_ID
WHERE (ARG_TYPE = 'string') AND (ARG_ID = '0')
The problem is there is no correlation with the event ID in the VPX_EVENT table and the reboot event itself, making a link between them somewhat difficult, it is simply stated as a vim.event.GeneralUserEvent. However, the data is in the database in the VPX_EVENT_ARG table.