vSphere add storage from list in CSV

vsphere_add_storage.ps1

########################################################################################################
#
# Powershell Script for vSphere 
#
# Script to mass add storage to esxi host/cluster from data in CSV
#
# http://vspherepowershellscripts.blogspot.com.au/2014/07/vsphere-bulk-add-storage.html
########################################################################################################

if ( (Get-PSSnapin -Name VMware.VimAutomation.Core -ErrorAction SilentlyContinue) -eq $null )
{
    Add-PsSnapin VMware.VimAutomation.Core
}


# Enter the virtualcenter you wish to connect to
$vCenter = Read-Host "Enter vCenter Name or IP"
Connect-VIServer $vCenter

#Pull Lun information from CSV file
#Format is:
#ESXHost,LunName,LunID
#
#ESXHost = The host to create the VMFS volume on
#LunName = The Datastore Name
#LunID = The CanonicalName of the Lun i.e. naa.60060e80058fc60000008fc600006112
$CSVFile = "C:\Temp\datastores.csv"
$CSV = Import-CSV $CSVFile

Foreach ($Item in $CSV){
	$ESXHost = Get-VMHost $Item.ESXHost
	$LunName = $Item.LunName
   	$LunID = $Item.LunID
   	$Lun = Get-ScsiLun -CanonicalName $LunID -VmHost $ESXHost
   	Write-host "Creating $LunName $Lun on $ESXHost"
   	New-Datastore -VMHost $ESXHost -Vmfs -Name $LunName -Path $Lun 
} 

Disconnect-VIServer -Server $vCenter -Confirm:$false