DRS history will only show the most recent VMotion events, to get a more complete picture LudD has created a couple of fantastic functions. What they do is allow you to create a csv report of all the VMotion/SVMotions events of a period of time, for example 24, 48, or 72 hours –
This is Luc’s work, if you think its good, go buy his VMware vSphere PowerCLI Reference book, even if you don’t read it cover to cover, it’s one way of acknowledging his and others excellent contribution to the community..
The code is now on GitHub
Get-Cluster -Name Cluster1 | Get-MotionHistory -Hours 24 -Recurse:$true
Get-Cluster -Name Cluster1 | Get-MotionHistory -Hours 24 -Recurse:$true | Export-Csv C:\PowerCLI\Output\vmotion-report1.csv -NoTypeINformation -UseCulture
Be sure to dot source the both functions so they can be used
ie: period then a space and then the full or relative path to the function