I need to run a report on our VM environment, I need the # of host per site, # of total CPUs per site, # of VMs per site.
I need them in either PDF or excel format. I have about 900 vms.
Anyone knows a good tool, preferely free?
Thanks.
Here are some scripts that'll help generate this information:
vSphere SDK for Perl scripts:
PowerCLI:
Daily Report v2: http://www.virtu-al.net/2009/08/18/powercli-daily-report-v2/
=========================================================================
William Lam
VMware vExpert 2009
VMware ESX/ESXi scripts and resources at:
VMware Code Central - Scripts/Sample code for Developers and Administrators
If you find this information useful, please award points for "correct" or "helpful".
You could look at Virtu-Al's website which is filled with good Powershell reporting scripts for the kinds of information you're looking at:
See if Virtu-Al's daily report will give you all you need:
http://www.virtu-al.net/2009/08/18/powercli-daily-report-v2/
Datto
Try this script attached.
Should have everything you need, it outputs to an HTML file but you can copy and paste the tabular data straight into excel or print it to PDF if you want with PDF995 or something.
I extracted the things you need from I full healthcheck script I use HERE
Hope it helps,
Dan