Solved

export active directory

Posted on 2004-09-29
4
391 Views
Last Modified: 2012-06-22
hi guys

how can i  export the actice directory users and computers  with thier email addresess

 i tried to do that with CSVDE   command but i did not succeed :(

is their any free tool to do that ???
or please  advise for the best way

  sorry but english is not my fist language

thanks
0
Comment
Question by:mr_oracle
  • 2
  • 2
4 Comments
 
LVL 14

Expert Comment

by:alimu
ID: 12185852
What error are you getting?

other ways to export? - only CSVDE and LDIFDE that I know of.

This is a simple example but should do it.  you'll need to be a domain admin.  csvde.exe should be located in windows\system32 directory of windows 2000 servers if you are having trouble finding it.

CSVDE -f users.csv -r "(&(objectClass=user))"
CSVDE -f computers.csv -r "(&(objectClass=computer))"

note that -f will export all fields for each object.
you can remove unwanted fields by importing into something like excel.

You can use LDIFDE as well but csvde gives you a csv file and makes the results easier to manipulate.
How to use LDIFDE:
http://www.microsoft.com/technet/prodtechnol/windows2000serv/technologies/activedirectory/howto/bulkstep.mspx
0
 

Author Comment

by:mr_oracle
ID: 12191449
thanks alot sir

 but i want to export all the computers and users at once

with their OUs  is that possible??
please give me the iinstructions   thanks alot
0
 

Author Comment

by:mr_oracle
ID: 12210867
????
0
 
LVL 14

Accepted Solution

by:
alimu earned 125 total points
ID: 12213759
wouldn't go around calling people "sir" in here.  I might be a madam. :)

before you run this, make sure you've got enough space for the comma separated value file exported (mine was about 90MB for the filtered command below).

complete list of everything in AD:
CSVDE -f full.csv

Filtered list of your active directory containing only user and computer objects. exports all fields for each object .
CSVDE -f filtered.csv -r "(|(objectClass=user)(objectClass=computer))"

-r denotes a filter is being used, actual filter is the LDAP query between " "
& (ampersand) denotes an AND-ing statement.
| (pipe) denotes an OR-ing statement.

If you want to filter it further so you are only pulling out particular OUs and/or particular fields, this is a link that has a description of the syntax available for csvde http://www.ss64.com/nt/csvde.html
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Cannot access port 443 4 573
Visual C++ Runtime Error on Windows 2000 Server 2 1,442
Group Policy 9 556
VSS on host & VM 10 391
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…
This article explains how to prepare an HTML email signature template file containing dynamic placeholders for users' Azure AD data. Furthermore, it explains how to use this file to remotely set up a department-wide email signature policy in Office …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

758 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

23 Experts available now in Live!

Get 1:1 Help Now