Statistics about number of vmotions (manual / drs)

[Gabrie1]

Hi

I would like to get more info about manual and automatic (DRS) performed vmotions. How many since data x? How many per day? What VMs get vmotioned the most? etc etc. Where can I get this data from?

Gabrie

[Dave_Mishchenko]

The events will be in the vpx_event table in the VC. The 2nd will give you a list of all events types (or specifically the events that your VC database have recorded). You may find some useful events related that don't have migrate as part of the event type name.

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

SELECT distinct(vpx_event.event_type) from vpx_event order by event_type

[Gabrie1]

Thank you very much !!!!