i want to compare two CSV files both having AD Users. e.g
csv1 contains all users about 3000
csv2 contains about 600
i want a csv3 that contains CSV1 - CSV2
i want to compare two CSV files both having AD Users. e.g
csv1 contains all users about 3000
csv2 contains about 600
i want a csv3 that contains CSV1 - CSV2
use compare-object cmdlet. If you need help or examples use help compare-object -examples, or -full. Remember to get the content of the CSV files.
# Export results excluding entries contained in both csv files $ref = Import-Csv .\adusers1.csv $dif = Import-Csv .\adusers2.csv Compare-Object -ReferenceObject $ref -DifferenceObject $dif | select -ExpandProperty inputobject | export-csv .\adusers3.csv -NoTypeInformation