Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Export Details from Active Directory 2003 to an excel file

Posted on 2009-04-06
3
Medium Priority
?
406 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 2000 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

We have adopted the strategy to use Computers in Student Labs as the bulletin boards. The same target can be achieved by using a Login Notice feature in Group policy but it’s not as attractive as graphical wallpapers with message which grabs the att…
It is only natural that we all want our PCs to be in good working order, improved system performance, so that is exactly how programs are advertised to entice. They say things like:            •      PC crashes? Get registry cleaner to repair it!    …
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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

722 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