wetnose88's Accepted Solutions

    I changed your code slightly by Sort-Object VM instead of Sort-Object @{E={$_.Parent.Name}}, please try and see if make a difference. Get-VM | Get-NetworkAdapter | Select-Object @{N="VM";E={$_.Parent.Name}}, name, NetworkName, type, MacAddress, @{N="Connection State";E={Set-Color -string $_.ConnectionState}} | Sort-Object VM | ConvertTo-Html |% { ($_.Replace("&lt;","<")).Replace("&gt;",">").replace("&quot;",'"').replace("&#39;",'"') } | Out-String    

I tested the script in my environment, following are the exported result, I have thousands of VMs, just part of the result. VM Name Power State Interface ConnectionState Type Connect on Boot Operating System OS Family VM001 PoweredOn Network adapter 1 Connected e1000 TRUE Red Hat Enterprise Linux 5 (64-bit) linuxGuest VM002 PoweredOn Network adapter 1 Connected Vmxnet3 TRUE Red Hat Enterprise Linux 7 (64-bit) linuxGuest VM003 PoweredOn Network adapter 1 Connected Vmxnet3 TRUE Red Hat Enterprise Linux 6 (64-bit) linuxGuest VM004 PoweredOn Network adapter 1 Connected Vmxnet3 TRUE CentOS 7 (64-bit) linuxGuest VM005 PoweredOn Network adapter 1 Connected Vmxnet3 TRUE Microsoft Windows Server 2012 (64-bit) windowsGuest VM006 PoweredOn Network adapter 1 Connected Vmxnet3 TRUE Red Hat Enterprise Linux 7 (64-bit) linuxGuest VM007 PoweredOn Network adapter 1 Connected Vmxnet3 TRUE Microsoft Windows Server 2012 (64-bit) windowsGuest VM008 PoweredOn Network adapter 1 Connected Vmxnet3 TRUE Microsoft Windows Server 2016 or later (64-bit) windowsGuest VM009 PoweredOn Network adapter 1 Connected Vmxnet3 TRUE Microsoft Windows Server 2016 or later (64-bit) windowsGuest VM010 PoweredOn Network adapter 1 Connected Vmxnet3 TRUE Red Hat Enterprise Linux 8 (64-bit) linuxGuest VM011 PoweredOn Network adapter 1 Connected Vmxnet3 TRUE Microsoft Windows Server 2012 (64-bit) windowsGuest VM012 PoweredOn Network adapter 1 Connected Vmxnet3 TRUE Microsoft Windows Server 2012 (64-bit) windowsGuest VM013 PoweredOn Network adapter 1 Connected Vmxnet3 TRUE Microsoft Windows Server 2016 or later (64-bit) windowsGuest VM014 PoweredOn Network adapter 1 Connected Vmxnet3 TRUE Microsoft Windows Server 2016 or later (64-bit) windowsGuest VM015 PoweredOn Network adapter 1 Connected Vmxnet3 TRUE Microsoft Windows Server 2012 (64-bit) windowsGuest

Get-VM | Sort-Object -Property Name -PipelineVariable vm | ForEach-Object -Process { Get-NetworkAdapter -VM $vm | Where-Object { $_.ConnectionState.StartConnected -eq $true} | Select-Object @{N = "VM Name"; E = {$vm.Name }}, @{N = "Power State"; E = { $vm.PowerState } }, @{N = "Interface"; E = {$_.Name }}, @{N = 'ConnectionState'; E={if($_.ConnectionState.Connected){'Connected'}else{'NotConnected'}}}, @{N = "Type"; E = {$_.Type }}, @{N = "Connect on Boot"; E = {$_.ConnectionState.StartConnected}}, #@{N = "OS Full Name"; E = {$_.ExtensionData.Guest.guestFullName}}, @{N="Operating System"; E={@($vm.guest.OSFullName)}}, #@{N= "OS Family"; E = {{$_.ExtensionData.Guest.guestFamily}} @{N="OS Family"; E={@($vm.guest.guestFamily)}} }| Export-CSV $outputFile -NoTypeInformation -Append

You can refer to this posted by Luc D https://communities.vmware.com/t5/ESXi-Discussions/Script-to-get-if-ESXi-host-is-in-AD-or-not/td-p/498803 $report = foreach($vc in $global:DefaultVIServers){     Get-VMHost -Server $vc | Get-VMHostAuthentication |     Select @{N='vCenter';E={$vc.Name}},         @{N='VMHost';E={$_.VMHost.Name}},         @{N='AD Domain';E={$_.DOmain}} }   $report | Export-Csv VC-ESXi-AD.csv -NoTypeInformation -UseCulture