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.

Similar Posts:

• PowerShell Script for Snapshot Backup of Hyper-V VM
• vKernel CapacityVIEW is Free and Works!
• Zombie VMs Soon to be Hunted by vZombie
• How to Apply for a VMware Engineer Job
• Rescuing A Poor Performing VMware Virtual Infrastructure