Format-table combining results from multiple commands on same row

Question

(I'm new to PowerShell and my understanding is limited so I would appreciate a brief explanation as well as a solution if possible)&nbsp;I've got the following code running successfully to query a list of computers and return various data about them in a table.&nbsp; However, the data from the various commands run against a particular computer is not appearing on the same row.&nbsp; Can anyone suggest a way to combine the results for one machine onto a single table row?&nbsp;$hostnames = Get-Content "allpcs.txt"$output = foreach ($hostname in $hostnames) {&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; if (Test-Connection -ComputerName $hostname -Count 1 -ErrorAction 'SilentlyContinue') {&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Invoke-Command -ComputerName $hostname -ScriptBlock {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Get-WmiObject Win32_ComputerSystem | Select-Object -ExcludeProperty name;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Get-ItemProperty -Path "c:\windows\system32\hal.dll").VersionInfo.FileVersion;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (Get-ItemProperty -Path "C:\Program Files (x86)\Microsoft Office\root\Office16\ONENOTE.EXE").VersionInfo.FileVersion;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; gcim Win32_OperatingSystem | select InstallDate,LastBootupTime;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Get-PSDrive C | select Free; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; else {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; write-host $hostname "not connected"&nbsp;&nbsp;&nbsp; }}$output | Format-Table Name,OSver,O365ver,InstallDate,LastBootupTime,Free | Out-File -filepath allpcs.csv -AppendExample output:&nbsp;Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OSver O365ver InstallDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; LastBootupTime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Free&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;----&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----- ------- -----------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;comp1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;10.0.16299.371 (WinBuild.160101.0800)16.0.8431.2110&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 05/10/2018 16:18:59 14/11/2018 09:48:33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40862683136 comp2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;10.0.16299.371 (WinBuild.160101.0800)16.0.9126.2259&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 13/08/2018 15:49:28 09/11/2018 07:46:41&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 436695408640&nbsp;

reinier spruijt · Answer

Thank you, Darrick the A PowerShell Object Lesson: Part 3 article was helpful.

I managed to tweak the code slightly to get my table by putting each new object into an array. That array could then be presented as a table (and exported to csv).

Here is the final, working script:

$hostnames = Get-Content 'allpcs.txt'

$allpcs = @()

foreach ($hostname in $hostnames) {

  if (Test-Connection -ComputerName $hostname -Count 1 -ErrorAction 'SilentlyContinue') {

    $OS = Get-WmiObject -Class Win32_OperatingSystem -Computer $hostname

    $pcinfo = [PSCustomObject]@{
      Name = $OS.PSComputerName
      OSVer = (Get-ItemProperty -Path '\\$hostname\c$\windows\system32\hal.dll').VersionInfo.FileVersion
      O365ver = (Get-ItemProperty -Path '\\$hostname\c$\Program Files (x86)\Microsoft Office\root\Office16\ONENOTE.EXE').VersionInfo.FileVersion;
      Free = Invoke-Command -ComputerName $hostname {[math]::Round((Get-PSDrive -Name C | Select-Object -ExpandProperty Free)/1GB,2)}
      InstallDate = $OS.ConvertToDateTime($OS.Installdate)
      LastBootUpTime = $OS.ConvertToDateTime($OS.LastBootUpTime)

    }

    $allpcs += $pcinfo

  }

  else {

    write-host $hostname "not connected"
  }
}

Write-Output $allpcs | Format-Table
Write-Output $allpcs | ConvertTo-Csv | Out-File -filepath 'allpcs.csv'

darrick · Answer

&nbsp;Sorry, I didn't have a chance to thoroughly test this yet.&nbsp;What you want is a PowerShell custom object to format the data the way you want. See below.&nbsp;You may find this reference useful: A PowerShell Object Lesson: Part 3&nbsp;---------------------------------------------------------------------------------------------------&nbsp;$hostnames = Get-Content "allpcs.txt"# create a custom PowerShell object to store specific information$ComputerInfoObj = [PSCustomObject]@{&nbsp;&nbsp;&nbsp; Name = ""&nbsp;&nbsp;&nbsp; OSVer = ""&nbsp;&nbsp;&nbsp; O365ver = ""&nbsp;&nbsp;&nbsp; InstallDate = ""&nbsp;&nbsp;&nbsp; LastBootUpTime = ""&nbsp;&nbsp;&nbsp; Free = ""}$output = foreach ($hostname in $hostnames) {&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; if (Test-Connection -ComputerName $hostname -Count 1 -ErrorAction 'SilentlyContinue') {&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Invoke-Command -ComputerName $hostname -ScriptBlock {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $ComputerInfoObj.Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = (Get-WmiObject Win32_ComputerSystem).Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $ComputerInfoObj.OSVer&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = (Get-ItemProperty -Path "c:\windows\system32\hal.dll").VersionInfo.FileVersion&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $ComputerInfoObj.O365ver&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = (Get-ItemProperty -Path "C:\Program Files (x86)\Microsoft Office\Office16\ONENOTE.EXE").VersionInfo.FileVersion&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $ComputerInfoobj.Free&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = "$([int64]((Get-PSDrive C).Free / 1GB)) GB"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $ComputerInfoObj.InstallDate&nbsp;&nbsp;&nbsp; = (Get-CimInstance Win32_OperatingSystem).InstallDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $ComputerInfoObj.LastBootUpTime = (Get-CimInstance Win32_OperatingSystem).LastBootUpTime&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; else {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; write-host $hostname "not connected"&nbsp;&nbsp;&nbsp; }}Write-OutPut $ComputerInfoObj | Format-TableWrite-Output $ComputerInfoObj | ConvertTo-Csv | Out-File allpcs.csv -Append

Forum Discussion

Format-table combining results from multiple commands on same row