So what I am attemping to do is filter some data through a csv from a csv and when it goes through it searches the column and give me all the values that have a matching value in the 2nd CSV from the 1st one. However the values its giving are the groups when in fact I need the devices that are in the groups. So kinda like a group of object inside of an object.

$Date = $(Get-Date -f MM_dd_yyyy)
$azuregroupdata = import-csv -Path "\\iPadIntuneMDM\CSV\$Date-AzureGroupsdata.csv"
 


$resultdata = import-csv -Path "\\iPadIntuneMDM\CSV\$Date-MatchinDevices.csv"
$groupsinboth = (Compare-Object -ReferenceObject ($resultdata.NewGroup) -DifferenceObject ($azuregroupdata.DisplayName) -IncludeEqual | `
        Where-Object { $_.SideIndicator -eq "==" } | `
        Select-Object -ExpandProperty InputObject) 


$results2 = ForEach ($Group in $groupsinboth) {
    
    $A2 = $resultdata | Where-Object { $_.NewGroup -eq $Group }
    $I2 = $azuregroupdata | Where-Object { $_.DisplayName -eq $Group }
    New-Object -TypeName psobject -Property @{
        "Serial"          = $A2.Serial
        "ObjectID"        = $A2.ObjectID
        "AzureADGroupID" = $I2.ObjectId
    }
}
Write-Host $results2
$results2 | Export-CSV -NoTypeInformation -Path \\iPadIntuneMDM\CSV\$(Get-Date -f MM_dd_yyyy)-DevicesandgroupIDs.csv

In the CSVs I have the following data

AzureGroupsData

ResultData

Output $results2

CodePudding user response：

The Object[] in the result CSV means that there are multiple values found per DisplayName (i.e.: iPad-PER-Students-ML03 has multiple appearances in the big CSV) hence why there are multiple serials and multiple objectIDs. This would require 2 nested loops to unroll all the data:

1. An outer loop to enumerate all rows of the Azure Groups CSV.
2. And, an inner loop to enumerate all rows of the Big CSV per appearance of DisplayName / NewGroup.

$azureGroups = Import-Csv 'this\is\theAZUREGROUPS.csv'
$bigCsvHash = Import-Csv 'this\is\theBIGcsv.csv' |
    Group-Object NewGroup -AsHashTable -AsString

$result = foreach($i in $azureGroups) {
    foreach($z in $bigCsvHash[$i.DisplayName]) {
        [pscustomobject]@{
            Serial         = $z.Serial
            ObjectID       = $z.ObjectId
            AzureADGroupID = $i.ObjectId
        }
    }
}

$result | Export-Csv ....