Solved

script to export Username to a CSV format from AD

Posted on 2008-10-04
2
569 Views
Last Modified: 2012-06-27
MY AD is having almost 25,000 users in different departments. I need the user name and password , display name and the department name from my Active directory, I need to export to a .csv format . Later i need to import to windows live (for -email creation)

Can anyone come up with a script  or tool which will allow me to export a list of user name, password , display name and Department from my AD to a .csv format
0
Comment
Question by:mishalk
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 14

Expert Comment

by:igor-1965
ID: 22641385
Password?????
0
 
LVL 31

Accepted Solution

by:
Henrik Johansson earned 250 total points
ID: 22641482
Password can't be exported because it's encrypted.

Use CSVDE-command like below. Any attribute listed in -r parameter must match and if using displayname=* means that it cannot be empty.
If you want the usenrame@domain instead of just username, replace the attribute samaccountname in -l parameter with userprincipalname.

C:\>csvde -f export.csv -r "(&(objectclass=user)(samaccountname=*)(displayname=*))" -l "samaccountname,displayname,department"

See csvde /? for help on the command.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
This article provides a convenient collection of links to Microsoft provided Security Patches for operating systems that have reached their End of Life support cycle. Included operating systems covered by this article are Windows XP,  Windows Server…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question