Create Users AD with Excel

Описание: Donate Us : paypal.me/MicrosoftLab

Create Users AD with Excel

1. Prepare

DC1 : Domain Controller(Yi.vn) | WIN101 : Client | A excel file has infomations Users

2. Step by step : Create Users AD with Excel

DC1 : Create users manual

Server Manager - Tools - Active Directory Users and Computers - Yi.vn - IT OU - Create a new user in the current container :

Last Name : HiepNS + User logon name : HiepNS + Type and conform password - Finish

Double-Click HiepNS :

General tab - Display name : Hiep Nguyen Si + Description : Nguyen Si Hiep + Office : IT staff + Telephone number : 1989

Telephones tab - Mobile : 123459999

WIN101 : Create a excel file for Windows PowerShell

Create a new excl file named CreateUsers.xlsx, with fields:

Last Name : (Surname) + Display name : (DisplayName) + Description : (Description) + Office : (Office)

Telephone number : (OfficerPhone) + User logon name : (UserPrincialName) + User logon name (pre-Windows 2000) : (SameAccountName)

Mobile : (MobilePhone) + Password : (AccountPassword) + Enable account : (Enabled) + ChangePasswordAtLogon : ($True)

Copy informations from Users.xlsx fill to fields

Copy all rows to notepad and replace tab( ) to empty - Save and named CreateUsers.txt

DC1 : Create users from file. Copy CreateUsers.txt

Run all rows of CreateUsers.txt with Active Directory Module for Windows PowerShell === Check again

Syntax :

New-AdUser -Name () -Surname () -SamAccountName () -UserPrincipalName ()@Yi.vn -DisplayName "()" -Description "()" -Office "()" -Path "OU=(),DC=Yi,DC=vn"

-AccountPassword(ConvertTo-SecureString -AsPlainText "abc@123" -force) -MobilePhone () -OfficePhone () -ChangePasswordAtLogon $True -Enabled $True



------------------------------------------------------------********************    / microsoftlab   ********************-------------------------------------------------------