[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 402
  • Last Modified:

export active directory

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
mr_oracle
Asked:
mr_oracle
  • 2
  • 2
1 Solution
 
alimuCommented:
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
 
mr_oracleAuthor Commented:
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
 
mr_oracleAuthor Commented:
????
0
 
alimuCommented:
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now