• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 785
  • Last Modified:

Exporting user names and mail address from windows 2008 AD/exchange 2007 to Excel

Hi

We use windows 2008 AD and Exchange 2007. We have around 200 users. I want to export Full names and email address of all these users to  excel.Any ideas will be helpful.

Thanks
0
lianne143
Asked:
lianne143
4 Solutions
 
SteveIT ManagerCommented:
Step by step - http://rdsrc.us/H8OUzZ
0
 
SteveIT ManagerCommented:
0
 
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
0
 
helpfinderCommented:
you can use some powershell script, this is more complex you are asking, but should contain all fields you are asking (and more). You have to have Quest powershell cmd-lets installed

# PowerShell cmdlet to export active directory into a csv file
$FilePath = "c:\folder\people.csv"
$OuDomain = "OU=xxx,OU=xx,DC=domain,DC=local"
Get-QADUser -searchRoot $OuDomain | Export-Csv $FilePath

Open in new window

0
 
Mike KlineCommented:
There are other great command line ways including adfind and the dstools, let us know if you want more info.

If you prefer a GUI then try the free adinfo tool   http://www.cjwdev.co.uk/Software/ADReportingTool/Info.html

Thanks

Mike
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now