Powershell sorting data in Invoke-Command results

Question

I'm running an exe from invoke-command on multiple servers and it works. I get a string array with all the output I expect.

$result = invoke-command $servers { & "\path\toexe" arg1 }

This gives me the correct results

str3
str4
str2

...and the PSCOMPUTER name is in there too, but I can't show them together so I can't match the result to the PSComputername all at once.

$Result|GM just shows me PScomputername and RunspaceID as properties. It's like the $result array has no label for the string.

$result | Select * doesn't show me the string

$Result.gettype() shows it is [object] System.Array

I can do $result[0] will show me str3
And then $result[0].PSComputername will show Server3

How do I get that whole array on the screen or dumped to csv together? I'd like to see

PSCOMPUTERNAME   ??
Server3        str3
Server2        str2

Mathias R. Jessen · Accepted Answer · 2024-03-14 21:07:19Z

2

You can use Select-Object to create new objects consisting of the attached PSComputerName property along with a new named property containing the intrinsic value of the original string:

$result |Select-Object PSComputerName,@{Name='Value';Expression={"$_"}}

To learn more about using Select-Object with property expressions, see the about_Calculated_Properties help topic

edited Mar 14, 2024 at 21:07

answered Mar 13, 2024 at 16:29

Mathias R. Jessen

178k13 gold badges175 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

CoLatrL Damg3 Over a year ago

This is nice and easy - I just thought of 10 more uses for this syntax.

js2010 · Accepted Answer · 2024-03-13 19:05:46Z

1

I usually package the result in an object. This could be a script too. Unless the object type has a local view file, there's a runspaceid displayed too.

invoke-command $servers { [pscustomobject]@{result = \to` path\toexe arg1} }

result PSComputerName RunspaceId
-----  -------------- ----------
str3   Server3        5f8b7b5e-840d-4790-896a-d68aa23f1c01
str2   Server2        3b37b3d7-f1d0-433a-a387-65c4c3a59a5d

<# script.ps1 #>
[pscustomobject]@{result = \path\toexe arg1}

invoke-command $servers script.ps1

# same result

edited Mar 13, 2024 at 19:05

answered Mar 13, 2024 at 17:16

js2010

28.4k6 gold badges82 silver badges88 bronze badges

Collectives™ on Stack Overflow

Powershell sorting data in Invoke-Command results

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related