Well, you've already found the ESX Host Configuration Report - and there is a similar VM Configuration Report in our MP.
The ESX Host report shows the VMs on each Host, and the VM Report also shows the "host" property for each VM.
However seems to me you want to capture a change
, when a VM moves to another host, e.g. due to HA failover or DRS.
You can do this right now by using one of the built-in SCOM Reports, from the Generic Report Library, called Configuration Changes.
Here's how -
* Open SCOM Reporting, Microsoft Generic Report Library, and run Configuration Changes.
* Click Add Group, search for "guest" and add the group 'nworks VMware Guests' (assuming you want to report on all VMs - you can use any group)
* Choose your dates (bracketing your known host failover event for example)
Run report, and you will see date and time that any VM property changed - and "host" is one of those properties.
That should give you what you need!
You can also export report to excel for example, and do some smart filtering for just the 'host' property you want.
Although - please also check out Veeam Reporter Enterprise!
It has some very cool reports for tracking changes in your VMware environment.
Hope the above helps - let us know!