Improved Host Import

A few months ago I uploaded a little demo that let you import hosts into VirtualCenter using a spreadsheet. Well if there’s one constant in software it’s feature requests. A reader mentioned to me that this would be a lot more useful if he could import hosts directly into resource pools, clusters and things like that. Since it’s pretty easy to do in PowerShell (less than 50 lines in total) I updated the spreadsheet in hopes that other people could get some use out of this.

Here’s a preview of what it looks like:


One shortcoming of the spreadsheet is that if the host belonged to some other VirtualCenter, it will exist in that VirtualCenter as a disconnected host. It’s fairly easy to get rid of these though, if you connect to the old VirtualCenter using the VI Toolkit, then run

they will all be removed. Enjoy!


2 comments have been added so far

  1. Has anyone been able to use powershell to upgrade the VMware Tools across all Windows Guests? If so can you post a copy of the script?

Leave a Reply

Your email address will not be published. Required fields are marked *