?
Solved

export active directory

Posted on 2004-09-29
4
Medium Priority
?
398 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
[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
  • 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 375 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

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

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

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…
In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses
Course of the Month13 days, 9 hours left to enroll

800 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