[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 7656
  • Last Modified:

Export AD User accounts to excel

We have a lot of user accounts that are old and should be removed.  However I need a way to export the list off all the user accounts from AD to excel or word so that I can show it to the boss and get his help deciding which accounts should be removed.  Anyone know of a way to do this?
0
menreeq
Asked:
menreeq
1 Solution
 
fbcbloodcenterCommented:
Here is a link to a script that will do what you need:
http://www.visualbasicscript.com/m_29830/tm.htm
0
 
Farhan KaziSystems EngineerCommented:
You can use command line utility called CSVDE to export required information into .csv format that can be easily opened into Excel.

Like:
Click Start -> Run -> Cmd.exe -> OK

CSVDE  -R "(objectCategory=user)" -L givenName,sn,sAMAccountName,mail -F UserInfo.csv

Above statement will create UserInfo.csv file.

OR
Directory Users and Computers (ADUC):
1.  Open ADUC and go to the OU you want to export
2.  Click View - Add/Remove Colums - and select / arrange the attributes you want to export
3.  Click Action - Export

Hope this helps!
Farhan
0

Featured Post

Free tool for managing users' photos in Office 365

Easily upload multiple users’ photos to Office 365. Manage them with an intuitive GUI and use handy built-in cropping and resizing options. Link photos with users based on Azure AD attributes. Free tool!

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