wkwicker
Enthusiast
Enthusiast

Where is the reboot reason stored?

When rebooting a host through Virtual Center, you are asked to enter a reason for the reboot. Where is this stored?

0 Kudos
3 Replies
dmn0211
Enthusiast
Enthusiast

It is under "user logged event". You can see the message listed on the task and events tab in vCenter.

wkwicker
Enthusiast
Enthusiast

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.

0 Kudos
dmn0211
Enthusiast
Enthusiast

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

FROM VPX_EVENT_ARG

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.

0 Kudos