VMware Resource Metric Detail

DPA does not currently contain a report to show VMware metric details. The attached script can be used to retrieve values for a specified metric name (controlled by @MetricName variable) ordered by the collection timestamp. The values are typically collected once every minute.

To execute the script, connect to the DPA repository with Management Studio, open a query and copy/paste the attached script. Modify the 4 parameters at the top of the script 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.