?
Solved

Pull User info from Exchange Server or Active Directory

Posted on 2014-09-04
7
Medium Priority
?
302 Views
Last Modified: 2014-09-04
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?
0
Comment
Question by:snyperj
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 9

Expert Comment

by:MHMAdmins
ID: 40304464
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
 
LVL 3

Expert Comment

by:Brandon
ID: 40304466
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
 

Author Comment

by:snyperj
ID: 40304497
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
Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 
LVL 3

Expert Comment

by:Brandon
ID: 40304634
Close the PowerShell window, right click it and open as Admin.

Does that work?
0
 
LVL 3

Accepted Solution

by:
Brandon earned 2000 total points
ID: 40304645
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
 

Author Closing Comment

by:snyperj
ID: 40304653
thanks
0
 
LVL 3

Expert Comment

by:Brandon
ID: 40304667
No problem. Just had to do this a few weeks ago for a client.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Had a business requirement to store the mobile number in an environmental variable. This is just a quick article on how this was done.
Compliance and data security require steps be taken to prevent unauthorized users from copying data.  Here's one method to prevent data theft via USB drives (and writable optical media).
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…
Suggested Courses
Course of the Month13 days, 17 hours left to enroll

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question