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
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
Post a Comment