bekosysadmin
asked on
obatin user info from the Active Directory
Hi
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
C
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
C
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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