Johnny Zhang
I remember some customers were asking if there is a way to find out how many vmotions in total the vCenter kicked off.

You might able to find this out by query from the SQL database (Yes, you need to have access to the DB)

I test this on vCenter 2.5 (There maybe some modification on vCenter 4.0 which I will get a follow up later when I test it myself)

Log into SQL managment studio --> New query --> type in:

USE Your_DB_Name
GO

SELECT
Entity_name,
complete_state,
queue_time,
start_time,
complete_time,
event_chain_id,
username

FROM vpx_task

WHERE name='vim.VirtualMachine.migrate'

GO

You should get the information you are looking for. If you want more details you can use

SELECT *

FROM vpx_task

WHERE name='vim.VirtualMachine.migrate'

GO
0 Responses

Post a Comment

There was an error in this gadget