You get the output in List format because the PowerShell output engine has rules which tell it do so when the output exceeds specific values.
You can compose lines yourself, thus bypassing the PS output engine, and then write those lines to a .txt file.
Something like this for example.
But this also shows an issue when you are trying to do output yourself, there is no automatic alignment!
$result = Get-VMHost | Sort Name
|Select Name, @{N="NTPServer";E={$_ |Get-VMHostNtpServer}},
@{N="ServiceRunning";E={(Get-VmHostService -VMHost $_ |Where-Object {$_.key-eq "ntpd"}).Running}},
@{N="IncomingPorts";E={($_ | Get-VMHostFirewallException | Where-Object {$_.Name -eq "NTP client"}).IncomingPorts}},
@{N="OutgoingPorts";E={($_ | Get-VMHostFirewallException | Where-Object {$_.Name -eq "NTP client"}).OutgoingPorts}},
@{N="Protocols";E={($_ | Get-VMHostFirewallException | Where-Object {$_.Name -eq "NTP client"}).Protocols}},
@{N="StartupPolicy";E={($_ | Get-VmHostService | Where-Object {$_.key-eq "ntpd"}).Policy}}
$report = @()
$report += "Name NTPServer ServiceRunning IncomingPorts OutgoingPorts Protocols StartupPolicy"
$result | ForEach-Object -Process {
$report += "{0} {1} {2} {3} {4} {5}" -f $_.Name,$_.NTPServer,$_.ServiceRunning,$_.IncomingPorts,$_.OutgoingPorts,
$_.Protocols,$_.StartupPolicy
}
$report | Set-Content -Path .\report.txt
You could consider making the column sufficiently wide and thus calculating the correct alignment. But that is some work that is not really suited for automation.
