Powershell Import-CSV and Foreach-Object, excluding with the CSV header

Question

I'm trying to get the SAMAccountNames of one domain and compare them with their equals from another domain.

To get all users of dc1 I use:

Get-ADUser -Filter * -SearchBase $SearchBase | Select-Object SamAccountName |
    Export-Csv -path $exports -encoding "unicode" -notype

and then I import the csv again and try to compare them for any differences

$readthat = Import-CSV $exports -Header SamAccountName | ForEach-Object {
  $user1 = Get-ADUser -Identity $_.SamAccountName -Properties $attributes
  $user2 = Get-ADUser -Identity $_.SamAccountName -Properties $attributes -Server $dc2

  $modified = @{}
  $attributes | Where-Object { $user1.$_ -ne $user2.$_ } | ForEach-Object {
    $modified[$_] = $user2.$_
  }
}

All that works great, except that it's also trying to find the SamAccountName which of course genereates an error because the SamAccountName = SamAccountName doesn't exit.

Any hints on how to avoid this or do you guys have a more elegant solution?

the .csv looks like this:

"SamAccountName"
"foo"
"bar"

Hunter Eidson · Accepted Answer · 2014-12-04 05:31:04Z

4

Don't use the -Header SamAccountName option on your import-csv should help immensely. The -Header option is for when the CSV file you are importing doesn't have a header. The Export-CSV cmdlet puts the header in there for you, so you don't have to.

answered Dec 4, 2014 at 5:31

Hunter Eidson

1,91914 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

StUffz Over a year ago

must have missed that part when reading into the import/export function. thanks

Collectives™ on Stack Overflow

Powershell Import-CSV and Foreach-Object, excluding with the CSV header

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related