?
Solved

AD

Posted on 2011-03-16
3
Medium Priority
?
209 Views
Last Modified: 2012-05-11
is there a way to eport all users in AD 2003 on to a spread sheet
0
Comment
Question by:happyexchange
[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
3 Comments
 
LVL 4

Expert Comment

by:LeDaouk
ID: 35148940
0
 
LVL 3

Expert Comment

by:dmf415
ID: 35149115
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
 
LVL 57

Accepted Solution

by:
Mike Kline earned 2000 total points
ID: 35149277
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

Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Had a business requirement to store the mobile number in an environmental variable. This is just a quick article on how this was done.
Let's recap what we learned from yesterday's Skyport Systems webinar.
This video shows how to use Hyena, from SystemTools Software, to update 100 user accounts from an external text file. View in 1080p for best video quality.
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses
Course of the Month10 days, 13 hours left to enroll

765 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