Welcome › Forums › General PowerShell Q&A › Compare two Excel sheet having AD Users
This topic contains 2 replies, has 3 voices, and was last updated by
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
The topic ‘Compare two Excel sheet having AD Users’ is closed to new replies.