Forum Discussion

Skipster311-1's avatar
Skipster311-1
Iron Contributor
Aug 27, 2021
Solved

Compare two csv files

Hello

 

I am trying to get an idea of devices that have not enrolled in Intune, but are accessing exchange online. I am using two .csv files. The intune file contains all devices that have enrolled in intune and the Exchange file contains all devices that are currently found in Exchange online. I want to compare the two files and export the differences to another .csv file. The two files share a common attribute "deviceid" 

Thank you in advance for any guidance 

 

$Intune = import-csv .\intune.csv | Group-Object -AsHashTable -AsString -Property 'DeviceID'
$Exchange = import-csv .\mobiledevicereport.csv | Group-Object -AsHashTable -AsString -Property 'DeviceID'

Azure Automation
microsoft intune
Mobile Device Management
Windows PowerShell
  • pvanberlo's avatar
    pvanberlo
    Aug 27, 2021

    Skipster311-1 Give this a try. It'll output two files, one containing the devices that are only in the Intune file, and the other with devices that only exist in the Exchange file.

     

    $Intune = Import-CSV .\intune.csv | Group-Object -AsHashTable -AsString -Property 'DeviceID'
$Exchange = Import-CSV .\mobiledevicereport.csv | Group-Object -AsHashTable -AsString -Property 'DeviceID'

$OnlyInIntune = @()
$OnlyInExchange = @()

ForEach ($Device in $Intune.Values) {
    if (!$Exchange[$Device.DeviceID]) {
        $OnlyInIntune += $Device
    }
}

ForEach ($Device in $Exchange.Values) {
    if (!$Intune[$Device.DeviceID]) {
        $OnlyInExchange += $Device
    }
}

$OnlyInIntune | Export-CSV -NoTypeInformation DevicesOnlyInIntune.csv
$OnlyInExchange | Export-CSV -NoTypeInformation DevicesOnlyInExchange.csv
  • pvanberlo's avatar
    pvanberlo
    Steel Contributor
    Aug 27, 2021

    Skipster311-1 Give this a try. It'll output two files, one containing the devices that are only in the Intune file, and the other with devices that only exist in the Exchange file.

     

    $Intune = Import-CSV .\intune.csv | Group-Object -AsHashTable -AsString -Property 'DeviceID'
$Exchange = Import-CSV .\mobiledevicereport.csv | Group-Object -AsHashTable -AsString -Property 'DeviceID'

$OnlyInIntune = @()
$OnlyInExchange = @()

ForEach ($Device in $Intune.Values) {
    if (!$Exchange[$Device.DeviceID]) {
        $OnlyInIntune += $Device
    }
}

ForEach ($Device in $Exchange.Values) {
    if (!$Intune[$Device.DeviceID]) {
        $OnlyInExchange += $Device
    }
}

$OnlyInIntune | Export-CSV -NoTypeInformation DevicesOnlyInIntune.csv
$OnlyInExchange | Export-CSV -NoTypeInformation DevicesOnlyInExchange.csv

Resources