Here's my issue.

I have one csv that has all the users logon info, first name, last name, CN, email address and samaccountname. There are over 4000 records in this csv.

I have another csv that has users first name and lasr name, employee id, dept number, employeetype. There are over 250 records in this csv.

I have to compare these two csvs and export to another csv the matches with all the fields in both csvs.

I looked at the compare cmdlet, but did not find a way to get the result i needed.

Any help willl be much appreciated.

Thank you.

Firoz

Hi

There must better/efficient way to get what you want... here's what I came up with so far:


$csv1 = import-csv D:\Scripts\temp\logonInfo1.csv
$csv2 = import-csv D:\Scripts\temp\logonInfo2.csv

$result1 = $(compare-object $csv1 $csv2 -IncludeEqual | where {$_.SideIndicator -eq "=="} | foreach {$_.InputObject})
$result2 = $(compare-object $csv2 $csv1 -IncludeEqual | where {$_.SideIndicator -eq "=="} | foreach {$_.InputObject})

$members1 = $csv1 | gm -mem  NoteProperty |  foreach {$_.name}
$members2 = $csv2 | gm -mem  NoteProperty |  foreach {$_.name}

$newMembers = $(compare-object $members1 $members2 | where {$_.SideIndicator -eq "=>"}  | foreach {$_.InputObject})

for($i=0; $i -lt $newMembers.length; $i++){
 $prop = $newMembers[$i]
 $result1 | add-member noteproperty $prop $null
 
 for($x=0; $x -lt $result1.length; $x++){
  $newMembers | foreach {
   $result1[$x].$prop = $result2[$x].$prop
  }
 }

}

$result1 | export-csv D:\Scripts\temp\new.csv -NoTypeInformation
get-content D:\Scripts\temp\new.csv


# and here's the output

firstName,lastName,CN,emailAddress,samaccountname,deptNumber,employeeId,employeeType
test,test,"cn=test,ou=users,dc=domain,dc=com",test@domain.com,test,345,123,10
test1,test1,"cn=test1,ou=users,dc=domain,dc=com",test1@domain.com,test1,456,234,11
test2,test2,"cn=test2,ou=users,dc=domain,dc=com",test2@domain.com,test2,567,345,12



Remember to take into count the -syncWindow as Dmitry's suggested, this is just a small test on small csv files.

Hope this helps


---
Shay Levy
$cript Fanatic
http://scriptolog.blogspot.com