Extract Users From One Particular OU

  • Thread starter Thread starter Diane Walker
  • Start date Start date
D

Diane Walker

We are running Windows 2003 Standard Edition server. We would like to
retrieve all the users in one particular OU in Active Directory. Is there a
utility that we can use?

Thank you.

Diane
 
Diane Walker said:
We are running Windows 2003 Standard Edition server. We would like to
retrieve all the users in one particular OU in Active Directory. Is there
a utility that we can use?
Click to expand...

DSQuery (command line)

AD Users and Computers: Saved Queries

What specifically do you mean by "Extract"? These tools will get you
the users (etc) listed.

You might also consider LDAPDE.exe or CSVDE.exe for bulk
export/import.

Custom scripts work too of course.
 
You could use adfind from www.joeware.net. It is a great free tool. The
command below will output the users to the file employees.csv with the
samaccountname, e-mail address and Display name. Fields output are defined
by the script writer.

adfind -f "(&(objectclass=user)(objectcategory=person))" -b
"ou=employees,ou=users,dc=mydomain,dc=com" -csv -nodn samaccountname mail
displayName > c:\employees.csv


--
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT

http://www.pbbergs.com

Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Herb Martin said:
DSQuery (command line)

AD Users and Computers: Saved Queries

What specifically do you mean by "Extract"? These tools will get you
the users (etc) listed.

You might also consider LDAPDE.exe or CSVDE.exe for bulk
export/import.

Custom scripts work too of course.
Click to expand...

Another command line utility that can output information on users is Joe
Richards' free adfind:

http://www.joeware.net/win/free/tools/adfind.htm

With all of these you can specify the OU as the base of the search. You
select which attribute values to retrieve.
 
Thanks for your response. Sorry for not making my question clear. What I
mean by "extract" is to get a list.

Thanks.

Diane
 
Paul,

Thank you very much for the information and the example. Your example
works. You have made it easy for me. Is there a way to find all the names
of the attributes such as Office, Department, Company, Telephone Number,
Account Expires, etc.? These fields are in Active Directory for Users and
Computers.

Thanks.

Diane
 
Diane Walker said:
Thanks for your response. Sorry for not making my question clear. What I
mean by "extract" is to get a list.
Click to expand...

Then tools like DSQuery can be all you need.

The bulk export/import tools are more for getting all the properties etc.

Joe's ADFind (mentioned by others) is useful to know in any case.
 
I am writing an update to one of my scripts and usually I run into the
Schema snapin to look up new attributes. Your spreadsheet is very nice!
This is a nice posting of information.

--
Paul Bergson
MVP - Directory Services
MCT, MCSE, MCSA, Security+, BS CSci
2003, 2000 (Early Achiever), NT

http://www.pbbergs.com

Please no e-mails, any questions should be posted in the NewsGroup
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Thank you very much all of you for the valuable information. Your
assistance is greatly appreciated. Richard, your documentation for AD
attributes is GREAT!!!

Thanks again all for everything.

Diane
 
Back
Top