Allen McGuire has a few Reporting Services reports that he created against vCenter Database:
So you are a DBA and you are in a virtual environment – VMware in particular. You are curious to know the health of the VMware hosts in terms of CPU and RAM, but you really don’t know how to get the data you need and you’re not certain if the information you are asking for is entirely accurate. Well, chances are you have access to the VMware databases themselves – if that is the case, you can create these reports based on a blog post from Jonathan Kehayias: “Querying the VMware vCenter Database (VCDB) for Performance and Configuration Information“.
I have created five reports that are based on Jonathan’s queries and you can download the RDL for the SSRS reports below – enjoy!
Click through for the reports.