LucD, I love the output from the following but I'm missing a bit of information for my needs. &{foreach($esx in Get-VMHost){ $vNicTab = @{} $esx.ExtensionData.Config.Network.Vni...
See more...
LucD, I love the output from the following but I'm missing a bit of information for my needs. &{foreach($esx in Get-VMHost){ $vNicTab = @{} $esx.ExtensionData.Config.Network.Vnic | %{ $vNicTab.Add($_.Portgroup,$_) } foreach($vsw in (Get-VirtualSwitch -VMHost $esx)){ foreach($pg in (Get-VirtualPortGroup -VirtualSwitch $vsw)){ Select -InputObject $pg -Property @{N="ESX";E={$esx.name}}, @{N="vSwitch";E={$vsw.Name}}, @{N="NIC";E={if($vsw.Nic){[string]::Join(',',$vsw.Nic)}}}, @{N="Portgroup";E={$pg.Name}}, @{N="VLAN";E={$pg.VLanId}}, @{N="Device";E={if($vNicTab.ContainsKey($pg.Name)){$vNicTab[$pg.Name].Device}}}, @{N="IP";E={if($vNicTab.ContainsKey($pg.Name)){$vNicTab[$pg.Name].Spec.Ip.IpAddress}}} } } }} | Export-Csv report.csv -NoTypeInformation -UseCulture How do I get the following columns? VM Name, VM_IP, Virtual Host + the output from above: vSwitch, NIC, PortGroup, VLAN, Device, IP I am planning on retiring a cluster and need to move VMs. My goal is to accurately identify which VMs and VLANs/PortGroups I need to relocate. I do have a specific cluster name if that helps.