Get information about vSphere host physical ports CDP

Get-VMHostCDPPorts.ps1

$cdpVar = ForEach ($dstHost in $(Get-VMHost))
{
    $NetSystem = Get-View $dstHost.ExtensionData.ConfigManager.NetworkSystem
    foreach ($Pnic in $dstHost.ExtensionData.Config.Network.Pnic) 
    {
        if ($Pnic.Device -notlike "vusb*")
        {
            $PnicInfo = $NetSystem.QueryNetworkHint($Pnic.Device)
            $cdp = $PnicInfo.ConnectedSwitchPort

            [pscustomobject]@{
                server = $dstHost.Name
                serverPort = $Pnic.Device
                cdpDevice = $cdp.DevId
                cdpDevicePort = $cdp.PortId
            }
        }
    }
}

# $cdpVar

$cdpVar | Export-Excel -Path C:\temp\vs5vmvlans.xlsx `
  -Title "какой сервер каким портом в какую циску воткнут" `
  -TableName "CiscoPorts" `
  -WorksheetName "CiscoPorts" `
  -AutoSize `
  -Show `
  -Append