VMware Infrastructure Toolkit – PowerShell Scripting


Microsoft PowerShell scripting is a must know for supporting VMware.

After spending days evaluating products that would report virtual infrastructure capacity to my liking and that were affordable, I opted to write my own reporting and capacity planning application using PowerShell scripts and Excel.

 Using PowerGUI and VI Toolkit for PowerShell I created two scripts: one script queries the Virtual Center for data storage capacity and utilization. The second script queries for VM to host capacity and memory – CPU metrics. The information is saved to a .CSV files once a week.


Using Excel, I import the .CSV files into my VM Dashboard (Excel) and run calculation for each VM environment (DEV, QA, Prod). To enhance the look of the dashboard, I have thrown in graphs to show resource utilization and a trending graph.


The VM dashboard has been well received by managers and those who want to follow week by week changes and usage of the virtual infrastructure. It also helps to proactively grow the VI because we can see weekly growth of each environment and know in advance to add more storage or other server resources.

To get started writing PowerShell scripts or to borrow scripts already written visit the VMware VMTN blog for PowerShell.

WAIT! Before You Go... Join Other Go-Getters

Enter your name & email address below to get started.

2 Responses to “VMware Infrastructure Toolkit – PowerShell Scripting”
  1. ron

We're listening. Go ahead and share your ideas?

vSphere 6
8 Updates That Make vSphere 6 Better – Keith Barker
25 VMware Interview Questions: Tough & Technical (Download)
VMware jobs in Phoenix
VMware Jobs in Phoenix Arizona (Comparing Opportunities)
DevOps training
10 Reasons VMware Admins Should Boost OpenStack Skills
DevOps Tools
DevOps Toolchain: Download 3 Free Tools Used By Pros (Ansible, Git, Jenkins)
MSDevOps Guide
Microsoft DevOps: 25+ Power-Packed Windows SysAdmin Skills (NEW Guide!)
continuous integration tools
DevOps Training Courses That Will Give You The Edge (Perfect For Beginners Who Want Skills That Are Noticed By Google & Facebook…)
Why DevOps Fails: How To Get Back On Track
Why DevOps Fails: How To Get Back On Track
Click here to learn how to Optimize WordPress Speed
WordPress Speed Optimization: Part 4 – VPS Case Study To Make VMinstall.com Rank Higher In Google Through Faster Hosting & High Availability @ Lower Cost
Best Hosting for WordPress
Case Study: Best VPS For Easy WordPress Migration
cloudways review updated
Cloudways Review: 12 Pros & Cons From My Deep Dive Testing (VPS Series: Part 2)
ServerPilot Review: Installing WordPress On DigitalOcean (VPS Series: Part 1)
Storage Engineer Skills
Why Storage Engineer Skills Are HOT! (Can You Say Big Data?)
Rise of the Robots
I’m Amazed After Reading Rise of the Robots – Best Jobs In 2017 (You won’t Guess what’s going on!)
top virtual reality jobs
30+ Awesome Virtual Reality Jobs That Take You From Boring To Amazing! (Must Read…)
Thinking Like Seth Godin
How To STOP A 300% Salary Loss Because YOU Think Like A SysAdmin: Start Thinking Like Seth Godin (Read Now!)
3 Open Source Storage Software Alternatives For Beginners
shades of devops
Free DevOps eBook Project (Read It Now!)
How to install Genymotion
How To Install Genymotion for Beginners (Includes Google Play)
20 Questions VMware Newbies Want Answered (Free Career Guide)