Port Group Script

# Read MyVLANs.csv for input and create virtual machine portgroups # Input file has a header row which contains cluster,vSwitch,VLANname,VLANid
# The virtual machine port groups will be created on all hosts in the cluster
# If the virtual port group exists it will be skipped but will write errors to the console
# Set the input file
$InputFile = "C:\Users\ewright\Documents\SCRIPTS-TEMP\MyVLANs.csv"

# Read the import file
$MyVLANFile = Import-CSV $InputFile

# Parse the input file and add the virtual port groups accordingly
ForEach ($VLAN in $MyVLANFile) { $MyCluster = $VLAN.cluster $MyvSwitch = $VLAN.vSwitch $MyVLANname = $VLAN.VLANname $MyVLANid = $VLAN.VLANid

# Query the cluster to retrieve the hosts
$MyVMHosts = Get-Cluster $MyCluster | Get-VMHost | sort Name | % {$_.Name}

# Loop through the hosts and add the virtual port group to our vswitch based on the input
ForEach ($VMHost in $MyVMHosts) { Get-VirtualSwitch -VMHost $VMHost -Name $MyvSwitch | New-VirtualPortGroup -Name $MyVLANname -VLanId $MyVLANid } }