PowerCli | | Micronauts

Each Saturday my company does a refresh of a few different machines. This refresh consists of cloning a couple of production machines into our lab environment for development. It’s a very tedious process that takes the entire day to do. Until recently, this process has been done manually. I’ve been working on a script to automate the process as much as possible. Along the way, I’ve learned a great deal about powershell/powercli – especially from hitting a wall and trying to figure out a way around. This blog entry is about one of those snags along the path of progress.

The refresh consists of two major Acts. Act I is all about cloning the source VMs, stripping them down, and converting them into templates. Act II is about deploying VMs using differing templates. There will be a later entry discussing this entire script in greater detail. This entry focuses on creating merged array to be used in the deployment CSV list for Act II.

Each week, the refresh list changes. One week, the source VMs may be SourceVM01 & SourceVM05. Next week, it may be SourceVM01 & SourceVM03. I created a GUI frontend for this script using PrimalForms 2011. The GUI has a “pick-list” where you can cherry pick what SourceVMs and what DestinationVMs will be needed. Upon your selection, three arrays are built – $a = #VM Names, $b = #Specs, $c = #Template Names.

For example;
If I needed to refresh DEV-VM01, TEST-VM01, and QA-VM01; I’d check their boxes, and the following variables would be added to the three arrays. (You can start to see where if you had multiple Dev and Test VMs how these arrays can get quite complex.)

DEV-VM1	TST-VM1	QA-VM1
$avm = “DEV-VM1”	$avm = “TST-VM1”	$avm = “QA-VM1”
$bspec = “DEV”	$bspec = “TST”	$bspec = “QA”
$ctmp = “TMPL-DEV01”	$ctmp = “TMPL-TST01”	$ctmp = “TMPL-QA01”

So the question was, how do you take this information and merge it – with one array, and all the information within? That’s where I came up with this solution.
I replay each of the arrays using a “counter” ($i) and building a new array with the information from the table above. The counter variable matches each record for that row (ie. $a.record1 with $b.record1 and $c.record1).

$d=@()
for($i=0;$i -lt $a.count;$i++)
	{
	$row = "" | Select-Object VMName, Spec, Template
	$row.VMName = "$($a[$i])"
	$row.Spec = "$($b[$i])" 
	$row.Template = "$($c[$i])"
	$d+=$row
	}

$d=@()

for($i=0;$i -lt $a.count;$i++)

{

$row = "" | Select-Object VMName, Spec, Template

$row.VMName = "$($a[$i])"

$row.Spec = "$($b[$i])"

$row.Template = "$($c[$i])"

$d+=$row

}

The array will continue to loop, until it runs out of entries based on the $a array. Once this fourth array ($d) has been created, I can then use it to build my deployment CSV file (SEE THE DEPLOYMENT CSV LIST BUILD SCRIPT – To come).

Over the last few days, my coworker and I have been working on a script that will go out and collect detailed network information for each NIC on our ESX hosts. Not wanting to reinvent the wheel, I strolled over to Alan Reneuf’s website (www.virtu-al.net). I had remembered seeing a script (“More Network Info”) he created that I knew could collect the info we wanted. Thank you, Alan.

I copied Alan’s script into Notepad++ and started to work with it. One of the things we needed to know was duplex information. Since that wasn’t in the original script, I added it. I didn’t need to know the number of active virtual switch ports, so I removed that portion.

Here are the end results of this modified script.

NETWORKINFO.PS1

##==============================================================================
##==============================================================================
##  SCRIPT.........:  networkinfo.ps1
##  AUTHOR.........:  J. Sam Aaron
##  EMAIL..........:  sam.aaron@micronauts.us
##  VERSION........:  1.0.6
##  DATE...........:  08/22/2011
##  COPYRIGHT......:  2011, Sam Aaron
##  LICENSE........:  Freeware
##  REQUIREMENTS...:  Powershell v2.0 and the VI Toolkit
##	USAGE..........:  ./networkinfo.ps1
##
##  DESCRIPTION....:  This program will collect detailed Network info 
##					  
##
##  NOTES..........:  Modified & Combined code from Alan Reneuf & Jeff Grummons 
## 
##  CUSTOMIZE......:  
##==============================================================================


##==============================================================================
##  START <CODE>
##==============================================================================


	## LOAD THE VI-SNAPIN
	##==============================================================================
	if ( (Get-PSSnapin -Name "VMware.VimAutomation.Core" -ErrorAction SilentlyContinue) -eq $null )
		{
		Add-PSSnapin -Name "VMware.VimAutomation.Core"
		}


	##==============================================================================
	##  VARIABLES
	##==============================================================================
		$vc = "virtualcentername" 
		$filename = "c:\POSH\Reports\DetailedNetworkInfo.csv"
		$MyCol = @()

		
	## VIRTUAL CENTER CONNECTION
	##==============================================================================
	Connect-VIServer -Server $vc 


	## GATHER HOSTS FROM CLUSTER
	##==============================================================================
	$clusters = get-cluster | Select Name
	foreach ($cluster in $clusters)
		{
		$h = $cluster
		$vmhosts = Get-Cluster $h.Name | Get-VMHost | Sort Name | Get-View

		
		## COLLECT ENTIRE NETWORK SYSTEM FOR EACH HOST
		##==============================================================================
		foreach($vmhost in $vmhosts)
			{
			$ESXHost = $vmhost.Name
			Write-host "Collating information for $ESXHost"
			$networkSystem = Get-view $vmhost.ConfigManager.NetworkSystem


			## NETWORK INFORMATION FOR EACH NIC 
			##==============================================================================
			foreach($pnic in $networkSystem.NetworkConfig.Pnic)
				{
				$pnicInfo = $networkSystem.QueryNetworkHint($pnic.Device)


				## FOR EACH NIC COLLATE NEEDED NETWORK INFORMATION 
				##==============================================================================
				:Details foreach($Hint in $pnicInfo)
					{
					$NetworkInfo = "" | select-Object Host, Cluster, vSwitch, PNic, Speed, Duplex, Configured, MAC, DeviceID, PortID, Observed, VLAN
					$NetworkInfo.Host = $vmhost.Name
					$NetworkInfo.Cluster = $h.Name
					$NetworkInfo.PNic = $Hint.Device
					$NetworkInfo.DeviceID = $Hint.connectedSwitchPort.DevId
					$NetworkInfo.PortID = $Hint.connectedSwitchPort.PortId
					If ($NetworkInfo.PortID -eq $null) { continue Details }
					$NetworkInfo.vSwitch = Get-Virtualswitch -VMHost (Get-VMHost ($vmhost.Name)) | where {$_.Nic -eq ($Hint.Device)}
					$record = 0
					Do{
						If ($Hint.Device -eq $vmhost.Config.Network.Pnic[$record].Device)
							{
							$NetworkInfo.Speed = $vmhost.Config.Network.Pnic[$record].LinkSpeed.SpeedMb
							$extra = $vmhost.Config.Network.Pnic[$record].LinkSpeed.duplex
							if ($extra -eq $True) {$NetworkInfo.duplex = "Full"} else {$NetworkInfo.duplex = "Half"}
							$NetworkInfo.MAC = $vmhost.Config.Network.Pnic[$record].Mac	
							}
						$record ++
					 }Until ($record -eq ($vmhost.Config.Network.Pnic.Length))
					 
					if($Hint.ConnectedSwitchPort.FullDuplex -eq $true)
						{
						$NetworkInfo.Configured = "Full"
						}
						elseif($Hint.ConnectedSwitchPort.FullDuplex -eq $false)
							{
							$NetworkInfo.Configured = "Half"
							}
					
					foreach ($obs in $Hint.Subnet)
						{
						$NetworkInfo.Observed += $obs.IpSubnet + " "
						Foreach ($VLAN in $obs.VlanId)
							{
							If ($VLAN -eq $null)
								{
								} else {
									$strVLAN = $VLAN.ToString()
									$NetworkInfo.VLAN += $strVLAN + " "
									}
							}	
						}
					$MyCol += $NetworkInfo
					}
				}
			}
		}
		
		
		## DISPLAY OUTPUT & SAVE TO CSV
		##==============================================================================
		$mycol | Out-GridView 
		$Mycol | Sort Host, PNic | Export-Csv $filename -NoTypeInformation

		
		## DISCONNECT FROM VC
		##==============================================================================
		Disconnect-VIServer -Server $vc -Confirm:$False
		Write-Host "Disconnected from" $vc
			
##==============================================================================
##  END 
##==============================================================================


##==============================================================================
##  REVISED BY.....:  J. Sam Aaron
##  EMAIL..........:  sam.aaron@micronauts.us
##	REVISION.......:  1.0.6
##  REVISION DATE..:  08-22-2011
##  REVISION NOTES.:  Cleanedup Script and added comments
##					  
##
##==============================================================================
# Version 1.0.6 - Cleanedup Script and added comments
# Version 1.0.5 - Fixed misplaced bracket (line 119)
# Version 1.0.4 - Added actual duplex settings (line 91)
# Version 1.0.3 - Check Link status - display if active (line 84)
# Version 1.0.2 - Added Cluster loop info (line 51)
# Version 1.0.1 - Initial Creation

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

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

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

## SCRIPT.........: networkinfo.ps1

## AUTHOR.........: J. Sam Aaron

## EMAIL..........: sam.aaron@micronauts.us

## VERSION........: 1.0.6

## DATE...........: 08/22/2011

## COPYRIGHT......: 2011, Sam Aaron

## LICENSE........: Freeware

## REQUIREMENTS...: Powershell v2.0 and the VI Toolkit

## USAGE..........: ./networkinfo.ps1

## DESCRIPTION....: This program will collect detailed Network info

## NOTES..........: Modified & Combined code from Alan Reneuf & Jeff Grummons

## CUSTOMIZE......:

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

## START <CODE>

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

## LOAD THE VI-SNAPIN

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

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

{

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

}

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

## VARIABLES

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

$vc = "virtualcentername"

$filename = "c:\POSH\Reports\DetailedNetworkInfo.csv"

$MyCol = @()

## VIRTUAL CENTER CONNECTION

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

Connect-VIServer -Server $vc

## GATHER HOSTS FROM CLUSTER

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

$clusters = get-cluster | Select Name

foreach ($cluster in $clusters)

{

$h = $cluster

$vmhosts = Get-Cluster $h.Name | Get-VMHost | Sort Name | Get-View

## COLLECT ENTIRE NETWORK SYSTEM FOR EACH HOST

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

foreach($vmhost in $vmhosts)

{

$ESXHost = $vmhost.Name

Write-host "Collating information for $ESXHost"

$networkSystem = Get-view $vmhost.ConfigManager.NetworkSystem

## NETWORK INFORMATION FOR EACH NIC

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

foreach($pnic in $networkSystem.NetworkConfig.Pnic)

{

$pnicInfo = $networkSystem.QueryNetworkHint($pnic.Device)

## FOR EACH NIC COLLATE NEEDED NETWORK INFORMATION

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

:Details foreach($Hint in $pnicInfo)

{

$NetworkInfo = "" | select-Object Host, Cluster, vSwitch, PNic, Speed, Duplex, Configured, MAC, DeviceID, PortID, Observed, VLAN

$NetworkInfo.Host = $vmhost.Name

$NetworkInfo.Cluster = $h.Name

$NetworkInfo.PNic = $Hint.Device

$NetworkInfo.DeviceID = $Hint.connectedSwitchPort.DevId

$NetworkInfo.PortID = $Hint.connectedSwitchPort.PortId

If ($NetworkInfo.PortID -eq $null) { continue Details }

$NetworkInfo.vSwitch = Get-Virtualswitch -VMHost (Get-VMHost ($vmhost.Name)) | where {$_.Nic -eq ($Hint.Device)}

$record = 0

Do{

If ($Hint.Device -eq $vmhost.Config.Network.Pnic[$record].Device)

{

$NetworkInfo.Speed = $vmhost.Config.Network.Pnic[$record].LinkSpeed.SpeedMb

$extra = $vmhost.Config.Network.Pnic[$record].LinkSpeed.duplex

if ($extra -eq $True) {$NetworkInfo.duplex = "Full"} else {$NetworkInfo.duplex = "Half"}

$NetworkInfo.MAC = $vmhost.Config.Network.Pnic[$record].Mac

}

$record ++

}Until ($record -eq ($vmhost.Config.Network.Pnic.Length))

if($Hint.ConnectedSwitchPort.FullDuplex -eq $true)

{

$NetworkInfo.Configured = "Full"

}

elseif($Hint.ConnectedSwitchPort.FullDuplex -eq $false)

{

$NetworkInfo.Configured = "Half"

}

foreach ($obs in $Hint.Subnet)

{

$NetworkInfo.Observed += $obs.IpSubnet + " "

Foreach ($VLAN in $obs.VlanId)

{

If ($VLAN -eq $null)

{

} else {

$strVLAN = $VLAN.ToString()

$NetworkInfo.VLAN += $strVLAN + " "

}

$MyCol += $NetworkInfo

}

## DISPLAY OUTPUT & SAVE TO CSV

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

$mycol | Out-GridView

$Mycol | Sort Host, PNic | Export-Csv $filename -NoTypeInformation

## DISCONNECT FROM VC

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

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

Write-Host "Disconnected from" $vc

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

## END

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

## REVISED BY.....: J. Sam Aaron

## EMAIL..........: sam.aaron@micronauts.us

## REVISION.......: 1.0.6

## REVISION DATE..: 08-22-2011

## REVISION NOTES.: Cleanedup Script and added comments

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

# Version 1.0.6 - Cleanedup Script and added comments

# Version 1.0.5 - Fixed misplaced bracket (line 119)

# Version 1.0.4 - Added actual duplex settings (line 91)

# Version 1.0.3 - Check Link status - display if active (line 84)

# Version 1.0.2 - Added Cluster loop info (line 51)

# Version 1.0.1 - Initial Creation

The above script may not actually display properly within this blog entry. If this is the case, you can download the script here.

Micronauts

Tag: PowerCli

Thinking About Upgrading To vSphere 5.1?

Script: Changing the Path Selection Policy

Script: Merge Multiple Arrays

Script: Detailed NIC Information Report

Script: Drive Letter Order