asked on 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.
Active Directory
Last Comment
jduclosjduclos
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Using the native 2008 R2 AD cmdlets:
get-aduser -identity "xxxxxxx" -properties * | Select-Object samAccountName,givenname,s
get-aduser -identity "xxxxxxx" -properties * | Select-Object samAccountName,givenname,s
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)
ldifde -f Exportuser.ldf -d "dc=Export,dc=com" -p subtree -r "(&(objectCategory=person)
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
ldifde -f Exportuser.ldf -d "dc=Export,dc=com" -p subtree -r "(&(objectCategory=person)
ldifde -f Exportuser.ldf -d "dc=Export,dc=com" -p subtree -r "(&(objectCategory=person)
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
ASKER
Thank you!!
get-qaduser -sl 0 | Select FirstNAme, LastName, Samaccountname | Export-csv c:\temp\users.csv -notype