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

obatin user info from the Active Directory


I need to extract the following information from the AD for all our users:

First Name Last Name      Display Name      Description      Office      Telephone Number      E-Mail      Street      City      Postal Code      Country      Logon Name      Title      Department      Company      Manager

Can somebody please tell me what is the easiest of doing this? Ideally, I want to populate an excel spreadsheet with  the extracted info.

Note that users are spread in diffrent containers.

Many Thanks
1 Solution
Our mission: To export all users and computers into a file called adusers.csv and then to read this export data in Excel.

Preparation: Open up a command prompt, I use Start, Run, CMD.

Type this command:  CSVDE -f adusers.csv

To see instantly the result of your command, type: notepad adusers.csv.  For a more useful view of your export, open a spreadsheet like Excel, click File (menu) Open, select: Files of Type and change to All files, now browse to the directory where you created adusers.csv.

more http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Export.htm
Mike KlineCommented:
This is a long command because your output but first download adfind by MVP Joe Richards
adfind -default -f "&(objectcategory=person)(objectclass=user)"   givenname sn displayname description physicaldeliveryofficename telephonenumber mail streetaddress L postalcode c samaccountname title department company manager -csv -nodn > C:\users.csv
That users.csv file on your C drive now should be what you need. Please let me know how that looks.

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

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