Query event and task logs in vCenter 5

[JonKemp]

Greetings All

I am hoping someone out there can help with this one.

I need to fnd out when a resource pool was renamed and by which user. At some point over the last two months I know the resource pool was changed as View couldn't find the resource when it came to a recompose job. I now need to find out which user madethe change and ideally when.

Any help greatly appreciated.

Jon

[mrksiddiqui]

I am not sure if there are powecli interface that will let you do that. But if you know SQL here is how you can do it. Query vCenter table VPX_task look for DESCRIPTIONID = "vim.ResourcePool.createResourcePool"

SELECT     TASK_ID, NAME, DESCRIPTIONID, ENTITY_ID, ENTITY_TYPE, ENTITY_NAME, LOCKED_DATA, COMPLETE_STATE, CANCELLED, CANCELLABLE, ERROR_DATA,

                      RESULT_DATA, PROGRESS, REASON_DATA, QUEUE_TIME, START_TIME, COMPLETE_TIME, EVENT_CHAIN_ID, USERNAME, VM_ID, HOST_ID,

                      COMPUTERESOURCE_ID, DATACENTER_ID, RESOURCEPOOL_ID, FOLDER_ID, ALARM_ID, SCHEDULEDTASK_ID, CHANGE_TAG_ID, PARENT_TASK_ID,

                      ROOT_TASK_ID

FROM         VPX_TASK

ORDER BY TASK_ID DESC

If this helps answer your question please consider awarding points!