# Exporting users and email addresses

I need to query AD to show the user and the users email address.  How can I accomplish this?
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Director of OperationsCommented:
Just an FYI, if you add in the scripting language those Experts will be able to see your question easier.

Get-ADUser -Filter * -Properties EmailAddress | Select-Object Name,EmailAddress

0
Author Commented:
Powershell?  Can this be set to export to CSV or XLSX? For the filter put in the OU?
0
Director of OperationsCommented:
Yes-- Powershell is incredibly powerful for AD management.  Edit the -Path to where you want the file to export.
Get-ADUser -Filter * -Properties EmailAddress | Select-Object Name,EmailAddress | Export-Csv -Path "C:\path\to\export\users.csv" -NoTypeInformation

0
Author Commented:
That worked however, I'm in a huge domain with an OU that is mine  Can I add the DN so I don't get the entire list of users?  Or even better the user name begins with wrm if I can user that.
0
Director of OperationsCommented:
In the -Filter section you can specify criteria.
Get-ADUser -Filter {SamAccountName -like "wrm*"} -Properties EmailAddress | Select-Object Name,EmailAddress | Export-Csv -Path "C:\path\to\export\users.csv" -NoTypeInformation


If you want to get all users from a specific location, use -SearchBase
Get-ADUser -SearchBase "OU=Test,DC=domain,DC=local" -Filter * -Properties EmailAddress | Select-Object Name,EmailAddress | Export-Csv -Path "C:\path\to\export\users.csv" -NoTypeInformation


Just edit the DN for the starting location.  Or you can use the first one.
0

Experts Exchange Solution brought to you by