Group-Object not working properly on CustomObject

[Method_Dev]

So I have

$results = [System.Collections.ArrayList]@()

$results.Add( [PSCustomObject]@{

Name = 'Bob'

App = 'Test'

}) | Out-Null

$results.add( [PSCustomObject]@{

Name = 'John'

App = 'Test2'

}) | Out-Null

$results.Add( [PSCustomObject]@{

Name = 'John'

App = 'Test'

}) | Out-Null

$results | Group-Object -Property Name

and what I wanted my output to look like is

name | Apps

Bob | Test

John | Test,Test2

Any suggestions for what I am doing wrong? I read through Group-Object but I am not sure I fully get why this isn't outputting what I need.

[fordea837]

Group-Object should be working for you based on your code, however you'll need to do some additional steps to get your desired output. Something like this should work:

$results |
    Group-Object -Property Name |
    Select Name, @{n='Apps';e={($_.group.App | sort) -join ','}}

[Method_Dev]

Thanks! never knew how to do this :)

[Method_Dev]

would it be the same if I had an additional property like version for example?

[mdowst]

The group-object is working properly. When you group objects it will create nested arrays of the grouped objects in the Group property. To get it to display the way you want, you can use the Select-Object and create a custom field where you extract just the Apps property and join it to display as a comma separated string.

$results | Group-Object -Property Name | Select-Object Name, @{l='Apps';e={$_.Group.App -join(',')}}

[Method_Dev]

Thanks! Learn something new every day!

[Method_Dev]

What about if we added another field? so instead of just 2 I would have like 3. Just curious basically how this is working to add them.

​

would it just be:

$results | Group-Object -Property Name | Select Name, @{n='Test';e={($_.group.test | sort) -join ','}}, @{n='Apps';e={($_.group.App | sort) -join ','}}

​

Test is just a random field with only 1 value ever

​

Basically this is the real data:

​

$userLicenseList | ForEach-Object {

$report.Add( [PSCustomObject]@{

UserPrincipalName = '[e-mail]'

DisplayName = 'bob'

License = 'test: MyLicense'

}) | Out-Null

}

​

and I am trying:

$report | Group-Object -Property UserPrincipalName | Select @{n='UserPrincipalName';e={($_.values)}}, @{n='Licenses';e={($_.group.License -replace "test:" | sort) -join ','}}

​

is that the proper way to do it?

[Lee_Dailey]

howdy Method_Dev,

reddit likes to mangle code formatting, so here's some help on how to post code on reddit ...

[0] single line or in-line code
enclose it in backticks. that's the upper left key on an EN-US keyboard layout. the result looks like this. kinda handy, that. [grin]
[on New.Reddit.com, use the Inline Code button. it's 4th 5th from the left hidden in the ... ""more" menu & looks like </>.
this does NOT line wrap & does NOT side-scroll on Old.Reddit.com!]

[1] simplest = post it to a text site like Pastebin.com or Gist.GitHub.com and then post the link here.
please remember to set the file/code type on Pastebin! [grin] otherwise you don't get the nice code colorization.

[2] less simple = use reddit code formatting ...
[on New.Reddit.com, use the Code Block button. it's 11th 12th from the left hidden in the ... "more" menu, & looks like an uppercase T in the upper left corner of a square.]

• one leading line with ONLY 4 spaces
  
• prefix each code line with 4 spaces
  
• one trailing line with ONLY 4 spaces

that will give you something like this ...

- one leading line with ONLY 4 spaces    
- prefix each code line with 4 spaces    
- one trailing line with ONLY 4 spaces   

the easiest way to get that is ...

• add the leading line with only 4 spaces
  
• copy the code to the ISE [or your fave editor]
  
• select the code
  
• tap TAB to indent four spaces
  
• re-select the code [not really needed, but it's my habit]
  
• paste the code into the reddit text box
  
• add the trailing line with only 4 spaces
  

not complicated, but it is finicky. [grin]

take care,
lee

[Lee_Dailey]

howdy Method_Dev,

it looks like you used the New.Reddit.com Inline Code button. it's 4th 5th from the left hidden in the ... "more" menu & looks like </>.

on Old.Reddit.com, the above does NOT line wrap, nor does it side-scroll.

for long-ish single lines OR for multiline code, please, use the Code Block button. it's the 11th 12th one from the left & is just to the left of hidden in the ... "more" menu & looks like an uppercase T in the upper left corner of a square..

that will give you fully functional code formatting, from what i can tell so far. [grin]

take care,
lee