• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • 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

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

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