Solved

script to export Username to a CSV format from AD

Posted on 2008-10-04
2
565 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
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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

When it comes to writing scripts for a Client/Server computing environment it is essential to consider some way of enabling the authentication functionality within a script. This sort of consideration mainly comes into the picture when we are dealin…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…
Need to grow your business through quality cloud solutions? With everything required to build a cloud platform and solution, you may feel like the distance between you and the cloud is quite long. Help is here. Spend some time learning about the Con…

914 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now