Export AD UPN and SamAccount Name

Question

Hi All

i have email addresses in csv file, my csv file is in below format. How can i export samaccountname, UPN by importing the email addresses.

user
user1@Company portal .com
user2@Company portal .com

When i try the below syntax i am getting error

foreach($user in (get-content C:\temp\input.csv){
get-aduser -filter {emailaddress -eq $user} |select -property displayname, samaccountname,UserPrincipalName, emailaddress |
Export-Csv C:\temp\output.csv -NoTypeInformation
}

Answer 1

Hi,

Please check to see if this works.

$input = "C:\temp\input.csv"  
$output = "C:\temp\output.csv "  
Import-Csv -Path $input | ForEach-Object {  
    $mail = $_.user  
    Get-ADUser -Filter {EmailAddress -eq $mail} -Properties DisplayName, EmailAddress |   
        Select-Object -Property DisplayName, SamAccountName,UserPrincipalName, EmailAddress  
} | Export-Csv -Path $output -NoTypeInformation  

Best Regards,
Ian Xue

============================================

If the Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi,

It is not working getting an error as mail is not valid one

Regards
Muthu

Answer 3

i am looking for where if i given sam account name need the upn id
input the samaccount ame and ran the above script getting the error as below
Get-ADUser : Variable: 'mail' found in expression: $mail is not defined.

not sure where ii am wrong
thanks
Muthu

Answer 4

Assuming your CSV contains a column named "samaccountname" you won't need the "-Filter" because the CSV's samaccountname can be used as the value for the Get-ADUser "-Identity" parameter:

$in = "C:\temp\input.csv"  
$out = "C:\temp\output.csv "  
Import-Csv -Path $in |   
    ForEach-Object {  
        Get-ADUser -Identity $_.samaccountname -Properties DisplayName, EmailAddress |   
            Select-Object -Property DisplayName, SamAccountName, UserPrincipalName, EmailAddress  
    } | Export-Csv -Path $out -NoTypeInformation  

Answer 5

Thanks a lot you saved my day .