Split array into separate objects based on unique attributes

Question

I have an array that I'm populating by some other means. It essentially contains this sample data;

PSComputerName              ResourceName   InstanceName       InDesiredState ConfigurationName StartDate          
--------------              ------------   ------------       -------------- ----------------- ---------          
server1.domain.local WindowsFeature Backup             True           BaseConfig        24/04/2018 14:31:23
server1.domain.local Registry       fDenyTSConnections True           BaseConfig        24/04/2018 14:31:23
server1.domain.local Registry       UserAuthentication True           BaseConfig        24/04/2018 14:31:23
server1.domain.local File           DscDemo            True           BaseConfig        24/04/2018 14:31:23
server5.domain.local WindowsFeature Backup             True           BaseConfig        24/04/2018 14:31:23
server5.domain.local Registry       fDenyTSConnections True           BaseConfig        24/04/2018 14:31:24
server5.domain.local Registry       UserAuthentication True           BaseConfig        24/04/2018 14:31:24

This is dynamic, and I'll have no idea when the array is populated what data will be inside. I need to split the array, into unique arrays (or PSObjects) based on the PSComputerName.

So in this case, I'd need to end up with two seperate objects/arrays for server1 and server5, bearing in mind there could be 6 servers or 80 servers. I can't think of the best way to approach this.

Matt · Accepted Answer · 2018-04-24 13:44:33Z

4

Why not just group the data and work on each group individually? Assuming $objects contains the data in the question

$objects | Group-Object pscomputername | Foreach-object{
    $_.Group
}

Each $_.Group will be a collection of entries associated to a unique computer. $_.Name would be the pscomputername of the current grouped item.

So you might need to have another inner loop to iterate of those results as well.

answered Apr 24, 2018 at 13:44

Matt

47.1k9 gold badges90 silver badges125 bronze badges

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

Comments

PnP · Accepted Answer · 2018-04-24 13:40:02Z

0

Ignore, not sure why I was banging my head against a wall.

$Servers = $CSV.PSComputerName | select -Unique

ForEach($server in $Servers){

    $arr = $CSV | Where-Object {$_.PSComputerName -eq $server}

    Write-Host "Compliancy for $Server"
    $arr
    Write-Host "End compliancy for $server"

}

answered Apr 24, 2018 at 13:40

PnP

3,20520 gold badges70 silver badges100 bronze badges

Comments

henrycarteruk · Accepted Answer · 2018-04-24 14:19:54Z

0

group-object. See "Example 4: Group event log events by ID"

edited Apr 24, 2018 at 14:19

henrycarteruk

13.3k2 gold badges40 silver badges40 bronze badges

answered Apr 24, 2018 at 13:40

mazzy

1,1231 gold badge13 silver badges26 bronze badges

Collectives™ on Stack Overflow

Split array into separate objects based on unique attributes

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related