Solved

export active directory

Posted on 2004-09-29
4
392 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
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 is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

943 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

5 Experts available now in Live!

Get 1:1 Help Now