Need VMs and Portgroups and the associated vSwitch's

[stanj]

Is there a set of commands or a PowerCLI script that can connect to an ESXi  6.0 host and provide all VM names along with associated Portgroups and the associated vSwitch's

thanks

[LucD]

Yes, Get-VirtualSwitch and Get-VirtualPortgroup, provided you are talking about VSS and not VDS

[stanj]

ok,,

Any examples that can be put into a script and executed from Win10 to produce output similar to?

VM1 , vSwitch1, PortGroupA, PortGroupB,  etc  

thanks

[LucD]

How would you handle a VM that is connected to multiple vSwitches?

[stanj]

Good point...

Based on a quick look on the host, 95% of the VMs are on a single vSwitch

Possibly for the few that are not, i can annotate the output 

[LucD]

I understand, but the issue is that it is not obvious to have a variable number of columns in the output.
Especially if you want to export the results to a CSV file.

[stanj]

Ok, I can use a report for the PortGroups and VMs.

I tried the below script.  However, when I enter the account and password, it accepts the creds and just exits an provided no list?

https://raw.githubusercontent.com/TheSleepyAdmin/Scripts/master/VMware/Network/VMware_PortGroupRepor...

[stanj]

I replaced  Get-VDPortgroup with Get-VirtualPortGroup and am now seeing a list,,

I still need to tie in the vSwitch's..

[LucD]

That script you linked to is for VDS, not VSS.
You can't just replace 1 cmdlet and then hope that it works I'm afraid.

[stanj]

 by replacing Get-VDPortgroup with  Get-VirtualPortGroup, the script did and produced the output

VMName : RHEL7-TEST-DEMO
PortGroup : Outside-Net
Host : esx-03.test.org
Cluster : Testing
PowerStatus : poweredOff

VMName : win10
PortGroup : Outside-Net
Host : esx-03.test.org
Cluster : Testing
PowerStatus : poweredOff

VMName : win2016-svr
PortGroup : DMZ
Host : esx-03.test.org
Cluster : Testing
PowerStatus : poweredOff

[LucD]

Since you seem to have dropped your original request for output in a specific format, you could also just do

Get-Cluster -PipelineVariable cluster |
Get-VMHost -PipelineVariable esx |
Get-VM -PipelineVariable vm |
Get-NetworkAdapter -PipelineVariable nic |
Select @{N='Cluster';E={$cluster.Name}},
  @{N='VMHost';E={$esx.Name}},
  @{N='VM';E={$vm.Name}},
  @{N='vSwitch';E={(Get-VirtualSwitch -RelatedObject (Get-VirtualPortGroup -Name $_.NetworkName) ).Name}},
  @{N='Portgroup';E={$_.NetworkName}},
  @{N='Nic';E={$_.Name}}

[stanj]

Thanks..

Will this work on a standalone ESXi host?

We only need to list the info for one ESXi host

[LucD]

Is that ESXi connected to a VCSA?
And there obviously will not be a Cluster value

[stanj]

Yes,,there is a vCEnter,, but i only need the info off one ESXi host

[LucD]

Then you could do

Get-VMHost -Name <MyEsx> -PipelineVariable esx |
Get-VM -PipelineVariable vm |
Get-NetworkAdapter -PipelineVariable nic |
Select @{N='VMHost';E={$esx.Name}},
  @{N='VM';E={$vm.Name}},
  @{N='vSwitch';E={(Get-VirtualSwitch -RelatedObject (Get-VirtualPortGroup -Name $_.NetworkName) ).Name}},
  @{N='Portgroup';E={$_.NetworkName}},
  @{N='Nic';E={$_.Name}}

[stanj]

ok,,

thanks for the update...

I ran the script but now see an error ......

+ Get-VMHost -Name <MyEsx> -PipelineVariable esx |
+ ~
The '<' operator is reserved for future use.
+ CategoryInfo : ParserError: (:) [], ParentContainsErrorRecordException
+ FullyQualifiedErrorId : RedirectionNotSupported

[LucD]

You have to replace <MyEsx> with the name of your ESXi node.

[stanj]

I replaced MyESX with the ESXi node IP and it ran.

Is there a way to prompt or pass in the ESXi IP / node similar to how the cmdlet below will ask for the login and password of the host...

$cred = Get-Credential

[LucD · Accepted solution]

Sure, like this

$esxName = Read-Host -Prompt "Enter the name of the ESX host:" 

Get-VMHost -Name $esxName -PipelineVariable esx |
Get-VM -PipelineVariable vm |
Get-NetworkAdapter -PipelineVariable nic |
Select @{N='VMHost';E={$esx.Name}},
  @{N='VM';E={$vm.Name}},
  @{N='vSwitch';E={(Get-VirtualSwitch -RelatedObject (Get-VirtualPortGroup -Name $_.NetworkName) ).Name}},
  @{N='Portgroup';E={$_.NetworkName}},
  @{N='Nic';E={$_.Name}}

[stanj]

Excellent..

I added the connect and disconnect below and it works great!

thanks again for the help...

$esxName = Read-Host -Prompt "Enter the name of the ESX host:"
Connect-VIServer -Server $esxName
Get-VMHost -Name $esxName -PipelineVariable esx |
Get-VM -PipelineVariable vm |
Get-NetworkAdapter -PipelineVariable nic |
Select @{N='VMHost';E={$esx.Name}},
@{N='VM';E={$vm.Name}},
@{N='vSwitch';E={(Get-VirtualSwitch -RelatedObject (Get-VirtualPortGroup -Name $_.NetworkName) ).Name}},
@{N='Portgroup';E={$_.NetworkName}},
@{N='Nic';E={$_.Name}}
Disconnect-VIServer