Solved

Export Details from Active Directory 2003 to an excel file

Posted on 2009-04-06
3
397 Views
Last Modified: 2012-05-06
Hi,

I need to export details from A.D to an excel file. Basically, it needs to be email address, job title and name? Is there anyway that this can be done without having to buy 3rd party softyware(free is poss).

Cheers
0
Comment
Question by:LCMaurice
  • 2
3 Comments
 
LVL 9

Expert Comment

by:SirtenKen
ID: 24078886
You can use CSVDE from a server:
http://technet.microsoft.com/en-us/library/cc787549.aspx

or install ADAM on your XP workstation
0
 
LVL 9

Accepted Solution

by:
SirtenKen earned 500 total points
ID: 24079033
The default usage of this command exports information into comma delimited format with the filename you specify after the -f option.
the -L option is the list of attributes you would like to get. You can specify a -R option to set the restrictions, if you want to limit results to just user objects.
csvde -L mail,title,sn,givenName -R (objectClass=user) -f AD_details.csv

if you only want active users, try this
csvde -L mail,title,sn,givenName -R (&(objectClass=user)(!useraccountcontrol:1.2.840.113556.1.4.803:=2)) -f AD_details_active_accounts_only.csv

The user account control line is an attribute that is broken down into bits, so this is how the LDAP query must be formatted to access special information, such as whether the user is not disabled.
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Hyper V vm 4 132
Compatiable modem 2 54
Exchange & AD management console 2 100
Can’t delete a file 14 161
Ok I have been working on this for some time having learned and gained certification in XenDesktop 4 along came version 5 which was released last month. Since then I have been working to deploy XenDesktop 5 in a small environment with only 2 virt…
Step by step guide to Clean and Sort your windows registry! Introduction: Always remember: A Clean registry = Better performance = Save your invaluable time In this article we're going to clear our registry manually! Yes, manually! The e…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

815 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now