Solved

AD Querys

Posted on 2012-03-14
3
340 Views
Last Modified: 2012-03-16
I am trying to run a query in ADUC to get a list of all my users.  Does anyone know of a good tool to query all my users and export to a csv.  Or at least to be able to pull all my users.  I have multiple OU's that I need to pull from.
0
Comment
Question by:APWIP-Admin
3 Comments
 
LVL 57

Accepted Solution

by:
Mike Kline earned 500 total points
ID: 37720063
A lot of ways, a free GUI tool that is nice is adinfo   http://www.cjwdev.co.uk/Software/ADReportingTool/Info.html

adfind is a great command line tool  (free)   http://www.joeware.net/freetools/tools/adfind/index.htm

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

other methods include powershell, dstools, csvde, ADUC, and other methods but that should get you started

Thanks

Mike
0
 

Author Closing Comment

by:APWIP-Admin
ID: 37720121
Perfect.  Thank you
0
 
LVL 8

Expert Comment

by:bchallis
ID: 37731802
if you have a Windows Server 2008 R2 DC or have the gateway services installed so that you can use the ActiveDirectory module for PowerShell, you could also use:

Get-ADUser | Export-Csv Users.csv
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

A procedure for exporting installed hotfix details of remote computers using powershell
This script can help you clean up your user profile database by comparing profiles to Active Directory users in a particular OU, and removing the profiles that don't match.
This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

932 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now