vCenter database query - CPU ready
This came up when our team lead wanted a method for seeing global CPU ready values over a length of time to provide factual basis during performance audits. The viclient performance tab only allows you to view one VM at a time, and compiling data from that manually is painful at best. We thought about it a bit, then realized that all these historical statistics are stored in the vCenter database, so why not do a DB query to pull the relevant info? I looked into it, and similar things have been done before. With those as a basis for my query, I dug in to what was in the vCenter database and how to best present it. What I ended up with is not as automated as I'd like, but good enough for being used once or twice a year for audits. This one was a lot of fun! Full article on the wiki: http://wiki.practicaltech.ca/index.php/VCenter_stuff