How easy would it be to get the below codes output to a spreadsheet. Ideally each column be the name of the ESXi Host and under those columns are the returned results.

Get-VMHost | Where-Object {$_.State -eq "Connected"} |
%{Get-View $_.ID} |
%{$esxname = $_.Name; Get-View $_.ConfigManager.NetworkSystem} |
%{ foreach($physnic in $_.NetworkInfo.Pnic){
    $pnicInfo = $_.QueryNetworkHint($physnic.Device)
    foreach($hint in $pnicInfo){
      Write-Host $esxname $physnic.Device
      if( $hint.ConnectedSwitchPort ) {
        $hint.ConnectedSwitchPort
      } else {
        Write-Host "No CDP information available."; Write-Host
      }
    }
  }
}

code found in http://kb.vmware.com/kb/1003885

Hi

I’m busy with a proof of concept for VMWare view.  So far everything has been setup and working quite nicely. I am using View 4.6 and hosting my Win 7 x64 VM’s on a Vsphere environment with ESX 4.0 hosts.

I can log into my VM’s using the view client via a View Administror Server. Once logged in, sound works fine, I can open mp3’s or youtube and sound works in general. Going into Device Manager I can see there is a device called VMWare virtual audio (devtap) installed, although the virtual machine settings via Virtual Centre obviously displays no sound device.

After starting to play around with some of our applications, including Microsoft lync, I noticed that I cannot make audio calls to other Lync clients, most likely due to there not being any microphone support here. I have tried to do the same thing from a thinclient with audio out / mic in jacks, but get the same result. Is there some sort of driver which allows for microphone emulation the same way as which is currently being used for sound card emulation for View?