A. Mikkelsen VMware ESX scripts, commands, tools and other nice to know things that will make your virtualization days easier!!!!

Wednesday, June 25, 2008

Listing DRS VMotion info from VC database

Filed under: ESXi,Tools,Virtual Center,vSphere (ESX) — A. Mikkelsen @ 22:16 pm

Ever wanted to see how many DRS VMotion your ESX enviroment is generating?

Using the following query you can extract the requried information from the VC database.

SELECT vpx_event.event_type, vpx_event.vm_name, vpx_event.create_time
from vpx_event where event_type like ‘%migrate%’

(Thanks to: Dave.Mishchenko
http://communities.vmware.com/message/969563
)

Also see http://www.gabesvirtualworld.com/?p=69 for an idear to what you can do with the information in Excel.

Powered by WordPress