If you have configured DPA to monitor your VMware environment (Options > VMware Register), this custom query can be used to show all events for a specific VM. Events include powering on/off a VM, a moving a VM from one ESX host to another, etc.
To execute this query, connect to the DPA repository using Management Studio (or other query tool), connect to the DPA repository, copy/paste in the attached script and modify the first 3 variables as needed.
Note: this script uses the "ignite" schema when referencing tables. Some installation run the DPA repository using the "dbo" schema, so if you get errors about the ignite schema, remove it and the script should then work.
