I get constant requests from application developers to provide CPU and memory usage for their virtual servers. The graphs in Virtual Center are fine but it's a manual process to extract them. I would like to pull the past 24 hours of CPU usage and Memory usage for each VM from VC SQL database but I'm having difficulty figuring out the schema. Th only documentation I can find is for VC 2.0 and it is a little different.

I can get the static VM information (ip address, number of cpu's assigned memory etc.) but I haven't figured out the performance data yet. I want to automate this to post graphs on an internal site. The Vizioncore products are good but provide far more than I need and are a little hefty in price.

Does anyone have an example SQL script for VC 2.5 that can pull this data?