Solved

Export Details from Active Directory 2003 to an excel file

Posted on 2009-04-06
3
403 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
[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
  • 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

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…
Sometimes people don't understand why download speed shows differently for Windows than Linux.Specially, this article covers and shows the solution for throughput difference for Windows than a Linux machine. For this, I arranged a test scenario.I…
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…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

624 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