How to import users from a Activedirectory OU.

Posted on 2016-09-06
Medium Priority
Last Modified: 2016-09-13

We have Windows 2012 DC and we have a OU where 200 users are created. I want to export their full name , user name and password.
I have used CJWDEV AD info Free Edition in the past and completely forgot how to import users from specific OU.

Please can you post me , if there is any Free tool to do this .

Question by:lianne143
LVL 86

Accepted Solution

oBdA earned 1000 total points
ID: 41785666
Get-ADUser -Filter * -Properties DisplayName -SearchBase 'OU=SomeOU,OU=Wherever,DC=domain,DC=com' |
	Select-Object -Property DisplayName, SamAccountName |
	Export-Csv -Path C:\Temp\ADUsers.csv -NoTypeInformation

Open in new window

You can't export their passwords, nor is there any need for anyone to know anybody else's password.
LVL 19

Assisted Solution

by:Todd Nelson
Todd Nelson earned 1000 total points
ID: 41786202
Like OBDA said, you cannot export passwords.

Other than that, you will to get what you want with CSVDE (run from CMD prompt).  Try something like this...

csvde.exe -d "ou=MYOU,dc=MYDOMAIN,dc=local" -r objectClass=user -l DisplayName,userPrincipalName -f user-objects.csv

Open in new window


Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I’m willing to make a bet that your organization stores sensitive data in your Windows File Servers; files and folders that you really don’t want making it into the wrong hands.
The Windows Firewall provides an important layer of protection and a rich interface to configure it. Unfortunately, it lacks item level filtering. This article details my process of implementing firewall-as-code to reduce GPO bloat.
This tutorial will walk an individual through the process of configuring basic necessities in order to use the 2010 version of Data Protection Manager. These include storage, agents, and protection jobs. Launch Data Protection Manager from the deskt…
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

607 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