JGcomp

Function Set-Cred ($File) {
$Credential = Get-Credential
$credential.Password | ConvertFrom-SecureString | Set-Content $File
}

$creds = New-Object System.Management.Automation.PsCredential(“AD\ADUSER”, (Get-Content “c:\mycred.crd” | ConvertTo-SecureString))
   $VIServer = Connect-VIServer -Server $VIServ -Credential $creds

# vCenter ESX Host and VM Summary Report
# Connects to multiple vCenter Servers
# Captures totals for ESX Hosts, and VMs and works out how many Windows, Linux and Solaris VMs there are
# Saves this info into various CSV viles depending on how detaild a report you need
# John Gibson
#
 
$vchosts = @()
$vc = @()
$ReportOutput = @()
$ReportRegion = @()
$ReportPlatform = @()
$AllVMs = @()
$Decimals = 1
$CurrentDate = get-date -format "yyyyMMdd"
$YesterdayStart = (get-date -Hour 00 -Minute 00 -Second 00).adddays(-1)
$YesterdayEnd = (get-date -Hour 23 -Minute 55 -Second 00).adddays(-1)
 
# Read a text file which contains a list of vCenter server names and their region name
$file = "D:\Group_vCenter_Servers.txt"
$vchosts = get-content $file
 
# For each vCenter Server
foreach($vc in $vchosts){
    $vc1 = $vc.split("`t ")
    write-host "Processing Stats for "$vc
    $VIServ = $vc1[0]
    $Region = $vc1[1]
    $creds = New-Object System.Management.Automation.PsCredential(“AD\ADUSER”, (Get-Content “c:\mycred.crd” | ConvertTo-SecureString))
    $VIServer = Connect-VIServer -Server $VIServ -Credential $creds
 
    if ($null -eq $VIServer) {
	write-host "Retrying Connect to "$VIServ
$VIServer = Connect-VIServer -Server $VIServ -Credential $creds
    }
 
    $ReportRegion = "" | Select Region,vCenterServer,ESXHosts,TotalVM,TotalWinSrv,Win2000,Win2003,Win2008,WinNT,WinXP,WinVista,Win7,RedHat,Suse,Solaris,Other
    $ReportRegion.Region = $Region
    $ReportRegion.vCenterServer = $VIServ
    $vmhosts = Get-vmhost
	# Multiple retries as some timeouts over long distance connections
    if ($null -eq $vmhosts) {
	write-host "Retrying "$VIServ
        $vmhosts = Get-vmhost
    }
    if ($null -eq $vmhosts) {
	write-host "Retrying "$VIServ
        $vmhosts = Get-vmhost
    }
    if ($null -ne $vmhosts) {
	    $ReportRegion.ESXHosts = $vmhosts.count
    	$report = @()
	    get-vm | Where {$_.PowerState -eq "PoweredOn"} | Sort Name -Descending | get-view | % {
	        $vm = "" | Select-Object Region,VMName,GuestVersion,VMVersion,NumCPU,MemoryMB,ipaddress,toolsstatus,toolsrunningstatus,toolsversion,GuestState,hostname,ESXHostID
	        $vm.region = $Region
                $vm.VMName = $_.Name
	        $vm.GuestVersion = $_.Config.GuestFullName
	        $vm.VMVersion = $_.config.version
	        $vm.NumCPU = $_.config.hardware.numcpu
	        $vm.MemoryMB = $_.config.hardware.MemoryMB
	        $vm.ipaddress = $_.guest.ipaddress
	        $vm.toolsstatus = $_.guest.toolsstatus
	        $vm.ToolsRunningStatus = $_.guest.ToolsRunningStatus
	        $vm.ToolsVersion = $_.guest.ToolsVersion
	        $vm.GuestState = $_.guest.GuestState
	        $vm.hostname = $_.guest.hostname
	        $vm.ESXHostID = $_.runtime.host.value
	        $report += $vm
	}
        $vmfilename = "D:\vSphere\Reports\VM\Detail\"+$Region+"_"+$CurrentDate+"_"+$VIServ+"_VM_List.csv"
        $report | Export-Csv $vmfilename -noType
	$AllVMs += $Report
 
	$ReportRegion.TotalVM = $report.count
	$ReportRegion.Win2000 = (@($report | Where {$_.GuestVersion -like "*Windows 2000*" }).Count)
	$ReportRegion.Win2003 = (@($report | Where {$_.GuestVersion -like "*Windows Server 2003*" }).Count)
	$ReportRegion.Win2008 = (@($report | Where {$_.GuestVersion -like "*Windows Server 2008*" }).Count)
	$ReportRegion.WinNT = (@($report | Where {$_.GuestVersion -like "*Windows NT*" }).Count)
	$ReportRegion.WinXP = (@($report | Where {$_.GuestVersion -like "*Windows XP*" }).Count)
	$ReportRegion.WinVista = (@($report | Where {$_.GuestVersion -like "*Windows Vista*" }).Count)
	$ReportRegion.Win7 = (@($report | Where {$_.GuestVersion -like "*Windows 7*" }).Count)
	$ReportRegion.RedHat = (@($report | Where {$_.GuestVersion -like "*Red Hat*" }).Count)
	$ReportRegion.Suse = (@($report | Where {$_.GuestVersion -like "*Suse*" }).Count)
	$ReportRegion.Solaris = (@($report | Where {$_.GuestVersion -like "*Solaris*" }).Count)
	$ReportRegion.Other = $report.count - $ReportRegion.Win2000 - $ReportRegion.Win2003 - $ReportRegion.Win2008 - $ReportRegion.WinNT - $ReportRegion.WinXP - $ReportRegion.WinVista - $ReportRegion.Win7 - $ReportRegion.RedHat - $ReportRegion.Suse - $ReportRegion.Solaris
	$ReportRegion.TotalWinSrv = $ReportRegion.Win2000 + $ReportRegion.Win2003 + $ReportRegion.Win2008 + $ReportRegion.WinNT
    }
	(get-view serviceinstance).Client.Logout()
	$ReportOutput += $ReportRegion 
 
}
 
$Filename = "D:\vSphere\Reports\VM\"+$CurrentDate+"_ESX_VM_vCenter_Report.csv"
$ReportOutput | Export-Csv $Filename -noType 
 
$ReportRegion = $ReportOutput | group Region | select Name,
@{Name="ESXHosts";Expression={($_.Group | Measure-Object -Sum ESXHosts).Sum }},
@{Name="TotalVM";Expression={($_.Group | Measure-Object -Sum TotalVM).Sum }},
@{Name="TotalWinSrv";Expression={($_.Group | Measure-Object -Sum TotalWinSrv).Sum }},
@{Name="Win2000";Expression={($_.Group | Measure-Object -Sum Win2000).Sum }},
@{Name="Win2003";Expression={($_.Group | Measure-Object -Sum Win2003).Sum }},
@{Name="Win2008";Expression={($_.Group | Measure-Object -Sum Win2008).Sum }},
@{Name="WinNT";Expression={($_.Group | Measure-Object -Sum WinNT).Sum }},
@{Name="WinXP";Expression={($_.Group | Measure-Object -Sum WinXP).Sum }},
@{Name="WinVista";Expression={($_.Group | Measure-Object -Sum WinVista).Sum }},
@{Name="Win7";Expression={($_.Group | Measure-Object -Sum Win7).Sum }},
@{Name="RedHat";Expression={($_.Group | Measure-Object -Sum RedHat).Sum }},
@{Name="Suse";Expression={($_.Group | Measure-Object -Sum Suse).Sum }},
@{Name="Solaris";Expression={($_.Group | Measure-Object -Sum Solaris).Sum }},
@{Name="Other";Expression={($_.Group | Measure-Object -Sum Other).Sum }}
 
$Filename = "D:\vSphere\Reports\VM\"+$CurrentDate+"_ESX_VM_Region_Report.csv"
$ReportRegion | Export-Csv $Filename -noType 
 
$ReportPlatform = $ReportOutput | group Region | select Name,
@{Name="ESXHosts";Expression={($_.Group |Measure-Object -Sum ESXHosts).Sum }},
@{Name="WinSrv";Expression={($_.Group | Measure-Object -Sum TotalWinSrv).Sum }},
@{Name="Linux";Expression={($_.Group | Measure-Object -Sum RedHat).Sum + ($_.Group | Measure-Object -Sum Suse).Sum }},
@{Name="Solaris";Expression={($_.Group | Measure-Object -Sum Solaris).Sum }}
 
$Filename = "D:\vSphere\Reports\VM\"+$CurrentDate+"_ESX_VM_Platform_Report.csv"
$ReportPlatform | Export-Csv $Filename -noType 
 
$Filename = "D:\vSphere\Reports\VM\"+$CurrentDate+"_ALL_VM_Report.csv"
$AllVMs | Export-Csv $Filename -noType

# vCenter ESX Host DataStore summary Report
# John Gibson
#
 
$vchosts = @()
$vc = @()
$ReportOutput = @()
$ReportRegion = @()
$ReportPlatform = @()
$Decimals = 1
$CurrentDate = get-date -format "yyyyMMdd"
$YesterdayStart = (get-date -Hour 00 -Minute 00 -Second 00).adddays(-1)
$YesterdayEnd = (get-date -Hour 23 -Minute 55 -Second 00).adddays(-1)
$VIServ = 'vcenter.fqdn'
$Region = 'Region'
 
Function Connect-SQL ($SqlQuery) {
    # Set the SQL Server
    $SqlServer = "SQLSERVER\INSTANCENAME"
    $SqlDatabase = "vcenterdatabase"
	$userid = 'dbuser'
	$userpass = 'dbpassword'
    # Setup SQL Connection
    $SqlConnection = New-Object System.Data.SqlClient.SqlConnection
    $SqlConnection.ConnectionString = "Server = $SqlServer; Database = $SqlDatabase; Integrated Security = False; user=$userid; password=$userpass"
    # Setup SQL Command
    $SqlCmd = New-Object System.Data.SqlClient.SqlCommand
    $SqlCmd.CommandText = $SqlQuery
    $SqlCmd.Connection =  $SqlConnection
    # Setup .NET SQLAdapter to execute and fill .NET Dataset
    $SqlAdapter = New-Object System.Data.SqlClient.SqlDataAdapter
    $SqlAdapter.SelectCommand = $SqlCmd
    $DataSet = New-Object System.Data.DataSet
    #Execute and Get Row Count
    $nRecs = $SqlAdapter.Fill($DataSet)
    if ($nRecs -gt 0)
    {
        # Do Stuff
        $dataSet.Tables | Select-Object -Expand Rows
    }
}
 
    $creds = New-Object System.Management.Automation.PsCredential(“AD\ADUSER”, (Get-Content “c:\mycred.crd” | ConvertTo-SecureString))
    $VIServer = Connect-VIServer -Server $VIServ -Credential $creds
 
    $objHosts = @()
    $DataStores = get-datastore | get-view
 
    if ($null -ne $DataStores) {
        foreach ($DataStore in $DataStores) {
            $objHost = "" | Select Region,Date,Name,CapacityGb,FreeSpaceGb,UncommittedGb,AllocatedGb,PercentAllocated,Accessible,MultipleHostAccess,Type,Version,BlockSizeMb
            write-host "Processing DataStore "$DataStore.Name
            $objHost.Region = $Region
			$objHost.Date = $CurrentDate
            $objHost.Name = $DataStore.Name
            $objHost.CapacityGb = [math]::round($DataStore.Summary.Capacity / 1Gb)
            $objHost.FreeSpaceGb = [math]::round($DataStore.Summary.FreeSpace / 1Gb)
            $objHost.UncommittedGb = [math]::round($DataStore.Summary.Uncommitted / 1Gb)
            $objHost.AllocatedGb = [math]::round(((($DataStore.Summary.Capacity - $DataStore.Summary.FreeSpace) + $DataStore.Summary.Uncommitted)) / 1Gb)
            $objHost.PercentAllocated = [math]::round(((($DataStore.Summary.Capacity - $DataStore.Summary.FreeSpace) + $DataStore.Summary.Uncommitted)*100)/$DataStore.Summary.Capacity,0)
            $objHost.Accessible = $DataStore.Summary.Accessible
            $objHost.MultipleHostAccess = $DataStore.Summary.MultipleHostAccess
            $objHost.Type = $DataStore.Info.vmfs.Type
            $objHost.Version = $DataStore.Info.vmfs.Version
            $objHost.BlockSizeMb = $DataStore.Info.vmfs.BlockSizeMb
			if ($null -eq $objHost.Type) {
            	$objHost.Type = $DataStore.Info.nas.Type
            	$objHost.Version = 0
            	$objHost.BlockSizeMb = 0
			}
            $objHosts = $objHosts + $objHost
        }
     }
 
$Filename = "D:\vSphere\Reports\"+$CurrentDate+"_DataStore_Summary_Report.csv"
$objHosts | Sort Name | Export-Csv $Filename -noType
$Filename = "D:\vSphere\Reports\DataStore_Summary_Report.csv"
$objHosts | Sort Name | Export-Csv $Filename -noType 
 
# Write records to SQL Database
write-host "Writing records to SQLDatabase"
foreach ($ObjHost in $objHosts){
	$SqlWrite = "INSERT INTO HSBC_DataStores VALUES ('"+$ObjHost.Region+"', '"+$ObjHost.Date+"', '"+$ObjHost.Name+"', "+$ObjHost.CapacityGb+", "+$ObjHost.FreeSpaceGb+", "+$ObjHost.UncommittedGb+", "+$ObjHost.AllocatedGb+", "+$ObjHost.PercentAllocated+", '"+$ObjHost.Accessible+"', '"+$ObjHost.MultipleHostAccess+"', '"+$ObjHost.Type+"', '"+$ObjHost.Version+"', "+$ObjHost.BlockSizeMb+")"
	Connect-SQL $SqlWrite
}
 
(get-view serviceinstance).Client.Logout()

# Connect to the VI Server
$erroractionpreference = "SilentlyContinue"
Write-Host "Connecting to vCenter"
Connect-VIServer "vcenter.fqdn" -user AD\ADuser -password 'ADPassword'
$VMHosts = Get-VMHost | Sort-Object Name
Disconnect-VIServer -Confirm:$False
# Ive 2 local accounts I want to change...
 
$vmadminaccount = "vmadmin"
$vmadminpassword = "C0mplexPassword1"
$vmopsaccount = "vmops"
$vmopspassword = "C0mplexPassword2"
 
# For each host, connect to the host as root, then change the passwords I want to change...
 
ForEach ($VMHost in $VMHosts)
{
	$HostName = $VMHost.Name
 
	$sgServer = Connect-VIServer -Server $HostName -User root -Password RootPassword
    Write-host "Changing passwords on " $HostName
 
	# if ESX then allow Shell Access, if not then dont...
    $ESXHost = get-vmhost | get-view
	If ($ESXHost.Config.Product.name -ne "VMware ESXi"){
		$Access = $true
	} Else {
		$Access = $false
	}
 
	New-VMHostAccount -Group $vmadminaccount
	Set-VMHostAccount -UserAccount $vmadminaccount -password $vmadminpassword -Description "VMware Local ESXi Administrator" -AssignGroups $vmadminaccount -GrantShellAccess $Access
 
	New-VMHostAccount -Group $vmopsaccount
	Set-VMHostAccount -UserAccount $vmopsaccount -password $vmopspassword -Description "VMware Local ESXi Operations Administrator" -AssignGroups $vmopsaccount -GrantShellAccess $Access
 
	Disconnect-VIServer -Confirm:$false
 
}

# SAMPLE - Change variables for your Site
#
# VMware PowerCLI Script to configure a VMware ESXi Host
# Designed for VMware ESXi on HP 460c G6 Blades
# But should work for most hosts with some variable changes
# Will work with an IP address but the storage will be renamed to XX.XX.XX.X-LOCAL instead of HOSTNAME-LOCAL
# Host should be deployed from ISO
# Assumes root password and IP Details configured (IP, DNS and search suffix)
# At that point when the host is on the network this script can be run
# Once this script is complete, add the host to vCenter and reboot the host and
# then validate the host is configured correctly.
#
# John Gibson - March 2010
# version 1.0 - Initial script creation
# version 1.1 - Updated script to set DNS Settings on Hosts
# version 1.2 - Updated script and structure of script
# 
 
# Set Variables to be used in the ESXi Host configuration
#
# Modify these settings for regional requirements
#
 
# ESXi Host Patch repository where the offline bundles have been extracted to
	$patchURL = "http://servername.fqdn"
 
# NTP Time Servers to use
	$ntp1 = "your.NTP.Server1.fqdn"
	$ntp2 = "your.NTP.Server1.fqdn"
 
# DNS Search Details to use
	$DomainName = "host.dns.doman.name"
	$DNSSearch = "host.dns.search.name"
	$PreferredDNS = "x.x.x.x"
	$AltDNS = "x.x.x.x"
 
# These NICs are connected to the management network vSwitch0
	$esxnics = "vmnic0","vmnic1"
 
# This/these NICs are connected to the VM network vSwitch1
	$vmnics = "vmnic2","vmnic3"
 
# VMotion Subnet Mask
	$VMotionSubnet = "255.255.255.0"
 
# Local Accounts to be created with VMware Admin Rights
# Note: Complex passwords are needed or ESXi will reject them
	$vmadminaccount = "vmadmin"
	$vmadminpassword = "C0mp1exPassw0rd"
	$vmopsaccount = "vmops"
	$vmopspassword = "C0mp1exPassw0rd"
	$eccuserpassword = "C0mp1exPassw0rd"
 
	Write-Host "ESXi Configuration script for VMware ESXi Hosts for HP Servers"
 
# Capture unique variables for the ESXi Host by user input
	$vmhost=(Read-Host "Enter just the name of the ESXi Host (e.g. hostname)").ToLower()
	$HostPassword=Read-Host "Enter the password to the root account on the ESXi Host"
	$VMotionIP=Read-Host "Enter the VMotion IP address for this ESX Host (x.x.x.x)"
	$vSwitch1Name=Read-Host "Enter the name of the Virtual Machine network (e.g. 192.168.10.1 Subnet)"
	$vSwitch1VLAN=Read-Host "Enter the number of the Virtual Machine VLAN (0 if not trunked)"
	if ("0" -ne $vSwitch1VLAN){
		$vSwitch1Name2=Read-Host "Enter the name of the Second Virtual Machine network (Press 0 to skip)"
		if ("0" -ne $vSwitch1Name2){
			$vSwitch1VLAN2=Read-Host "Enter the number of the Second Virtual Machine VLAN"
		}
	}
 
# Authenticate to ESX Host...
	write-host "Connecting to " $vmhost
	$esxhost = Connect-VIServer $vmhost -User root -Password $HostPassword
 
# First puts the ESX host into maintenance mode...
	write-host "Entering Maintenance Mode"
	Set-VMHost -State maintenance
 
# Configure vSwitch0
	write-host "Configuring vSwitch0"
	$vs0 = Get-VirtualSwitch -Name vSwitch0
	Set-VirtualSwitch -VirtualSwitch $vs0 -Nic $esxnics
	New-VMHostNetworkAdapter  -PortGroup VMkernel -VirtualSwitch $vs0 -IP $VMotionIP -SubnetMask $VMotionSubnet -VMotionEnabled: $true
 
# Removes "VM Network" from the vSwitch0
	get-VirtualPortGroup  | where { $_.Name -like "VM Network"} |  Remove-VirtualPortGroup  -Confirm:$false
 
# Configure vSwitch1
	write-host "Configuring vSwitch1"
	$vs1 = New-VirtualSwitch -Name vSwitch1 -nic $vmnics
	write-host "Configuring " $vSwitch1Name
	New-VirtualPortGroup -VirtualSwitch $vs1 -Name $vSwitch1Name -VLanId $vSwitch1VLAN
	if ("0" -ne $vSwitch1VLAN){
		if ("0" -ne $vSwitch1Name2){
			write-host "Configuring " $vSwitch1Name2
			New-VirtualPortGroup -VirtualSwitch $vs1 -Name $vSwitch1Name2 -VLanId $vSwitch1VLAN2
		}
	}
 
# Configure vSwitch Security for all vSwitches
	write-host "Configuring vSwitch Security settings and enabling Beacon Probing for all vSwitches"
	foreach ($vswitchName in Get-VirtualSwitch $vmhost){
		$hostview = get-vmhost $vmhost | Get-View
		$ns = Get-View -Id $hostview.ConfigManager.NetworkSystem
		$vsConfig = $hostview.Config.Network.Vswitch | Where-Object { $_.Name -eq $vswitchName }
		$vsSpec = $vsConfig.Spec
		$vsSpec.Policy.NicTeaming.FailureCriteria.checkBeacon = $true
		$vsSpec.Policy.Security.AllowPromiscuous = $False
		$vsSpec.Policy.Security.forgedTransmits = $False
		$vsSpec.Policy.Security.macChanges = $False
		$ns.UpdateVirtualSwitch( $VSwitchName, $vsSpec)
	}
 
# Set-up the NTP Configuration
	write-host "Adding NTP Servers"
	Add-VmHostNtpServer -NtpServer $ntp1,$ntp2
 
# Set DNS Details to ensure they have been set
	write-host "Resetting DNS Details"
	$vmHostNetworkInfo = Get-VmHostNetwork -VMHost $vmhost
	Set-VmHostNetwork -Network $vmHostNetworkInfo -DomainName $DomainName -SearchDomain $DNSSearch
	Set-VmHostNetwork -Network $vmHostNetworkInfo -DnsAddress $PreferredDNS, $AltDNS
 
# Rename Local Datastore
	$LocalName = $vmhost.ToUpper()
	Get-Datastore -Name "datastore1" | Set-Datastore -Name $LocalName"-LOCAL"
 
# Create Local Accounts
	write-host "Configuring local ESXi account for " $vmadminaccount
	New-VMHostAccount -Group $vmadminaccount
  	New-VMHostAccount -User -Id $vmadminaccount -Password $vmadminpassword -Description "VMware Local ESXi Administrator" -AssignGroups $vmadminaccount
  	$sgAuthMgr = Get-View (Get-View ServiceInstance).Content.AuthorizationManager
  	$sgEntity = Get-Folder ha-folder-root | Get-View
  	$sgPerm = New-Object VMware.Vim.Permission
  	$sgPerm.entity = $sgEntity.MoRef
  	$sgPerm.group = $true
  	$sgPerm.principal = $vmadminaccount
  	$sgPerm.propagate = $true
  	$sgPerm.roleId = ($sgAuthMgr.RoleList | where {$_.Name -eq "Admin"}).RoleId
  	$sgAuthMgr.SetEntityPermissions($sgEntity.MoRef,$sgPerm)
 
	write-host "Configuring local ESXi account for " $vmopsaccount
	New-VMHostAccount -Group $vmopsaccount
  	New-VMHostAccount -User -Id $vmopsaccount -Password $vmopspassword -Description "VMware Local ESXi Operations Administrator" -AssignGroups $vmopsaccount
  	$sgAuthMgr = Get-View (Get-View ServiceInstance).Content.AuthorizationManager
  	$sgEntity = Get-Folder ha-folder-root | Get-View
  	$sgPerm = New-Object VMware.Vim.Permission
  	$sgPerm.entity = $sgEntity.MoRef
  	$sgPerm.group = $true
  	$sgPerm.principal = $vmopsaccount
  	$sgPerm.propagate = $true
  	$sgPerm.roleId = ($sgAuthMgr.RoleList | where {$_.Name -eq "Admin"}).RoleId
  	$sgAuthMgr.SetEntityPermissions($sgEntity.MoRef,$sgPerm)
 
# Create Account for EMC ECC Control Centre
 
	write-host "Configuring account for EMC ECC ControlCenter"
  	$sgRole = New-VIRole -Name ControlCenter -Privilege ( Get-VIPrivilege -PrivilegeItem "Browse datastore" )
  	New-VMHostAccount -Group ControlCenter
  	New-VMHostAccount -User -Id eccuser -Password $eccuserpassword -Description "EMC ControlCenter discovery" -AssignGroups "ControlCenter"
  	$sgAuthMgr = Get-View (Get-View ServiceInstance).Content.AuthorizationManager
  	$sgEntity = Get-Folder ha-folder-root | Get-View
  	$sgPerm = New-Object VMware.Vim.Permission
  	$sgPerm.entity = $sgEntity.MoRef
  	$sgPerm.group = $true
  	$sgPerm.principal = "ControlCenter"
  	$sgPerm.propagate = $true
  	$sgPerm.roleId = ($sgAuthMgr.RoleList | where {$_.Name -eq "ControlCenter"}).RoleId
  	$sgAuthMgr.SetEntityPermissions($sgEntity.MoRef,$sgPerm)
 
# Patch ESXi Host
	write-host "Patching ESXi Host"
	Install-VMHostPatch -VMhost $vmhost -HostUsername root -HostPassword $HostPassword -WebPath $patchURL/patch/ESXi400-201002001/metadata.zip
	Install-VMHostPatch -VMhost $vmhost -HostUsername root -HostPassword $HostPassword -WebPath $patchURL/patch/BCM-bnx2x-1.52.12.v40.3-offline_bundle-223054/metadata.zip
	Install-VMHostPatch -VMhost $vmhost -HostUsername root -HostPassword $HostPassword -WebPath $patchURL/patch/hp-esxi4.0uX-bundle-1.2/metadata.zip
 
# Restart the ESXi Host
	write-host "Rebooting ESXi Host"
	Restart-VMHost -server $vmhost -confirm:$false
 
# Disconnect from ESXi Host
	Disconnect-VIServer -Confirm:$False
 
# Provide Post config Instructions
	write-host "The basic ESXi Host configuration is completed, please:"
	write-host "1. Wait for the host to reboot."
	write-host "2. Connect the Host to vCenter and assign a license"
	write-host "3. Verify the Host Configuration is correct"
	write-host "4. Confirm all patches have been applied (scan for updates)"
	Write-Host "5. Once complete take the ESXi host out of Maintenance Mode"