topic Re: PowerCLI script for vSphere capacity planning in VMware PowerCLI Discussions

PowerCLI script for vSphere capacity planning

Marcus316 — Wed, 08 Jan 2014 00:19:03 GMT

Hello everyone!

After recent discussion on vSphere Capacity planning, I thought I would share one of the tools I use for this purpose. This is a side project I've been working on for few months.

I present to you, my very own "VMware Capacity & Performance Report PowerCLI script (v2.1 Community edition)"

http://1drv.ms/1J00vkq

(Click here then click on "Download")

This is a complex PowerCLI script I wrote, that generates an e-mail report that gives you insight into the current state of your VMware vSphere environment's capacity. It generates tables, pie charts and line charts with information about CPU, Memory & Storage capacity, VM Provisioning Potential, Cluster Resilience and more. Check the script's #INFORMATION block for more information about prerequisites, script input and output.

Have a look at the report it generates and let me know what you think of it!

Please share your thoughts and comments!

Marc Davoli

http://ca.linkedin.com/in/marcvincentdavoli/

Edited on May 25 : Changed OneDrive link to updated script v2.1 with bugfix (for cluster names with a space in it)

Re: PowerCLI script for vSphere capacity planning

LucD — Wed, 08 Jan 2014 06:04:27 GMT

That looks nice, I'll give it a try.

Thanks for sharing.

Re: PowerCLI script for vSphere capacity planning

davidcomerford — Thu, 16 Jan 2014 17:25:46 GMT

Well done, really useful script. Already have it on a monthly schedule

Re: PowerCLI script for vSphere capacity planning

Pinball — Mon, 05 May 2014 14:23:40 GMT

Hi Marc

First thing, this is a great piece of work and thanks for sharing it.

Do you know if it's possible to generate the report on a per Cluster base and not the individual ESXi host?

Thanks

Johan

Re: PowerCLI script for vSphere capacity planning

doyart — Tue, 06 May 2014 18:08:46 GMT

will this script stop any thing or will it just run, I see something referring to "REMOVING HOST", but cann not see that command.

Obviously I cannot just run and it stop a Host.

Thanks,

Art

Re: PowerCLI script for vSphere capacity planning

Marcus316 — Tue, 06 May 2014 19:50:50 GMT

Hi Pinball,

First, thanks!

Second, that's not how this script is programmed and I believe it would take a lot of work to change it.

You can always add a section at the end of the script that does this kind of thing.

Good luck!

Marc

Re: PowerCLI script for vSphere capacity planning

Marcus316 — Tue, 06 May 2014 19:52:12 GMT

Hi Doyart,

This script doesn't modify anything once it connects to vCenter.

In fact, you can run the script with Read Only permissions, it won't make a difference because all the script does is "GET" information.

Marc

Re: PowerCLI script for vSphere capacity planning

doyart — Wed, 07 May 2014 14:38:49 GMT

Marc,

Thanks for the fast reply, it seems to take long for me, I will try again tomorrow and give you update. I will say this is a very well written script nice job.

On a side note, in Vsphere where you go to summary tab of the Cluster there is a View Resource distribution chart, do you know how I can retrieve this in Powercli, simple version?

Seems to be elusive in threads.

Art

Re: PowerCLI script for vSphere capacity planning

Jellas — Mon, 12 May 2014 06:11:38 GMT

Hi Marcus316,

Not able to download the script. Link is broken.

http://sdrv.ms/1lNTIvu

Could you please reshare the link .

Thanks,
Sravana

Re: PowerCLI script for vSphere capacity planning

markdjones82 — Mon, 12 May 2014 13:11:54 GMT

I would like to check it out as well, the link is broken for me as well.

Re: PowerCLI script for vSphere capacity planning

LucD — Mon, 12 May 2014 13:32:12 GMT

Does the long URL work for you ?

For me it works with both

Re: PowerCLI script for vSphere capacity planning

doyart — Mon, 12 May 2014 19:03:48 GMT

It works for me.. nice script. Thanks

Re: PowerCLI script for vSphere capacity planning

markdjones82 — Mon, 12 May 2014 19:27:12 GMT

Seems as though my corp firewall is blocking

Re: PowerCLI script for vSphere capacity planning

LucD — Mon, 12 May 2014 19:48:26 GMT

I experience that with some shortened URLs as well :smileycry:

Re: PowerCLI script for vSphere capacity planning

markdjones82 — Mon, 12 May 2014 20:31:04 GMT

Even the long one is blocked lol, any drive download sites we block. Guess I'll have to figure out a "work around" (ie get it on home with usb transport)

Re: PowerCLI script for vSphere capacity planning

LucD — Mon, 12 May 2014 21:11:51 GMT

So much for security, block the site, but allow USB keys on/off premises :smileygrin:

Rest assured, I (mis)use that security hole as well :smileyblush:

Re: PowerCLI script for vSphere capacity planning

msaliu — Wed, 28 May 2014 16:25:02 GMT

Very useful script and thanks for sharing.

Re: PowerCLI script for vSphere capacity planning

dixitr — Thu, 26 Jun 2014 18:24:14 GMT

Good Script. Thanks

One quick question. Can we get the report in pdf format ?

Re: PowerCLI script for vSphere capacity planning

esxi1979 — Sun, 29 Jun 2014 17:45:42 GMT

LucD

DId you got a chance to review it ? Not many feedback tho ...

Marcus316 you considering subscription ration of cpu & memory here ?

Re: PowerCLI script for vSphere capacity planning

Marcus316 — Thu, 03 Jul 2014 14:38:17 GMT

Hi Dixitr,

Unfortunately not. The script is built from the ground up to be exported to HTML / e-mail format.

A workaround I could suggest is to open the exported .HTML file and save that page as a PDF file.

It's manual, but it works.

Thanks