• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 327
  • Last Modified:

Active Directory Query

I need to run a query in Active Directory that will retrieve user's first name, last name and their account login name and export it to a csv file.
0
jduclosjduclos
Asked:
jduclosjduclos
1 Solution
 
KenMcFCommented:
I would use powershell and the free Quest cmdlets


get-qaduser -sl 0 | Select FirstNAme, LastName, Samaccountname | Export-csv c:\temp\users.csv -notype
0
 
Mike KlineCommented:
Lots of great ways

I like adfind (free)    http://www.joeware.net/freetools/tools/adfind/index.htm

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

adinfo is a really nice free GUI tool

http://www.cjwdev.co.uk/Software/ADReportingTool/Info.html

other methods include powershell, dstools, vbscript, csvde, and there are more.

Thanks

Mike
0
 
dave_itCommented:
Using the native 2008 R2 AD cmdlets:

get-aduser -identity "xxxxxxx" -properties * | Select-Object samAccountName,givenname,surname | Export-CSV c:\temp\userid.csv
0
 
Leon FesterSenior Solutions ArchitectCommented:
I'm a ldifde and csvde man myself, both are tools from Microsoft and available in the Windows resource kit

ldifde -f Exportuser.ldf -d "dc=Export,dc=com" -p subtree -r "(&(objectCategory=person)(objectClass=User)(givenname=*))" -l "cn, sAMAccountName"

ldifde -f Exportuser.ldf -d "dc=Export,dc=com" -p subtree -r "(&(objectCategory=person)(objectClass=User)(givenname=*))" -l "givenName, sn, sAMAccountName"

http://support.microsoft.com/kb/237677

CSVDE -f export3.csv -l "cn, samAccountName"
CSVDE -f export3.csv -l "givenName, sn, samAccountName"
http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Export.htm
0
 
jduclosjduclosAuthor Commented:
Thank you!!
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

Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

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