Solved

script to export Username to a CSV format from AD

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

I've always wanted to allow a user to have a printer no matter where they login. The steps below will show you how to achieve just that. In this Article I'll show how to deploy printers automatically with group policy and then using security fil…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

752 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