document.write('\
\ "); document.write('
  1. # Set the VI Server and Filename before running
    2. \
  2. Connect-VIServer MYVISERVER
    3. \
  3. $filename = "C:\\DetailedNetworkInfo.csv"
    4. \
  4.  
    5. \
  5. Write "Gathering VMHost objects"
    6. \
  6. $vmhosts = Get-VMHost | Sort Name | Where-Object {$_.State -eq "Connected"} | Get-View
    7. \
  7. $MyCol = @()
    8. \
  8. foreach ($vmhost in $vmhosts){
    9. \
  9.  $ESXHost = $vmhost.Name
    10. \
  10.  Write "Collating information for $ESXHost"
    11. \
  11.  $networkSystem = Get-view $vmhost.ConfigManager.NetworkSystem
    12. \
  12.  foreach($pnic in $networkSystem.NetworkConfig.Pnic){
    13. \
  13.      $pnicInfo = $networkSystem.QueryNetworkHint($pnic.Device)
    14. \
  14.      foreach($Hint in $pnicInfo){
    15. \
  15.          $NetworkInfo = "" | select-Object Host, vSwitch, vSwitchPorts, vSwitchPrtInUse, PNic, Speed, MAC, DeviceID, PortID, Observed, VLAN
    16. \
  16.          $NetworkInfo.Host = $vmhost.Name
    17. \
  17.                  $NetworkInfo.vSwitch = Get-Virtualswitch -VMHost (Get-VMHost ($vmhost.Name)) | where {$_.Nic -eq ($Hint.Device)}
    18. \
  18.          $NetworkInfo.vSwitchPorts = $NetworkInfo.vSwitch.NumPorts
    19. \
  19.                  $NetworkInfo.vSwitchPrtInUse = ($NetworkInfo.vSwitch.NumPorts - $NetworkInfo.vSwitch.NumPortsAvailable)
    20. \
  20.                  $NetworkInfo.PNic = $Hint.Device
    21. \
  21.          $NetworkInfo.DeviceID = $Hint.connectedSwitchPort.DevId
    22. \
  22.          $NetworkInfo.PortID = $Hint.connectedSwitchPort.PortId
    23. \
  23.          $record = 0
    24. \
  24.          Do{
    25. \
  25.              If ($Hint.Device -eq $vmhost.Config.Network.Pnic[$record].Device){
    26. \
  26.                  $NetworkInfo.Speed = $vmhost.Config.Network.Pnic[$record].LinkSpeed.SpeedMb
    27. \
  27.                  $NetworkInfo.MAC = $vmhost.Config.Network.Pnic[$record].Mac
    28. \
  28.              }
    29. \
  29.              $record ++
    30. \
  30.          }
    31. \
  31.          Until ($record -eq ($vmhost.Config.Network.Pnic.Length))
    32. \
  32.          foreach ($obs in $Hint.Subnet){
    33. \
  33.              $NetworkInfo.Observed += $obs.IpSubnet + " "
    34. \
  34.              Foreach ($VLAN in $obs.VlanId){
    35. \
  35.                  If ($VLAN -eq $null){
    36. \
  36.                  }
    37. \
  37.                  Else{
    38. \
  38.                      $strVLAN = $VLAN.ToString()
    39. \
  39.                      $NetworkInfo.VLAN += $strVLAN + " "
    40. \
  40.                  }
    41. \
  41.              }
    42. \
  42.          }
    43. \
  43.          $MyCol += $NetworkInfo
    44. \
  44.      }
    45. \
  45.  }
    46. \
  46. }
    47. \
  47. $Mycol | Sort Host, PNic | Export-Csv $filename -NoTypeInformation
    48. \
');document.write('
downloadThis Script brought to you by PoshCode\
\
\
');