VMware Cloud Community
Gabrie1
Commander
Commander
Jump to solution

Statistics about number of vmotions (manual / drs)

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

http://www.GabesVirtualWorld.com
Reply
0 Kudos
1 Solution

Accepted Solutions
Dave_Mishchenko
Immortal
Immortal
Jump to solution

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

View solution in original post

Reply
0 Kudos
2 Replies
Dave_Mishchenko
Immortal
Immortal
Jump to solution

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

Reply
0 Kudos
Gabrie1
Commander
Commander
Jump to solution

Thank you very much !!!!

http://www.GabesVirtualWorld.com
Reply
0 Kudos