Improve company productivity with a Business Account.Sign Up

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

AD

is there a way to eport all users in AD 2003 on to a spread sheet
0
happyexchange
Asked:
happyexchange
1 Solution
 
LeDaoukCommented:
0
 
dmf415Commented:
Within Active directory users and computers
right click on the Users folder and choose export list.
Choose .csv
from there you can copy paste or do whatever to put this list in excel.
0
 
Mike KlineCommented:
The users folder may not contain all his users; there are great third party tools like powerhsell and adfind that can do this

For example using adfind http://joeware.net/freetools/tools/adfind/index.htm

adfind -default -f "&(objectcategory=person)(objectclass=user)" samaccountname displayname -csv > c:\users.csv

I only selected a few attributes to export there

If you want something quick and built in use csvde   http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Export.htm#Example 2: Filter with the -r switch

Thanks

Mike
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

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