Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Need to export data from AD to Excel

Posted on 2006-05-08
Medium Priority
Last Modified: 2010-08-05
I need to be able to export user data from AD into Excel.  Specifically, I need the account ID, user name, and email address.  Can anyone tell me how to do this?  If I can't go directly to Excel, a csv file would be ok.

Question by:afytech1
LVL 88

Accepted Solution

rindi earned 1000 total points
ID: 16633397
use the commandline tool ldifde to export AD data to a text file, and then import that into excel. With ldifde /? you get the syntax

Author Comment

ID: 16633529
Can you tell me what the attribute for the user's email address is?  I can't seem to find that.  

And one final thing....how can I only export users that have an email address?  ie ignore all users where no email address is found.

LVL 10

Assisted Solution

by:Walter Padrón
Walter Padrón earned 1000 total points
ID: 16633650
Hi afytech1,

Not as powerfull as ldifde but you can use the Saved Queries under Active Directory User & Computers, it lets export to csv and have a graphical interface. Create a new query and on the "Exchange Recipients" custom query select the mail enabled users.


Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

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

NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
Dropbox has a relatively new feature called Smart Sync.  This feature allows Dropbox Professional (not plus) and Dropbox Business (if enabled) users to store information in Dropbox WITHOUT storing any files on their computer.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

571 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