History of vmotion events

[darrellr]

I'm hoping someone can advise on a method for collating the history if migration events for a particular guest for the past 6 months.

I have a certain amount of history available in VCenter and have amended the Client Settings/Lists settings to the maximum (1000), however this only givesme around 2 months history and I need to get the timings of all migration events going back to beginning of August.

What logs are available and the best way to interrogate for a single guest?

Thanks in advance.

[jdptechnc · Accepted solution]

Do you have access to the vCenter SQL database?  If you want something quick and dirty, you can do this with a simple query.  The database should have all tasks scheduled since the vCenter instance was installed.

Something like this:

use VCDB

SELECT [TASK_ID]
      ,[NAME]
      ,[ENTITY_NAME]
      ,[COMPLETE_STATE]
      ,[QUEUE_TIME]
      ,[START_TIME]
      ,[COMPLETE_TIME]
  FROM [vcdb].[dbo].[VPX_TASK]
  where (NAME = 'vim.VirtualMachine.migrate' or NAME = 'vim.VirtualMachine.relocate') AND ENTITY_NAME = 'MY_VM'
  order by START_TIME desc

The "migrate" task is a host migation, the "relocate" task is a datastore migration.

[EdWilts]

You can check your vmware*.log files on the datastore for a quick and dirty search.  They may or may not go back far enough for you.

grep Hostname vmware*.log

[darrellr]

Thanks for the reply. Great for future ref.

Unfortunately task and event retention is set for 60 days so no joy this time.