Solved

export active directory

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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

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…
February 24, 2017 — On February 23, Travis Ormandy, a vulnerability researcher at Google, reported on Twitter (https://twitter.com/taviso/status/834900838837411840) that massive stores of data have been leaked by CloudFlare, a company that provide…
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…

773 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