Home All Groups Group Topic Archive Search About

How to export all the user's name and surname of my Active Directory in an excel file ?

Author
10 Mar 2006 8:13 AM
moi
Hello,

How to export all the user's name and surname of my Active Directory in an
excel file ?

Thanks for your help ..

Author
10 Mar 2006 8:37 AM
Paul Williams [MVP]
adfind -default -f "(&(objectClass=user)(objectCategory=person)) -nodn -csv
cn givenName sn samaccountname > AllUsers.csv


Download ADFIND from www.joeware.net

Open the output file AllUsers.csv in Excel.

Note.  That command is all one line.

--
Paul Williams
Microsoft MVP - Windows Server - Directory Services
http://www.msresource.net | http://forums.msresource.net