Solved

Export Details from Active Directory 2003 to an excel file

Posted on 2009-04-06
3
393 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
windows 10 install 6 101
How to fix BSOD 21 146
XP won't boot 27 134
Creating an XP virtual machine 38 166
If your system is showing symptoms of browser hijacks or 'google search redirects' check out my other article (http://rdsrc.us/u3GP7A) first and run the tool TDSSKiller (http://rdsrc.us/GDBBs4) to get rid of the infection. Once done, and if the …
cPanel is a Unix based web hosting control panel that provides a graphical interface and automation tools designed to simplify the process of hosting a web site. cPanel utilizes a 3 tier structure that provides functionality for administrators, rese…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

920 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

14 Experts available now in Live!

Get 1:1 Help Now