Sign up to access this lesson
Click here to sign up and get access to this lesson!

Saving Progress...
In this lecture, I am going to be showing you how you can create active directory users from a CSV file.
I am going to show you how the CSV file looks like and you can find it in the resources of this lecture called NewUsers.csv.

You can see header fields like First Name, Last Name, Job Title, Office Phone, Email Address, Description, the target Organizational Unit or where they need to be placed within Active Directory and whether or not the account should be Enabled once it's created.
So, we are going to use PowerShell to automatically create all these user accounts. These are just 10 users here but if we were working with 500 or a thousand this will also work.
Log into the IPDC01 server and I have the file already saved into my E:\ drive.

We open Windows PowerShell ISE by clicking on the Windows icon on the bottom left and typing powershell and selecting Windows PowerShell ISE.

And the Windows PowerShell ISE opens up.

Let’s start typing out the script with the following:
# Import the AD Module
Import-Module ActiveDirectory
# Get the path to our target CSV file
$filepath = Read-Host -Prompt "Please enter the path to the CSV file that contains the new user accounts"
# Import the CSV as an array
$users = Import-CSV $filepath
Press the Play button to execute the script.
Note that in the bottom pane we have the script executed and it is asking for the path to the CSV so we type in E:\NewUsers.csv and press the Enter key on your keyboard.
The script finishes executing.

Now we need to do something with that information. Let’s add to our script the following:
# Import the AD Module
Import-Module ActiveDirectory
# Get the path to our target CSV file
$filepath = Read-Host -Prompt "Please enter the path to the CSV file that contains the new user accounts"
# Import the CSV as an array
$users = Import-CSV $filepath
# Complete an action for each user in the CSV file
ForEach ($user in $users) {
# Do this for each user
echo $user.'First Name'
}
Execute the script by clicking the Play icon and enter the CSV path during script execution.
The output of the script shows the First Name column of the CSV file.

Now let’s continue with the script adding the following line now:
# Import the AD Module
Import-Module ActiveDirectory
# Get the path to our target CSV file
$filepath = Read-Host -Prompt "Please enter the path to the CSV file that contains the new user accounts"
# Import the CSV as an array
$users = Import-CSV $filepath
# Complete an action for each user in the CSV file
ForEach ($user in $users) {
# Do this for each user
echo $user.'First Name'
echo $user.Description
}
Execute the script by clicking the Play icon and enter the CSV path during script execution.
We can see that by adding the Description we have after the First Name, the Description from the CSV file.

We can see that so far the script is working as we expect.
So, what we can do now is create a new user account. Let’s type the following code:
# Import the AD Module
Import-Module ActiveDirectory
# Get the path to our target CSV file
$filepath = Read-Host -Prompt "Please enter the path to the CSV file that contains the new user accounts"
# Import the CSV as an array
$users = Import-CSV $filepath
# Complete an action for each user in the CSV file
ForEach ($user in $users) {
# Do this for each user
New-ADUser `
-Name ($user.'First Name' + " " + $user.'Last Name') `
-GivenName $user.'First Name' `
-Surname $user.'Last Name' `
Sign up to access the rest of this lesson
You must either log in or sign up to access this lesson.
CURRICULUM
Course Introduction • 1min
0 / 1 lessons complete
Getting Started with Active Directory Domain Services • 52min
0 / 6 lessons complete
Section Overview
Free lesson
Text | 1 min
Installing the ADDS (Active Directory Domain Services) Server Role
Video | 7 min
Promote the Server to a Domain Controller
Video | 7 min
Forests, Trees and Domains
Video | 2 min
Windows Domain Quiz
Quiz | 5 Questions
Lab: Installing the Active Directory Domain Services
Lab | 30 min
Introduction to Active Directory Users & Computers • 1hr 23min
0 / 10 lessons complete
Section Overview
Free lesson
Text | 2 min
Organizational Units (OUs) and Containers
Video | 5 min
Creating, managing and deleting OUs
Video | 5 min
Creating User Accounts with Active Directory
Video | 8 min
Searching for Objects in Active Directory
Video | 6 min
Resetting User Passwords and Unclocking Accounts in Active Directory
Video | 6 min
Understanding Groups and Memberships
Video | 11 min
Disabling and Deleting User Accounts
Video | 6 min
Active Directory Quiz
Quiz | 5 Questions
Lab: Active Directory Users and Computers
Lab | 30 min
Adding a Second Domain Controller • 1hr 30min
0 / 7 lessons complete
Notice of change in Lab Names
Text | 2 min
Section Overview
Free lesson
Video | 2 min
Promoting Our Second Domain Controller
Video | 13 min
Flexible Single Master Operation (FSMO) Roles Overview
Free lesson
Video | 4 min
Transferring FSMO (Flexible Single Master Operations) Roles
Video | 5 min
Adding a Second Domain Controller Quiz
Quiz | 5 Questions
Lab: Adding a Second Domain Controller
Lab | 60 min
Active Directory Backups • 1hr 24min
0 / 5 lessons complete
Creating an Active Directory / System State Backup
Video | 4 min
Restoring an Active Directory Backup
Video | 7 min
Creating and Restoring Active Directory Snapshots
Video | 8 min
Active Directory Backups Quiz
Quiz | 5 Questions
Lab: Active Directory Backups
Lab | 60 min
How to Administrate Active Directory with Windows PowerShell • 1hr 58min
0 / 7 lessons complete
Enabling Script Execution for PowerShell
Video | 6 min
Listing AD Users with PowerShell
Video | 14 min
Creating AD Users with PowerShell
Free lesson
Video | 10 min
Creating User Accounts from a CSV (Comma Separated Value) File
Video | 15 min
Move All Disable Users to Disabled Users OU with PowerShell
Video | 8 min
AD PowerShell Quiz
Quiz | 5 Questions
Lab: ADUC PowerShell Automation
Lab | 60 min
Administrating AD SS (Active Directory Sites and Services) • 1hr 3min
0 / 5 lessons complete
Active Directory Sites and Services - Section Overview
Free lesson
Video | 8 min
Configuring Our ITFROUTE01 Server to act as a Router
Video | 11 min
Configuring Active Directory Sites and Services
Video | 9 min
Administrating AD SS Quiz
Quiz | 5 Questions
Lab: Configure ADDS Between Two Subnets
Lab | 30 min
Active Directory Trusts • 54min
0 / 5 lessons complete
Window Trusts Explained
Free lesson
Video | 6 min
Configuring DNS Settings for Active Directory Trusts
Video | 6 min
Establish a Two-way Active Directory Trust
Video | 7 min
Active Directory Trusts Quiz
Quiz | 5 Questions
Lab: Establish a two-way AD Trust
Lab | 30 min
Modifying the Active Directory Schema • 43min
0 / 3 lessons complete
Add Custom Attributes to Active Directory Users
Video | 8 min
Active Directory Schema Quiz
Quiz | 5 Questions
Lab: Extending the Active Directory Schema
Lab | 30 min
Course Conclusion • 1min
0 / 1 lessons complete