Link to home
Start Free TrialLog in
Avatar of snyperj
snyperjFlag for United States of America

asked on

Pull User info from Exchange Server or Active Directory

How can I export the following info from Exchange 2010 into excel
First Name
Last Name
Business Phone
Fax Nbr
Mobile Phone
Email addiress

for every active user?
Avatar of MHMAdmins
MHMAdmins
Flag of United States of America image

Personally I use PowerGUI which is a free download and it will allow you to choose what to export. http://www.quest.com/powergui-freeware/
You need to use powershell from Exchange. here are some commands that dump all kinds of info, you can sort and delete what you do/don't need.

Get-ADObject -filter 'objectclass -eq "user"' -properties * | select | export-csv -NoTypeInformation "c:\ADUsers.csv"

It saves a csv file to the C drive called ADUSERS.csv.
Avatar of snyperj

ASKER

The term 'Get-ADObject' is not recognized as the name of a cmdlet, function, script file, or operable program. Check the spelling of the name, or if a path was included, verify that the path is correct and try again.
At line:1 char:13
+ Get-ADObject <<<<  -filter 'objectclass -eq "user"' -properties * | select | export-csv -NoTypeInformation "c:\ADUser
s.csv"
    + CategoryInfo          : ObjectNotFound: (Get-ADObject:String) [], CommandNotFoundException
    + FullyQualifiedErrorId : CommandNotFoundException
Close the PowerShell window, right click it and open as Admin.

Does that work?
ASKER CERTIFIED SOLUTION
Avatar of Brandon
Brandon
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of snyperj

ASKER

thanks
No problem. Just had to do this a few weeks ago for a client.