Powershell

In the last article I showed you the code to export the settings. In this one I show you the code to import them into the server. I am assuming that the hostname, login and password are remaining. You are just moving the servers from one virtual center server to another.

if ((Get-PSSnapin -Name VMware.VimAutomation.Core -ErrorAction SilentlyContinue) -eq $null )
{Add-PSsnapin VMware.VimAutomation.Core -ErrorAction SilentlyContinue}
Set-PowerCLIConfiguration -DefaultVIServerMode Multiple -Confirm:$false
$sourceVI = Read-Host "Please enter the name of the source Server";
$creds = get-credential
$datacenter = Read-Host "Please give the name of the datacenter you would like to run against"
connect-viserver -server $sourceVI -credential $creds
import-csv "R:\Reports\Datacenter-exports\dpm-settings-$datacenter.csv" | %{
$hostview = get-vmhost $_.Name | % {Get-View $_.Id}
$IpmiInfo = New-Object Vmware.Vim.HostIpmiInfo
$IpmiInfo.BmcIpAddress = $_.BmcIpAddress
$IpmiInfo.BmcMacAddress = $_.BmcMacAddress
$IpmiInfo.Login = $_.Login
$IpmiInfo.Password = $_.password
$hostview.UpdateIpmi($IpmiInfo)}
Disconnect-VIServer -Server $SourceVI -Force -confirm:$false

Filed under Powershell, vSphere 4

Exporting DPM Settings

January 5, 2011 Leave a Comment

I recently was tasked to move several datacenters to balance the overall load on our virtual center servers. One of the things I had to do was to export the existing host settings for Distributed Power Management (DPM). I wrote the following script to export the settings to a CSV file.

if ((Get-PSSnapin -Name VMware.VimAutomation.Core -ErrorAction SilentlyContinue) -eq $null )
{Add-PSsnapin VMware.VimAutomation.Core -ErrorAction SilentlyContinue}
#Change to multi-mode vcenter management
Set-PowerCLIConfiguration -DefaultVIServerMode Multiple -Confirm:$false
#Get vCenter Server Names
$sourceVI = Read-Host "Please enter the name of the source Server";
$creds = get-credential
$datacenter = Read-Host "Please give the name of the datacenter you would like to run against"
#Connect to Source vCenter
connect-viserver -server $sourceVI -credential $creds
Function Get-IpmiInfo {
Begin {
# This hides the errors which appear if the VM Tools are not running
$ErrorActionPreference = "SilentlyContinue"
$Name = @{
Name    = "Name"
Expr     = { $_.name }
}
$BmcIpAddress = @{
Name    = "BmcIpAddress"
Expr     = { $_.config.ipmi.BmcIpAddress }
}
$BmcMacAddress = @{
Name    = "BmcMacAddress"
Expr     = { $_.config.ipmi.BmcMacAddress }
}
$Login = @{
Name    = "Login"
Expr     = { $_.config.ipmi.Login }
}
$Password = @{
Name    = "Password"
Expr     = { $_.config.ipmi.Password }
}
}
Process {
if ( $_.GetType().Name -ne 'VirtualMachineImpl' ) {
Throw "This script expects a VirtualMachineImpl object as input."
}
$_ | Select-Object $name, $BmcIpAddress, $BmcMacAddress, $Login, $Password
}
}
$report = @()
Get-datacenter $datacenter | get-vmhost | get-view | Get-IpmiInfo | export-csv "c:\temp\dpm-settings-$datacenter.csv" -notypeinformation
Disconnect-VIServer -Server $SourceVI -Force -confirm:$false

Filed under Powershell, vSphere 4

VM Compare AD Group Script

July 19, 2010 Leave a Comment

If you apply GPO’s to servers for ease of administration and security, you may want an easy way if all your servers are in the appropriate group(in this case “Virtual Servers”) and compare this list to a list of all running Windows machines. The following script will do this:

########################################################################
# Title:	VM Groupmembership Script
# Filename:	vmgroup.ps1
# Created by:	Douglas Smith
# Date:		7/14/2010
# Version:	0.1
# Description:		*This script requires the Quest AD cmdlets be installed.*
########################################################################
#### Pass through paramaeters ###################################################
param (
[string]$vcserver,
)
#### Variables ##############################################################
$Date = Get-Date
#### Functions ##############################################################
#### Begin Script ############################################################
#### Validate Input Variables ####################################################
If ($vcserver -eq "") {
$wscript = new-object -comobject wscript.shell
$msgbox = $wscript.popup("You MUST enter the name or IP of your vSphere server",0,"Access Denied",1)
exit
}
#### Check if Snapin loaded, if not load #############################################
if ((Get-PSSnapin -Name VMware.VimAutomation.Core -ErrorAction SilentlyContinue) -eq $null )
{Add-PSsnapin VMware.VimAutomation.Core -ErrorAction SilentlyContinue}
if ((Get-PSSnapin -Name Quest.ActiveRoles.ADManagement -ErrorAction SilentlyContinue) -eq $null )
{Add-PSsnapin Quest.ActiveRoles.ADManagement -ErrorAction SilentlyContinue}
#### Connect to vSphere
$VIServer = connect-VIServer $vcserver
$adlist = get-qadgroupmember "Virtual Servers" -type computer | Select-Object name |
Sort-Object name | ForEach-Object{$_.name.tolower()}
$vms = Get-Vm | Where-Object {$_.powerstate -eq "PoweredOn"} |
Where-Object {$_.name.length -gt 10} |
Where-Object {$_.guest.osfullname -like quot;*indows*"} | Select-Object name |
Sort-Object name | ForEach-Object{$_.Name.ToLower()}
$vmcount = $vms.count
$AddMachine = Compare-Object $vms $adlist -syncwindow $vmcount |
Where-Object {$_.sideindicator -eq "< ="} | Sort-Object InputObject
$RemoveMachine = Compare-Object $vms $adlist -syncwindow $vmcount |
Where-Object {$_.sideindicator -eq "=>"} | Sort-Object InputObject
#### Create Spreadsheet
$excel = New-Object -comobject Excel.Application
#$excel.visible = $True #### Use for troubleshooting purposes
$excel.DisplayAlerts = $False
$excelfile = $excel.Workbooks.Add()
$WorkSheet = $excelfile.worksheets.item(1)
$Worksheet.Name = "Add to Group"
$Worksheet.Cells.Item(1, 1) = "Machines that need to be added to the Group"
$WorkBook = $Worksheet.UsedRange
$WorkBook.Interior.ColorIndex = 8
$WorkBook.Font.ColorIndex = 11
$WorkBook.Font.Bold = $True
$Row = 2
$Addmachine | ForEach-Object {
$Worksheet.Cells.Item($Row, 1) = $_.InputObject
$Row ++
}
[void]$WorkBook.EntireColumn.AutoFit()
$WorkSheet = $excelfile.worksheets.item(2)
$Worksheet.Name = "Remove from Group"
$Worksheet.Cells.Item(1, 1) = "Machines that need to be removed from the Group"
$WorkBook = $Worksheet.UsedRange
$WorkBook.Interior.ColorIndex = 8
$WorkBook.Font.ColorIndex = 11
$WorkBook.Font.Bold = $True
$Row = 2
$RemoveMachine | ForEach-Object {
$Worksheet.Cells.Item($Row, 1) = $_.InputObject
$Row ++
}
#### Adjust Columns
[void]$WorkBook.EntireColumn.AutoFit()
#### Save File
$excelfile.SaveAs("c:\temp\VirtualServerGroup-" + $date.month + "-" + $date.day + "-" + $date.year + ".xls", 1)
#### Quit Excel
$excel.Quit()
#Disconnect from vCenter Server
$VIServer | Disconnect-VIServer -Confirm:$false