1

Hello

I’m having new users on a regular basis. Few hundreds every week :). Instead creați get them manually I would like to import them from a CSV (using PowerShell)
I need the to be Active, in a specific OU, and with password.
Can some one give me a hand here please?
Found lots of articles online but not very clear…
Many thanks

6 Spice ups
2

Hey Remustincu,

Try this script;

http://community.spiceworks.com/scripts/show/1917-active-directory-user-creation-tool

Here is the original content;

https://gallery.technet.microsoft.com/scriptcenter/New-User-Creation-tool-14fa73cd

3 Spice ups
3

There are a lot of examples out there. If you find one that is close and post it back here with what is missing/not working, that’d be better. Rather than us doing the whole thing.

One note, to set a password at user creation you need to pass New-ADUser a SecureString object. That’s kind of a tricky part when you are first learning how to do that via powershell.

$password = ConvertTo-SecureString -String "MyPassw0rd1" -AsPlainText -Force
3 Spice ups
4

Dell Software has a product called Quick Connect. It’s specifically a part of the Dell One Identity Suite, and ties into Dell Active Roles Server, but can also be used as a standalone product. Essentially, it is a GUI for PowerShell, and can itself be configured to run custom scripts, if necessary. It has built-in synchronization connectors for CSV files and Active Roles Server, and you can download a connector pack to get it working with native Active Directory.

Basically, it’s a synchronization engine with scheduling.

If this is something that you are doing often, you might want to consider Quick Connect or something like it. You’ll see historical information and be able to drill down on any errors to see conflicts.

#iwork4Dell

1 Spice up
5

Thank you guys for the reply. Very useful indeed.

I`ll try Dell software also.

For now I have sorted this way:

Import-Csv .\bobhopepublic.csv | New-ADUser -Enabled $true -ChangePasswordAtLogon $true -AccountPassword (ConvertTo-SecureString Pass123 -AsPlainText -force)

Also I have attached the CSV file as reference.

Once again thank you for the help.