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?
snyperjAsked:
Who is Participating?
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.

MHMAdminsCommented:
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/
0
BrandonProject Manager, IT Systems and Software DesignCommented:
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.
0
snyperjAuthor Commented:
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
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

BrandonProject Manager, IT Systems and Software DesignCommented:
Close the PowerShell window, right click it and open as Admin.

Does that work?
0
BrandonProject Manager, IT Systems and Software DesignCommented:
You also need to have the AD module active.
Check to see if it is by running this command.
get-module activedirectory -listavailable

If it's not present here is a link to install it.

http://blogs.technet.com/b/heyscriptingguy/archive/2011/08/30/install-active-directory-management-service-for-easy-powershell-access.aspx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
snyperjAuthor Commented:
thanks
0
BrandonProject Manager, IT Systems and Software DesignCommented:
No problem. Just had to do this a few weeks ago for a client.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.