PowerShell

document your SCOM 2012 environment

Burkard Josh 11. April 2014

This is quite huge for me, because I’ve been working on this script for the last two months and finally decided, to release the script to public, although I know that it’s still far from complete.

Document your Operations Manager 2012 environment

You should know your environment and what happens in it and you should be able to show people what exactly has been configured in your environment. This is quite important for consultants, but also for admins. Consultants need to create a documentation after implementing Operations Manager 2012 at a costumer’s site and admins should be able to know how their environment looks like at any given time. read more

recover deleted Bitlocker Recovery Informations

Burkard Josh 17. July 2013 0

Today I had a request from a first-level-admin which need the Bitlocker Recovery Password for a already deleted computer object. Here is what I came up with:

$compname = "ComputerName"
$SearchRoot = "CN=Deleted Objects,DC=domain,DC=local"

$recoverykeys = Get-QADObject -Tombstone -Recycled -Type "msFVE-RecoveryInformation" -SizeLimit 0 -Includedproperties msFVE-RecoveryPassword -SearchRoot $SearchRoot | ? {$_.lastknownparent -like "*$compname*"} | select msFVE-RecoveryPassword

$recoverykeys

$compname = "ComputerName"

$SearchRoot = "CN=Deleted Objects,DC=domain,DC=local"

$recoverykeys = Get-QADObject -Tombstone -Recycled -Type "msFVE-RecoveryInformation" -SizeLimit 0 -Includedproperties msFVE-RecoveryPassword -SearchRoot $SearchRoot | ? {$_.lastknownparent -like "*$compname*"} | select msFVE-RecoveryPassword

$recoverykeys

Please note that you need to be a Domain Admin (or equivalent) to be able to read the Deleted Objects Container. The tombstones will have a lifetime, after their expiration, you can’t access anymore to the recovery passwords.

List VMTools Status with vCheck

Burkard Josh 25. February 2013 0

i like vCheck to daily report my virtual environment status. But a lot of our guest systems are not in my responsibility, so the VM Tools are not uptodate or aren’t installed.

i wroted this plugin for vCheck:

$Title = "VMs by VM Tools status"
$Header = "VMs by VM Tools status : $($VMToolsVersions.count)"
$Comments = "The following Operating Systems are in use in this vCenter."
$Display = "Table"
$Author = "Josh Burkard"
$Version = 1.0

# Start of Settings
# —- VM Guest OS Pivot Table —-

$VMTools = get-vm | % { get-view $_.ID } | select Name, @{ Name="hostName"; Expression={$_.guest.hostName}}, @{ Name="ToolsStatus"; Expression={$_.guest.toolsstatus}}, @{ Name="ToolsVersion"; Expression={$_.config.tools.toolsVersion}} | sort-object ToolsVersion

$VMToolsVersions = $VMTools | Where { $_.ToolsStatus -ne "toolsOk" } | sort ToolsVersion -desc

If (($VMToolsVersions | Measure-Object).count -gt 0 -or $ShowAllHeaders) 
{
	$MyReport += Get-CustomHeader "VMs by VM Tools status : $($VMToolsVersions.count)" "The following VM Tools Status are not OK or old."
	$MyReport += Get-HTMLTable $VMToolsVersions
	$MyReport += Get-CustomHeaderClose
}

$Title = "VMs by VM Tools status"

$Header = "VMs by VM Tools status : $($VMToolsVersions.count)"

$Comments = "The following Operating Systems are in use in this vCenter."

$Display = "Table"

$Author = "Josh Burkard"

$Version = 1.0

# Start of Settings

# —- VM Guest OS Pivot Table —-

$VMTools = get-vm | % { get-view $_.ID } | select Name, @{ Name="hostName"; Expression={$_.guest.hostName}}, @{ Name="ToolsStatus"; Expression={$_.guest.toolsstatus}}, @{ Name="ToolsVersion"; Expression={$_.config.tools.toolsVersion}} | sort-object ToolsVersion

$VMToolsVersions = $VMTools | Where { $_.ToolsStatus -ne "toolsOk" } | sort ToolsVersion -desc

If (($VMToolsVersions | Measure-Object).count -gt 0 -or $ShowAllHeaders)

{

$MyReport += Get-CustomHeader "VMs by VM Tools status : $($VMToolsVersions.count)" "The following VM Tools Status are not OK or old."

$MyReport += Get-HTMLTable $VMToolsVersions

$MyReport += Get-CustomHeaderClose

}

discover informations about all virtual machines to Excel

Burkard Josh 29. December 2011 0

I had the task to list all existing virtual machines in our vSphere vCenter to an Excel-List. Cause i have alot of VM’s and they change often, i wrote a powershell-script, which creates an excel-file like this:

The requirements for this script are Microsoft Excel and VMware PowerCLI 5. Look at the script or download it here:

# ===========================================================================================
#
#  Script Information
#
#  Title:              create-vmOverview.ps1
#  Author:             Josh Burkard
#  Date:               29.12.2011
#
#  Requirements:       - Windows Powershell
#                      - vmWare PowerCLI V5
#                      - Microsoft Excel
#
#  Usage:              .\create-vmOverview.ps1
#
#  Description:        Get Informations from all existing VM's in a vCenter and writes it
#                      to an Excel-File
#
#===========================================================================================

# VARIABLES
$VCServer = "vCenter Name or IP-Address"    # Virtual Center Server

$outputFile = "D:\VMDiskOverview_" + $VCServer + ".xlsx"   # Output file path

$xlConstants = "microsoft.office.interop.excel.Constants" -as [type]

# SCRIPT

# Add the VI-Snapin if it isn't loaded already
if ((Get-PSSnapin -Name "VMware.VimAutomation.Core" -ErrorAction SilentlyContinue) -eq $null )
{
	Add-PSSnapin -Name "VMware.VimAutomation.Core"
}

[threading.thread]::CurrentThread.CurrentCulture = 'en-US'
$objExcel = New-Object -ComObject Excel.Application
$objExcel.Visible = $False
$WorkBook = $objExcel.Workbooks.Add()
$WorkSheet = $WorkBook.Worksheets.Item(1)
$WorkSheet.Cells.Item(1, 1) = "DataCenter:"
$WorkSheet.Cells.Item(1, 2) = "VM:"
$WorkSheet.Cells.Item(1, 3) = "Description:"
$WorkSheet.Cells.Item(1, 4) = "Disk:"
$WorkSheet.Cells.Item(1, 5) = "DiskType:"
$WorkSheet.Cells.Item(1, 6) = "DataStore:"
$WorkSheet.Cells.Item(1, 7) = "DSFolder:"
$WorkSheet.Cells.Item(1, 8) = "CapacyityGB:"
$WorkSheet.Cells.Item(1, 9) = "vCPU:"
$WorkSheet.Cells.Item(1,10) = "vRAM:"

$intRow = 2

Clear
$VC = Connect-VIServer $VCServer    # Connect to Virtual Center
$myCol = @()    # Prepare output collection
$VMs = Get-VM | Sort Name    # Get all VMs (sorted)
$counter = 0    # Initialize counter for progress bar
ForEach ($Datacenter in Get-DataCenter)
{
	ForEach ($VM in Get-DataCenter $DataCenter | Get-VM | Sort Name)    # Loop through VMs
	{
		$counter++    # Increase counter for progress bar
		Write-Progress -Activity "Gathering disk information" -Status "Processing VM $VM" -PercentComplete (100*($counter/$VMs.count))    # Display progress bar
		$VMHost = Get-VMHost -VM $VM    # Get this VM's host
		$VMHostView = $VMHost | Get-View    # Get advanced properties of host

		$WorkSheet.Cells.Item($intRow, 1) = $DataCenter.Name    							# DataCenter Name
		$WorkSheet.Cells.Item($intRow, 2) = $VM.Name    									# Virtual Machine Name
		$WorkSheet.Cells.Item($intRow, 3) = $VM.Notes     									# Virtual Machine Description
		$WorkSheet.Cells.Item($intRow, 9) = $VM.NumCpu										# NumCpu
		$WorkSheet.Cells.Item($intRow,10) = $VM.MemoryMB									# MemoryMB

		$intDisks = 0
		ForEach ($DISK in Get-Harddisk -VM $VM)    # Loop through VM's harddisks
		{
			$WorkSheet.Cells.Item($intRow + $intDisks, 4) = $DISK.Name    										# Virtual Disk Name
			$WorkSheet.Cells.Item($intRow + $intDisks, 5) = ""+$DISK.DiskType
			If ($DISK.DiskType -eq "RawPhysical")
			{
				$Lun = Get-SCSILun $DISK.SCSICanonicalName -VMHost (Get-VM $VM).VMHost
				$WorkSheet.Cells.Item($intRow + $intDisks, 6) = $Lun.CanonicalName	    						# Datastore Name
				$WorkSheet.Cells.Item($intRow + $intDisks, 7) = ""
			} else {
				$DataStoreName = $DISK.Filename.Split("[]")[1]
				$WorkSheet.Cells.Item($intRow + $intDisks, 6) = $DataStoreName									# Datastore Name
				$DS = Get-Datastore -Name $DataStoreName
				If ($DS.ParentFolder.Name -eq "datastore")
				{
					$WorkSheet.Cells.Item($intRow + $intDisks, 7) = ""											# DSFolder
				} else {
					$WorkSheet.Cells.Item($intRow + $intDisks, 7) = $DS.ParentFolder.Name						# DSFolder
				}
			}
			$WorkSheet.Cells.Item($intRow + $intDisks, 8) = $DISK.CapacityKB / 1024 / 1024						# CapacityKB

			Clear-Variable DISK -ErrorAction SilentlyContinue

			$intDisks = $intDisks + 1
		}
		if ($intDisks -gt 1)
		{
			$intLastRow = $intRow + $intDisks - 1
			$MergeCells = $WorkSheet.Range("A" + $intRow + ":A" + $intLastRow)
			$MergeCells.Merge()

			$MergeCells = $WorkSheet.Range("B" + $intRow + ":B" + $intLastRow)
			$MergeCells.Merge()

			$MergeCells = $WorkSheet.Range("C" + $intRow + ":C" + $intLastRow)
			$MergeCells.Merge()

			$MergeCells = $WorkSheet.Range("I" + $intRow + ":I" + $intLastRow)
			$MergeCells.Merge()

			$MergeCells = $WorkSheet.Range("J" + $intRow + ":J" + $intLastRow)
			$MergeCells.Merge()
		}
		$intRow = $intRow + $intDisks
	}
}

$WorkSheet.Range("A1:J1").Font.Bold = $true
$WorkSheet.Range("A1:G" + $intRow).HorizontalAlignment = $xlConstants::xlLeft
$WorkSheet.Range("A1:J" + $intRow).VerticalAlignment = $xlConstants::xlTop
$WorkSheet.Range("H2:H" + $intRow).Numberformat="0.00"
$WorkSheet.application.activewindow.splitcolumn = 2
$WorkSheet.application.activewindow.splitrow = 1
$WorkSheet.application.activewindow.freezepanes = $true

$Range = $WorkSheet.Range("A1:J1")
$Range.EntireColumn.AutoFit() | Out-Null
$WorkBook.SaveAs($outputFile)
$objExcel.Workbooks.close()
$objExcel.Quit()

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

# ===========================================================================================

# Script Information

# Title: create-vmOverview.ps1

# Author: Josh Burkard

# Date: 29.12.2011

# Requirements: - Windows Powershell

# - vmWare PowerCLI V5

# - Microsoft Excel

# Usage: .\create-vmOverview.ps1

# Description: Get Informations from all existing VM's in a vCenter and writes it

# to an Excel-File

#===========================================================================================

# VARIABLES

$VCServer = "vCenter Name or IP-Address" # Virtual Center Server

$outputFile = "D:\VMDiskOverview_" + $VCServer + ".xlsx" # Output file path

$xlConstants = "microsoft.office.interop.excel.Constants" -as [type]

# SCRIPT

# Add the VI-Snapin if it isn't loaded already

if ((Get-PSSnapin -Name "VMware.VimAutomation.Core" -ErrorAction SilentlyContinue) -eq $null )

{

Add-PSSnapin -Name "VMware.VimAutomation.Core"

}

[threading.thread]::CurrentThread.CurrentCulture = 'en-US'

$objExcel = New-Object -ComObject Excel.Application

$objExcel.Visible = $False

$WorkBook = $objExcel.Workbooks.Add()

$WorkSheet = $WorkBook.Worksheets.Item(1)

$WorkSheet.Cells.Item(1, 1) = "DataCenter:"

$WorkSheet.Cells.Item(1, 2) = "VM:"

$WorkSheet.Cells.Item(1, 3) = "Description:"

$WorkSheet.Cells.Item(1, 4) = "Disk:"

$WorkSheet.Cells.Item(1, 5) = "DiskType:"

$WorkSheet.Cells.Item(1, 6) = "DataStore:"

$WorkSheet.Cells.Item(1, 7) = "DSFolder:"

$WorkSheet.Cells.Item(1, 8) = "CapacyityGB:"

$WorkSheet.Cells.Item(1, 9) = "vCPU:"

$WorkSheet.Cells.Item(1,10) = "vRAM:"

$intRow = 2

Clear

$VC = Connect-VIServer $VCServer # Connect to Virtual Center

$myCol = @() # Prepare output collection

$VMs = Get-VM | Sort Name # Get all VMs (sorted)

$counter = 0 # Initialize counter for progress bar

ForEach ($Datacenter in Get-DataCenter)

{

ForEach ($VM in Get-DataCenter $DataCenter | Get-VM | Sort Name) # Loop through VMs

{

$counter++ # Increase counter for progress bar

Write-Progress -Activity "Gathering disk information" -Status "Processing VM $VM" -PercentComplete (100*($counter/$VMs.count)) # Display progress bar

$VMHost = Get-VMHost -VM $VM # Get this VM's host

$VMHostView = $VMHost | Get-View # Get advanced properties of host

$WorkSheet.Cells.Item($intRow, 1) = $DataCenter.Name # DataCenter Name

$WorkSheet.Cells.Item($intRow, 2) = $VM.Name # Virtual Machine Name

$WorkSheet.Cells.Item($intRow, 3) = $VM.Notes # Virtual Machine Description

$WorkSheet.Cells.Item($intRow, 9) = $VM.NumCpu # NumCpu

$WorkSheet.Cells.Item($intRow,10) = $VM.MemoryMB # MemoryMB

$intDisks = 0

ForEach ($DISK in Get-Harddisk -VM $VM) # Loop through VM's harddisks

{

$WorkSheet.Cells.Item($intRow + $intDisks, 4) = $DISK.Name # Virtual Disk Name

$WorkSheet.Cells.Item($intRow + $intDisks, 5) = ""+$DISK.DiskType

If ($DISK.DiskType -eq "RawPhysical")

{

$Lun = Get-SCSILun $DISK.SCSICanonicalName -VMHost (Get-VM $VM).VMHost

$WorkSheet.Cells.Item($intRow + $intDisks, 6) = $Lun.CanonicalName # Datastore Name

$WorkSheet.Cells.Item($intRow + $intDisks, 7) = ""

} else {

$DataStoreName = $DISK.Filename.Split("[]")[1]

$WorkSheet.Cells.Item($intRow + $intDisks, 6) = $DataStoreName # Datastore Name

$DS = Get-Datastore -Name $DataStoreName

If ($DS.ParentFolder.Name -eq "datastore")

{

$WorkSheet.Cells.Item($intRow + $intDisks, 7) = "" # DSFolder

} else {

$WorkSheet.Cells.Item($intRow + $intDisks, 7) = $DS.ParentFolder.Name # DSFolder

}

$WorkSheet.Cells.Item($intRow + $intDisks, 8) = $DISK.CapacityKB / 1024 / 1024 # CapacityKB

Clear-Variable DISK -ErrorAction SilentlyContinue

$intDisks = $intDisks + 1

}

if ($intDisks -gt 1)

{

$intLastRow = $intRow + $intDisks - 1

$MergeCells = $WorkSheet.Range("A" + $intRow + ":A" + $intLastRow)

$MergeCells.Merge()

$MergeCells = $WorkSheet.Range("B" + $intRow + ":B" + $intLastRow)

$MergeCells.Merge()

$MergeCells = $WorkSheet.Range("C" + $intRow + ":C" + $intLastRow)

$MergeCells.Merge()

$MergeCells = $WorkSheet.Range("I" + $intRow + ":I" + $intLastRow)

$MergeCells.Merge()

$MergeCells = $WorkSheet.Range("J" + $intRow + ":J" + $intLastRow)

$MergeCells.Merge()

}

$intRow = $intRow + $intDisks

}

$WorkSheet.Range("A1:J1").Font.Bold = $true

$WorkSheet.Range("A1:G" + $intRow).HorizontalAlignment = $xlConstants::xlLeft

$WorkSheet.Range("A1:J" + $intRow).VerticalAlignment = $xlConstants::xlTop

$WorkSheet.Range("H2:H" + $intRow).Numberformat="0.00"

$WorkSheet.application.activewindow.splitcolumn = 2

$WorkSheet.application.activewindow.splitrow = 1

$WorkSheet.application.activewindow.freezepanes = $true

$Range = $WorkSheet.Range("A1:J1")

$Range.EntireColumn.AutoFit() | Out-Null

$WorkBook.SaveAs($outputFile)

$objExcel.Workbooks.close()

$objExcel.Quit()

Shutdown full VMware datacenter on UPS failure

Burkard Josh 11. July 2011 0

To shutdown a VMware datacenter on UPS failure i found a PowerShell script, which i modified:

The script will shutdown the desired VMware datacenter, but it will ask you first, if you are sure. If you like to run the script in silent mode, you can run it with parameter yes.

You have to define the hostname of your VirtualCenter and the name of the datacenter. To run the script, you will need, to have VMware PowerCLI installed.

You can dowload the script shutdownESX.ps1 (right-click -> Save As) or copy/paste it from here:

# ===========================================================================================
#
#  Script Information
#
#  Title:              shutdownESX.ps1
#  Author:             Josh Burkard
#  Date:               11.07.2011
#  Requirements:       Windows Powershell and the VI Toolkit
#  Usage:              .\shutdownESX.ps1
#                      .\shutdownESX.ps1 yes   --&gt;   shutdown the datacenter
#					                                 without any question
#
#  Description:        - Shutdown the defined VMware Datacenter
#                      - you have to set this variables:
#                          - VirtualCenter
#                          - DataCenter
#
#  The script will not run well, if the VirtualCenter server is running as VM in the same
#  data center.
#
#  I’m sure I don’t need to tell you that you need to be extremely careful when testing
#  this script as one false move could shut down everything !
#  Please test this to make sure it works first !
#
#===========================================================================================

$VirtualCenter = "HostName of VirtualCenter"
$DataCenter    = "Test"

# Add the VI-Snapin if it isn't loaded already
if ((Get-PSSnapin -Name "VMware.VimAutomation.Core" -ErrorAction SilentlyContinue) -eq $null )
{
	Add-PSSnapin -Name "VMware.VimAutomation.Core"
}

Connect-VIServer $VirtualCenter
clear
if ($args[0] -ne "yes")
{
	Write-Host "Connected to " $VirtualCenter
	Write-Host
	Write-Host "==============================================================================="
	Write-Host "===                                                                         ==="
	Write-Host "===       WARNING!     WARNING!     WARNING!     WARNING!     WARNING!      ==="
	Write-Host "===                                                                         ==="
	Write-Host "==============================================================================="
	Write-Host
	Write-Host "  This script is designed to power off all virtual machines and the ESX host."
	Write-Host
	Write-Host
	$input = Read-Host "  TYPE 'YES' TO CONTINUE THIS SCRIPT AND SHUTDOWN ESX HOSTS NOW."
	if ($input -ne "yes")
	{
		Write-Host
		Write-Host "==============================================================================="
		Write-Host "===               THE SHUTDOWN PROCESS HAS BEEN CANCELLED.                  ==="
		Write-Host "==============================================================================="
		exit
	}
}
Write-Host
Write-Host "==============================================================================="
Write-Host "===                    THE SHUTDOWN PROCESS WILL RESUME.                    ==="
Write-Host "==============================================================================="

# Get All the ESX Hosts for the desired DataCenter
$ESXSRV = Get-DataCenter "Test" | Get-VMHost
Write ""
Write "available VM's:"
Write "==============="

# For each of the VMs on the DataCenter hosts
Foreach ($VM in ($ESXSRV | Get-VM))
{
    # Shutdown the guest cleanly
    If ($VM.Name -ne $VC)
    {
		$VMName = $VM.Name
		$VMState = $VM.PowerState
		Write "$VMName : $VMState"
		if ($VM.PowerState -eq "poweredOn")
		{
			$VM | Shutdown-VMGuest -Confirm:$false
		}
    }
}

# Set the amount of time to wait before assuming the remaining powered on guests are stuck
$waittime = 200 #Seconds

# Wait for the VMs to be Shutdown cleanly
$vms = Get-DataCenter $DataCenter | Get-VM
$numvms = ($vms.count - ($vms | where {$_.PowerState -eq "PoweredOff"}).Count)
Write-Host "Powered on VM's: $numvms "

$Time = (Get-Date).TimeofDay
do
{
	sleep 1.0
	$timeleft = $waittime - ($Newtime.seconds)
	$vms = Get-DataCenter $DataCenter | Get-VM
	$numvms = ($vms.count - ($vms | where {$_.PowerState -eq "PoweredOff"}).Count)
	Write-Host "Waiting for shutdown of $numvms VMs or until $timeleft seconds"
	$Newtime = (Get-Date).TimeofDay - $Time
} until ($numvms -eq 0 -or ($Newtime).Seconds -ge $waittime)

# Force VMs off
Foreach ($VM in ($ESXSRV | Get-VM | Where { $_.PowerState -ne “poweredOff” } ))
{
	$VM | Stop-VM -Confirm:$false | Out-Null
	Write-Host
	Write-Host $VM "has been forced to powering Off"
}

# Place ESX hosts in Maintenance Mode
$ESXSRV | Set-VMHost -State Maintenance | Out-Null
Write-Host
Write-Host "DataCenter" $DataCenter " is in Maintenance Mode"

# Shutdown the ESX Hosts
$ESXSRV | Foreach {Get-View $_.ID} | Foreach {$_.ShutdownHost_Task($TRUE)} | Out-Null
Write-Host
Write-Host "==============================================================================="
Write-Host "===                  THE SHUTDOWN PROCESS HAS COMPLETED.                    ==="
Write-Host "==============================================================================="

# Disconnect from the ESX Server
Write-Host
Disconnect-VIServer -Server $VirtualCenter -Confirm:$False
Write-Host "Disconnected from " $VirtualCenter

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

# ===========================================================================================

# Script Information

# Title: shutdownESX.ps1

# Author: Josh Burkard

# Date: 11.07.2011

# Requirements: Windows Powershell and the VI Toolkit

# Usage: .\shutdownESX.ps1

# .\shutdownESX.ps1 yes --> shutdown the datacenter

# without any question

# Description: - Shutdown the defined VMware Datacenter

# - you have to set this variables:

# - VirtualCenter

# - DataCenter

# The script will not run well, if the VirtualCenter server is running as VM in the same

# data center.

# I’m sure I don’t need to tell you that you need to be extremely careful when testing

# this script as one false move could shut down everything !

# Please test this to make sure it works first !

#===========================================================================================

$VirtualCenter = "HostName of VirtualCenter"

$DataCenter = "Test"

# Add the VI-Snapin if it isn't loaded already

if ((Get-PSSnapin -Name "VMware.VimAutomation.Core" -ErrorAction SilentlyContinue) -eq $null )

{

Add-PSSnapin -Name "VMware.VimAutomation.Core"

}

Connect-VIServer $VirtualCenter

clear

if ($args[0] -ne "yes")

{

Write-Host "Connected to " $VirtualCenter

Write-Host

Write-Host "==============================================================================="

Write-Host "=== ==="

Write-Host "=== WARNING! WARNING! WARNING! WARNING! WARNING! ==="

Write-Host "=== ==="

Write-Host "==============================================================================="

Write-Host

Write-Host " This script is designed to power off all virtual machines and the ESX host."

Write-Host

$input = Read-Host " TYPE 'YES' TO CONTINUE THIS SCRIPT AND SHUTDOWN ESX HOSTS NOW."

if ($input -ne "yes")

{

Write-Host

Write-Host "==============================================================================="

Write-Host "=== THE SHUTDOWN PROCESS HAS BEEN CANCELLED. ==="

Write-Host "==============================================================================="

exit

}

Write-Host

Write-Host "==============================================================================="

Write-Host "=== THE SHUTDOWN PROCESS WILL RESUME. ==="

Write-Host "==============================================================================="

# Get All the ESX Hosts for the desired DataCenter

$ESXSRV = Get-DataCenter "Test" | Get-VMHost

Write ""

Write "available VM's:"

Write "==============="

# For each of the VMs on the DataCenter hosts

Foreach ($VM in ($ESXSRV | Get-VM))

{

# Shutdown the guest cleanly

If ($VM.Name -ne $VC)

{

$VMName = $VM.Name

$VMState = $VM.PowerState

Write "$VMName : $VMState"

if ($VM.PowerState -eq "poweredOn")

{

$VM | Shutdown-VMGuest -Confirm:$false

}

# Set the amount of time to wait before assuming the remaining powered on guests are stuck

$waittime = 200 #Seconds

# Wait for the VMs to be Shutdown cleanly

$vms = Get-DataCenter $DataCenter | Get-VM

$numvms = ($vms.count - ($vms | where {$_.PowerState -eq "PoweredOff"}).Count)

Write-Host "Powered on VM's: $numvms "

$Time = (Get-Date).TimeofDay

{

sleep 1.0

$timeleft = $waittime - ($Newtime.seconds)

$vms = Get-DataCenter $DataCenter | Get-VM

$numvms = ($vms.count - ($vms | where {$_.PowerState -eq "PoweredOff"}).Count)

Write-Host "Waiting for shutdown of $numvms VMs or until $timeleft seconds"

$Newtime = (Get-Date).TimeofDay - $Time

} until ($numvms -eq 0 -or ($Newtime).Seconds -ge $waittime)

# Force VMs off

Foreach ($VM in ($ESXSRV | Get-VM | Where { $_.PowerState -ne “poweredOff” } ))

{

$VM | Stop-VM -Confirm:$false | Out-Null

Write-Host

Write-Host $VM "has been forced to powering Off"

}

# Place ESX hosts in Maintenance Mode

$ESXSRV | Set-VMHost -State Maintenance | Out-Null

Write-Host

Write-Host "DataCenter" $DataCenter " is in Maintenance Mode"

# Shutdown the ESX Hosts

$ESXSRV | Foreach {Get-View $_.ID} | Foreach {$_.ShutdownHost_Task($TRUE)} | Out-Null

Write-Host

Write-Host "==============================================================================="

Write-Host "=== THE SHUTDOWN PROCESS HAS COMPLETED. ==="

Write-Host "==============================================================================="

# Disconnect from the ESX Server

Write-Host

Disconnect-VIServer -Server $VirtualCenter -Confirm:$False

Write-Host "Disconnected from " $VirtualCenter

Josh's IT-Blog

Information Technology, and other interesting things ...

PowerShell

document your SCOM 2012 environment

Document your Operations Manager 2012 environment

recover deleted Bitlocker Recovery Informations

List VMTools Status with vCheck

discover informations about all virtual machines to Excel

Shutdown full VMware datacenter on UPS failure

PowerShell

Document your Operations Manager 2012 environment

Share this:

Share this:

Share this:

Share this:

Share this: