Get ADuser from csv email address

[petben]

Hello, in PowerShell I want to import a csv, e.g.:

 

name, email

james,

[email protected]

mark,

[email protected]

 

then from the imported .csv 'email' field I want to get the corresponding AD users

 

 

can someone please help?

[howartp]

$csvFile = "n:\csv.csv"
$csv = Import-Csv $csvFile

foreach ($line in $csv)
{
   $name = $line.name
   $email = $line.email

   Get-ADUser -filter 'mail -eq $email'
}

[petben]

thanks, why do you need the $name = $line.name?

[howartp]

You don't.

 

I'm assuming you will be developing the code further to "do" something else, so I made it easier to have the name and email in variables ready for using.

[DaveTheTech]

This will call get-aduser each time.

It would be better to get all of your users. Limiting the results where you can, then filter the results against the spreadsheet.

Something similar to this:

$adUsers = get-aduser -SearchBase "OU=Staff, OU=Users, DC=domain, DC=com" -Filter {enabled -eq $true}
$csv = import-csv file.csv
$adUsers.where({$_.UserPrincipalName -like $csv.UPN})

[howartp]

I knew someone would say that

 

I make scripts up as I go along so I'd have been doing

 

$allusers = get-aduser
for (line in csv)
{
 for user in $allusers
 {
 }
}

which I wouldn't have been proud of.

 

It depends if he has more $csvlines or more $users.

[petben]

why does this return nothing for $ADUsersfromCSV?

 

$ADUsers = get-aduser -SearchBase "OU=Students,DC=school,DC=com" -Filter {enabled -eq $true}

$CSVUsers = Import-Csv 'D:\User_Export.csv'

$ADUsersfromCSV = $ADUsers | where {$_.UserPrincipalName -like $CSVUsers.Email}

[howartp]

Are your UserPrincipalName's actually email addresses?

 

Ours are [email protected]al, not [email protected]

 

Also I presume you've intentionally anonymised the SearchBase to "OU=Students,DC=school,DC=com" - if not, that needs changing to your actual AD path.

[petben]

I changed the AD path yes,

 

$ADUsers:

returns lots of users.

 

UserPrincipalName is indeed an email address in the form external domain

 

$CSVUsers:

First Last Email

----- ---- -----

Jay Brown [email protected]

Mark Aman [email protected]

 

 

Thanks