VM inventory

[ygao]

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.

[lamw]

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

VMware Developer Comuunity

Twitter: @lamw

If you find this information useful, please award points for "correct" or "helpful".

[Datto]

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:

http://www.virtu-al.net/

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

[a2alpha]

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