This is the complete tutorial to creating bulk users in Active Directory.

Yes, I know

Creating Active Directory accounts is boring, it can be repetitive and time consuming when done manually.

And who has the time to manually create bulk AD accounts?

Well, I’ve got good news!

Importing bulk ad users is simple and can actually be fun. (Yea I’m a nerd, automation is a great thing).

In this guide, I’ll show you step by step instructions on how easy it is to create bulk ad accounts.

I’m actually going to show you two methods

Method 1: Using PowerShell to import ad users from a CSV
Method 2: Using GUI Tool to bulk import AD users

Check it out

Video Tutorial

If you don’t like video tutorials or want more details, then continue reading the instructions below.

Method 1: Using PowerShell to import ad users from a csv

If you don’t like PowerShell or want a GUI import tool then jump to method 2.

What you will need: 

  • PowerShell Active Directory Module loaded – The script I provide will load the module you just need to run it from a computer that has RSAT tools installed or the AD role.
  • Rights to create users accounts in Active Directory
  • CSV file and PowerShell Script -> Download Here

Step 1: Setup the csv file

There are only 5 fields in the csv file that are required for each user account, they are:

firstname
lastname
username
password
ou

I will walk through adding a few users to my csv file

Above is a screenshot of my csv file setup with the required fields configured. It’s not a good security practice to set the same password for every account, mix it up some.

I’ve set the PowerShell script to set the accounts to require password change at next logon, another good security practice. This can be changed if you want to remove that option.

You can set each account to import into a specific OU.  I’ve set two accounts to import into the default users OU then I set one account to import into a Marketing OU.

How do you find the OU path? 

The OU path is the distinguishedName attribute, to find this open up Active Directory Users and Computers and browse to the OU you want to import to, then right click and select properties then select attribute editor.

Copy the path into the OU column on the csv file.

At this point the csv file has the required fields,  you can jump to step 2 (setting up the PowerShell script) or keep reading to setup optional fields for user accounts.

Setup User Optional fields

You may want to include some additional details for each account.

I’ve included some optional fields that are commonly used when setting up AD accounts. If there are fields you want to add that I have not provided, just add them to the csv file (you will also need to add it to the script)

email
streetaddress
city
zipcode
state
county
department
telephone
job title
company

As you can see in the screenshot above I’ve entered info into the optional fields for 2 accounts.

Now save the csv file to an easy to remember location. I’ve put mine in c:\it\Final_NewAccounts2.csv

The path of the csv file will need to be entered into the powershell script. With the csv file setup I’ll move to step 2.

Step 2: Setup the PowerShell script

The only thing that needs to be modified in the script is the path to the csv file, and the UserPrincableName.

To modify the script just right click on the ps1 file and select edit. This will open the script in PowerShell ISE

Modify this section to the correct path of your csv file.

$ADUsers = Import-csv C:\it\Final_NewAccounts2.csv

Now modify line 42 and change the domain

-UserPrincipalName "$Username@winadpro.com"

My domain is ad.activedirectorypro.com so I will update mine to

-UserPrincipalName "$Username@ad.activedirectorypro.com"

Save the changes and move on to step 3.

Step 3: Run the PowerShell Script to import the accounts

At this point, the csv file should be setup with the users information and the Powershell script should be modified.

Now it’s time to execute the script.

In PowerShell ISE just click the green button to run the script.

It should return to the prompt if it ran successfully, I received a warning due to an account that already exists.

I will verify it created the other account.

Yes it was a success.

That’s it for method 1. You can now use this script anytime to automate creating one or many AD user accounts. It’s a huge time saver.

Method 2: Using GUI Tool to bulk import AD users

This method requires no PowerShell. It’s super easy and has built-in support for many user attributes, adding to multiple groups, multiple proxyaddresses, and so on.

What you will need:

Step 1: Download and Install the AD Pro Toolkit

The install is very simple:

1. Extract the downloaded zip file and run the installer file -> AD Pro Toolkit Demo Installer.msi

2. Click next on the Welcome screen

3. Choose destination path (default is fine) click next

5. Click Next

6. Click Close

Install finished! You will find the Bulk User Creation tool in the Start Menu.

Step 2. Bulk User Creation Tool CSV Setup

The next step is to generate the CSV template and fill out the user details.

Open the tool and click on generate CSV template

You will be prompted to save the CSV template. You can change the name and save it anywhere you like.

Now open the CSV template and fill out the fields you need.

Key points

  • The only required field is the sAMAccountName, the rest are optional.
  • Don’t delete columns, if you don’t need one just leave the row blank for the user.
  • The template includes 33 user attributes. You can add additional attributes by adding a new column with the attribute name.
  • Use the ou column to add users to an organizational unit. This needs to be the DN of the OU. I provided steps above for finding this value.
  • You can add users to multiple groups by separating them with a comma. Example below in my CSV screenshot.
  • You can give users multiple proxyaddresses just separate them with a comma.

In this example, I’m going to create several users and add them to multiple security groups.

When you have your CSV template ready just save it and move to step 3.

Step 3. Select CSV and run the import. 

The next step is to select the template from the GUI tool and click run.

You will see the progress in the lower left. In addition, you will see the process in the log box, it will show any errors in red and all properties that were set in green.

All 39 users I set in the CSV completed. Now, I’ll go into Active Directory users and computers and verify some of the settings.

Looks like the users were added to the organizational units.

Now lets check if the user was added to the security groups.

Yes! It worked, it created the account and imported all the fields I set.

The GUI tool makes the bulk importing process very very easy, no coding or PowerShell experience is needed.

I have shown you two methods for creating bulk users in Active Directory, try them out and decide which one works best for you.

You Might Also Like…

Recommended Tool: SolarWinds Server & Application Monitor

This utility was designed to Monitor Active Directory and other critical services like DNS & DHCP. It will quickly spot domain controller issues, prevent replication failures, track failed logon attempts and much more.

What I like best about SAM is it’s easy to use dashboard and alerting features. It also has the ability to monitor virtual machines and storage.

Download Your Free Trial Here

84 Comments

  1. Nick on March 15, 2018 at 10:42 am

    I been looking for a script that works is there a reason why you didnt add the description and office fields?

    • Robert Allen on March 15, 2018 at 11:45 pm

      Hi Nick,

      The description and office fields are not something I commonly used when creating bulk users. The script can easily be modified to include any fields you want, just add the field to the excel file and include it in the script.

      • MC on June 30, 2020 at 1:06 pm

        What about adding attributes like ProxyAddresses or UserPrincipleName?

        • Robert Allen on July 2, 2020 at 7:40 pm

          Yup those can be added. The GUI Tool already has them included in the CSV template.

  2. KB on May 1, 2018 at 7:05 pm

    Thank you for this! This works like a charm!

    • Robert Allen on May 1, 2018 at 11:50 pm

      You’re welcome. Glad it worked.

  3. Gideon on May 21, 2018 at 9:59 am

    This is amazing, I tweaked it to suit my requirements and it worked like the name of Jesus!
    Thank you!

    • Robert Allen on May 22, 2018 at 12:36 am

      Gideon, glad it worked.

  4. SHarbel on May 31, 2018 at 5:32 am

    This is excellent!
    Do you know if there is a way to import a user without setting a new pw?

    • Robert Allen on May 31, 2018 at 10:26 am

      Sharbel, Having user accounts with no passwords is a big security risk. I would not recommend it.

      With that said I think you can use this command New-ADUser “John Doe”. This will create the account but will disable it until a password is provided.

  5. Javier on June 11, 2018 at 7:47 pm

    Hello, Robert,
    The manual that you publish is perfect for now that I use WS2016.

    Thanks for sharing.

  6. John Herry on June 18, 2018 at 10:13 am

    thank, it’s excellent !!

    • Robert Allen on June 20, 2018 at 12:00 pm

      You’re welcome.

  7. ManP on June 29, 2018 at 7:20 pm

    How can I add roaming profile to the script ?

    • Robert Allen on January 1, 2021 at 4:52 pm

      That should be the -ProfilePath parameter if using PowerShell. This parameter is already included in the GUI tool.

  8. Blake on July 3, 2018 at 3:47 pm

    I am looking at doing this but only creating mail enabled contacts in bulk. I was currently doing this by loading the contacts from an remote LDAP and then looping through them. I was getting server errors like, server not responding, while looping. Is this method any different? I could create this file from the remote LDAP and then run your method but it looks similar to my current loop. And by bulk I mean over 10k mail enabled contacts.

  9. Ehtesham on July 5, 2018 at 6:25 am

    Can we use the GUI tool to import attributes for pre-existing user accounts in AD.

  10. PM on August 7, 2018 at 4:21 pm

    I figured out my issue. Thanks for this script it was great!

  11. Daniel on September 4, 2018 at 10:31 am

    Can I do this before I join the user computers to the domain?

    Also, if I have multiple unmanaged users in the company and now I want to create an AD DC to manage them, what is the best way to do it and what the order of operation should be?

    Thanks.

  12. Evan D on September 7, 2018 at 9:10 pm

    Robert,

    Could this also be used to set the newly created imported users with default “Member of” groups? This way they could be set to distros, security groups, etc without having to go back manually and set each one up after the import.

  13. Umer Mughal on September 18, 2018 at 4:47 am

    you should tell the OU path in the video.where we find the ou path and how it work.

  14. Nana Permana on September 20, 2018 at 2:45 pm

    thank. it’s work

    could you please inform how to add field extensionAttribute from csv to AD

    because i try it but did not work

  15. Fernando on September 22, 2018 at 9:01 pm

    Hi Robert! Thank you so much for this approach. I took your example and I’ve modified the logic for the following reasons.
    Suppose you’re managing a multi-domain AD environment (same forest) and HR department send you the list of new hires for the entire company each month. If you don’t have a software managed solution (which is my case) you have to manage the process by your own.

    So, in the CSV file I’ve added the following columns:
    – UPNSuffix
    – UPN (which is a formula — =TEXTJOIN(,TRUE,A2,”@”,H2) where A2 contains Name/SamAccountName property and H2 contains UPNSuffix string) As a result you have SamAccountName@UPNSuffix.
    – MobilePhone (value required for sales users)
    – OU (this is for creating accounts into different OUs)

    The main change in the script logic is based on “what if HR send you a list in which a given SamAccountName is already created for a user account, but the lastname of the user has changed (let’s say… a woman got married)?. According to the validation you’re doing, the script will throw a warning and it’ll skip the creation when in fact the account must be modified.

    Let’s take into account the fact that modifications are required as creations as well. So… instead of using New-ADUser what must be used is Set-ADUser. I’ve spent many hours trying to figure out WHY Set-ADUser throw errors when all the information in the CSV is accurate. What I’ve realized is… Set-ADUser will throw errors “IF THERE’S AN EMPTY EXEL CELL AND YOU’RE TRYING TO MAP THE VALUE OF SUCH CELL AS A PROPERTY IN ACTIVE DIRECTORY USER ACCOUNT OBJECT”.
    I have user accounts whose INITIAL property doesn’t matter so they’re empty cells in my CSV, but the foreach() script block is taking it into account so I had errors (nothing that could be easily realize in the error message by the way).

    So… in order to get this covered, I had to add $ErrorActionPreference = “SilentlyContinue” at the beginning of the script.

    Lastly, Set-ADUser won’t modify Fullname property. Again… if for some reason HR give you a list with this value changed, the way I’ve covered this is by adding Get-ADUser -Identity ($User.SamAccountName) | Rename-ADObject -NewName $User.DisplayName -Verbose within foreach() script block.

    I hope this helps someone who faced the same issues I’ve faced, or needs to achieve the same goals as I have.

    Thanks a lot Robert. Your script gave me the starting point of my whole search!

    • Robert Allen on September 23, 2018 at 12:25 pm

      Fernando thanks for the details, I’m sure this will help others.

      The script I provided is very basic so I’m happy you was able to use it as a starting point.

    • Mark on March 11, 2019 at 1:48 pm

      Hello

      What about if there are duplicate user names? Is there something I can add to your script that would just add a 1 or 2 or 3 until the account is created

  16. Umair Ahmed on September 26, 2018 at 10:14 am

    Thanks for this great knowledge

  17. Kashef on September 26, 2018 at 4:45 pm

    Hi Robert
    What if you wanted to bulk update existing AD users by populating fields with values

    • Robert Allen on September 28, 2018 at 12:26 pm

      I’m going to write a separate post on this subject. Is there anything specific you would like to see examples of?

      • Biju Mathew on November 29, 2018 at 4:40 pm

        Hi Robert,

        Did you get a chance to write a separate post on bulk update of existing AD users?

        • Robert Allen on December 17, 2018 at 9:53 pm

          I’ve created a GUI tool for this, it’s very very close to being completed. It’s basically PowerShell with a GUI.

  18. Sven on September 29, 2018 at 3:07 pm

    Hi Everyone,

    I have a problem with the script. I got the following message:
    Get-ADUser : Variable: ‘Username’ found in expression: $Username is not defined.
    At C:\scripts\bulk_users1.ps1:31 char:6
    + if (Get-ADUser -F {SamAccountName -eq $Username})
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : InvalidArgument: (:) [Get-ADUser], ArgumentException
    + FullyQualifiedErrorId : ActiveDirectoryCmdlet:System.ArgumentException,Microsoft.ActiveDirectory.Management.Commands.GetADUser

    I only changed the lines that are required in this tutorial.

    If somebody can help me that would be very much appreciated 🙂

  19. Sven on September 29, 2018 at 3:18 pm

    Hi Everyone,

    First I want to thank you for sharing this awesome tutorial!
    For some reason, I get an error message with the following text:

    Get-ADUser : Variable: ‘Username’ found in expression: $Username is not defined.
    At C:\scripts\bulk_users1.ps1:31 char:6
    + if (Get-ADUser -F {SamAccountName -eq $Username})
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : InvalidArgument: (:) [Get-ADUser], ArgumentException
    + FullyQualifiedErrorId : ActiveDirectoryCmdlet:System.ArgumentException,Microsoft.ActiveDirectory.Management.Commands.GetADUser

    I only changed the lines to my OU’s and my domain

    If somebody would like to help me I would appreciate it 🙂

    -Sven

  20. khan on October 2, 2018 at 8:01 pm

    How can I also make the users a part of a member group in ad ?

  21. Brett J on October 10, 2018 at 3:29 am

    Can the Solarwinds tool be used to just update attributes to existing users?

  22. Maksud on October 18, 2018 at 4:51 pm

    Hi i am not able to add more field. its not giving me option in search box also

  23. Jason on October 25, 2018 at 11:49 am

    Hi Rob,

    This script works like a charm! One question: Is there a way to add a person to an AD Group when you import them?

    Thanks a bunch!

  24. Ibrahim on October 27, 2018 at 5:40 pm

    Honestly, took me whole day to figure out why PS method didn’t work and user import tool works so better. Found out that it was due to wrong OU information, no doubt in that your tutorial is so step by step helpful guide for experts or newbies.

  25. stranger on November 14, 2018 at 11:39 am

    can you add an option to add to groups? i am copying from a template so if i use your script, i will need to add the users to groups manually.

    • Robert Allen on September 7, 2019 at 8:35 pm

      Yup. I’m working on a GUI version that will include many more options including adding to group.

  26. Ricky Clemmons on November 27, 2018 at 7:36 pm

    Hi,

    Im trying to figure out how to script adding proxyaddress

    • Robert Allen on January 5, 2019 at 9:45 pm

      I’ve created a tool for that. Check out the full how to guide -> https://activedirectorypro.com/how-to-bulk-modify-ad-user-attributes/

    • Shane McFadden on November 25, 2019 at 3:53 pm

      Hi Ricky / anyone else wondering how to do this,

      For additional attributes that don’t have a specific PowerShell property, you can use:
      New-ADUser -OtherAttributes @{‘proxyAddresses’=$proxyAddresses}
      In this case, for a proxy address. You can include as many as you like in the curly brackets, I included {‘co’=$co} for the full country name as New-ADUser doesn’t have a property for directly setting it (only the country code, e.g. US).

      Hope that helps.

  27. G.Ashraf Ali on January 17, 2019 at 11:48 am

    Thank you, it was very helpful and a nice GUI tool

  28. Todd Hank on February 19, 2019 at 7:46 pm

    I am haping problems using the Solarwinds GUI. The main problem is that I am trying to also set the User-Principal-Name to the firstname.lastname@company.com

    I cannot get it to work.

  29. Tim B. on March 7, 2019 at 9:42 pm

    Thank you. Thank you. Thank you.

    Every year I need to create 180+ “new Student” Accounts in AD. With a little modification of the amazing ground work you have shared with the world, you have saved me days of manually entering in each account. I used the Powershell and .csv approach, and it works flawlessly! Previously I have used some “trial software” that had obvious limitations, and expectations, but knew there had to be a way Powershell could do it. And here you are! Thank you so very much for sharing this.

    • Robert Allen on March 7, 2019 at 11:50 pm

      Tim, glad this worked for you. Thanks for the feedback.

  30. Bradley Hiller on March 11, 2019 at 7:25 pm

    Having trouble adding a user to a domain group when using the script. I’m a novice with Powershell. I have the AD group in my csv file. Any help would be great.

    # Import active directory module for running AD cmdlets
    Import-Module activedirectory

    #Store the data from ADUsers.csv in the $ADUsers variable
    $ADUsers = Import-csv C:\AD_Tool\Master.csv

    #Loop through each row containing user details in the CSV file
    foreach ($User in $ADUsers)
    {
    #Read user data from each field in each row and assign the data to a variable as below

    $Username = $User.username
    $Password = $User.password
    $Firstname = $User.firstname
    $Lastname = $User.lastname
    $SamAccountName =$User.SamAccountName
    $OU = $User.ou #This field refers to the OU the user account is to be created in
    $email = $User.email
    $company = $User.company
    $department = $User.department
    $Password = $User.Password
    $homedirectory = $User.homedirectory
    $homeDrive = $User.homeDrive
    $EmployeeID = $User.EmployeeID
    $EmployeeNumber = $User.EmployeeNumber
    $Add-ADGroupMember -Identity = $User.Add-ADGroupMember -Identity

    #Check to see if the user already exists in AD
    if (Get-ADUser -F {SamAccountName -eq $Username})
    {
    #If user does exist, give a warning
    Write-Warning “A user account with username $Username already exist in Active Directory.”
    }
    else
    {
    #User does not exist then proceed to create the new user account

    #Account will be created in the OU provided by the $OU variable read from the CSV file
    New-ADUser `
    -SamAccountName $Username `
    -UserPrincipalName “$Username@mydomain.org” `
    -Name “$Firstname $Lastname” `
    -GivenName $Firstname `
    -Surname $Lastname `
    -Enabled $True `
    -DisplayName “$Lastname, $Firstname” `
    -Path $OU `
    -EmailAddress $email `
    -homeDrive $homeDrive `
    -homedirectory $homedirectory `
    -EmployeeID $EmployeeID `
    -EmployeeNumber $EmployeeNumber `
    -Add-Add-ADGroupMember -Identity $Add-ADGroupMember -Identity `
    -AccountPassword (convertto-securestring $Password -AsPlainText -Force) -ChangePasswordAtLogon $False

  31. Dun Broch on March 29, 2019 at 1:58 am

    Hello Robert,

    This is very helpful. I usually create multiple users in AD every 2 weeks and your script saves me a lot of time. Do you know how I can insert the details for Pager, Mobile in Telephones tab and also assign them to specific Security Group?

    Thanks a lo!

  32. Thao on March 29, 2019 at 10:27 am

    Hi Robert,

    Thank you for this helpful post.

    I would like to upload a users with option Password Never Expires in Account tab. How do I set this option in .csv file?
    Thank you
    Regards,
    Thao

    • Robert Allen on September 7, 2019 at 8:32 pm

      That is a big security risk, I would not recommend doing that.

  33. TAMMY GUTH on May 2, 2019 at 4:13 pm

    So, the same as the last commenter, every year we have the need to create hundreds of new student accounts. Additionally, we have summer school classes that are open to non-district kids. So, that is a bunch more accounts that are created every year! We were contracting this bulk creation out to our network support people. But you tool works like a dream and will save us time AND money! One question though: the Sam-Account-Name isn’t populating the user logon name in AD…shouldn’t it? Or do I have to map that somewhere else? Additionally, when I look at the OU in AD, I would like to see the students’ names in the Name column rather than the Sam-Account-Name. What do I need to change to make these things happen? Thanks!!

  34. Brad P-S. on June 8, 2019 at 2:01 pm

    I was so pleased to find this post, Robert. I too have to create new students every year/semester. I had been using a python script given to me using LDAP. But I wanted more granularity. This is great. But I shy away from the powershell (newbie) and tried the solarwinds user import tool. It started out great, but kept hitting errors (it was the OU mapping). When I finally got it to create the accounts, it did not populate all the attributes from the CSV, only the pre-win2000 attribute. What am I missing?

  35. Andrew Tuson on August 16, 2019 at 2:18 pm

    The Solar Winds tool works well, but I have added an extra column. All students are members of Sudents_SG to I have added groupMembershipSAM to the csv file which I map across to Group-Membership-SAM in the User Import Tool but it does not get imported. Any idea why this is the case?

  36. Michael on September 18, 2019 at 4:17 pm

    Love this, big time saver, however I am having issues trying to figure out how to add the new bulk users to their proper groups. Can you help with this?

    Much appreciate it.

  37. Cindy on October 17, 2019 at 3:32 pm

    Thank you so much. This has been a life saver. I saw in one of the comments you were working on a solution for adding to Groups. Has this been completed? It would help out a lot in my environment.

  38. Elton Banfield on December 28, 2019 at 5:02 am

    The GUI tool is amazing, but I get and error saying: could not create user [Access is denied.] I am both Domain Admin and Enterprise Admin. can you help?

    • Robert Allen on November 7, 2020 at 11:07 pm

      Please log into your account and download the latest version. If you still have issues please send me an email.

      Thanks
      Roberts

  39. tom on March 13, 2020 at 9:50 pm

    thanks for your assistance to date
    how can i generate a new random username in your script………

  40. Jack Lamers on March 19, 2020 at 10:29 am

    Hi Robert,

    I would like to use this PS Script to bulk import users in a new environment.

    .csv is like
    firstname lastname username email city country state zipcode password telephone jobtitle company ou Department

    Jack Lamers j.lamers j.lamers@company.com Venray Nederland Limburg 5803 AN P@$$w0rd 0612345678 Sysop
    NEH CN=etcetcetc ICT

    When I run your script, I receive these errors

    PS C:\Users\Administrator> C:\Beheer\powershell_create_bulk_users\bulk_users1.ps1
    Get-ADUser : Variable: ‘Username’ found in expression: $Username is not defined.
    At C:\Beheer\powershell_create_bulk_users\bulk_users1.ps1:31 char:6
    + if (Get-ADUser -Filter {SamAccountName -eq $Username})
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : InvalidArgument: (:) [Get-ADUser], ArgumentException
    + FullyQualifiedErrorId : ActiveDirectoryCmdlet:System.ArgumentException,Microsoft.ActiveDirectory.Management.Commands.GetADUser

    Get-ADUser : Variable: ‘Username’ found in expression: $Username is not defined.
    At C:\Beheer\powershell_create_bulk_users\bulk_users1.ps1:31 char:6
    + if (Get-ADUser -Filter {SamAccountName -eq $Username})
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : InvalidArgument: (:) [Get-ADUser], ArgumentException
    + FullyQualifiedErrorId : ActiveDirectoryCmdlet:System.ArgumentException,Microsoft.ActiveDirectory.Management.Commands.GetADUser

    Get-ADUser : Variable: ‘Username’ found in expression: $Username is not defined.
    At C:\Beheer\powershell_create_bulk_users\bulk_users1.ps1:31 char:6
    + if (Get-ADUser -Filter {SamAccountName -eq $Username})
    + ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    + CategoryInfo : InvalidArgument: (:) [Get-ADUser], ArgumentException
    + FullyQualifiedErrorId : ActiveDirectoryCmdlet:System.ArgumentException,Microsoft.ActiveDirectory.Management.Commands.GetADUser

    Any Idea?

  41. S M on April 11, 2020 at 2:12 am

    Thanks very much, for providing a few options for bulk creating users on AD. Very, very useful info.
    Nicely done, to the point and detailed! Impressive work you have done. Many thanks!!

  42. xmarker on May 7, 2020 at 9:54 pm

    How do I map User Logon name to its appropriate domain? Say for example I have a child domain on DC2 with a domain like studentid@student.myuni.com. When I bulk import using SolarWinds GUI tool everything works except this mapping is not taking place, any ideas?

    • Robert Allen on January 1, 2021 at 8:04 pm

      With the GUI tools, you can right click and run as a different user and authenticate to the child domain. With PowerShell, you can use the -server parameter to specify the domain controller instance to connect to.

  43. Ron on May 13, 2020 at 11:26 pm

    Hi Robert,
    What code can I add to add the new user email address in the proxyAddress field of the attribute editor.
    Thanks for the help

  44. Sam on May 15, 2020 at 9:43 pm

    Great tool, was hoping it would work for me but I can’t past an [Access is Denied.] error when I attempt the import. Know the credentials I’m using are good; I can manually create a user just fine. Pared the attributes down to just three fields (Sam-Account-Name, Passwod, OrganizationalUnit) and one record, fails every time. Tried several different OU’s, same error.

    Any ideas?

    • Robert Allen on September 20, 2020 at 1:55 pm

      Hi Sam. Is this with the script or GUI tool? If you purchased the GUI tool send me an email. I need to make sure you are on the latest version, there have been several updates.

  45. islam oda on July 28, 2020 at 9:53 pm

    thanks, it’s worked with me

  46. Prix82 on October 12, 2020 at 7:05 pm

    One little tip: CSV delimiters may differ in some regions / localized Excel versions, so if you use for example semicolons (like me) instead of commas, extend your CSV import line:
    $ADUsers = Import-csv -Path “A:\Some\Path\tofile.csv” -Delimiter “;”

    Anyway, it’s an easy, very useful and very clear script, thanks for sharing! 🙂

    • Robert Allen on October 30, 2020 at 11:21 am

      Good tips. Thanks

    • Robert Allen on November 7, 2020 at 3:53 pm

      Prix82, great tip. Thanks for sharing!

  47. ahmed on October 27, 2020 at 9:39 pm

    i have a problem when i click run code i get that error

    new-ADUser : The server is unwilling to process the request
    At C:\it\bulk_users1.ps1:41 char:3
    + New-ADUser `
    + ~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (CN=Joshua Lynch…ctorypro,DC=COM:String) [New-ADUse
    r], ADException
    + FullyQualifiedErrorId : ActiveDirectoryServer:0,Microsoft.ActiveDirectory.Management.Comman
    ds.NewADUser

    New-ADUser : The server is unwilling to process the request
    At C:\it\bulk_users1.ps1:41 char:3
    + New-ADUser `
    + ~~~~~~~~~~~~
    + CategoryInfo : NotSpecified: (CN=Sam smith,CN…ctorypro,DC=COM:String) [New-ADUse
    r], ADException
    + FullyQualifiedErrorId : ActiveDirectoryServer:0,Microsoft.ActiveDirectory.Management.Comman
    ds.NewADUser

    PS C:\it>

    • Robert Allen on November 7, 2020 at 10:21 pm

      Try it with a single user and make sure you run PowerShell as an administrator.

  48. ahmed on October 27, 2020 at 10:25 pm

    How can i add ip phone number

  49. Robert Allen on October 29, 2020 at 10:27 pm

    It does not create an email box in exchange or office 365. It just adds the email address to the Active Directory attribute field.

  50. PB on November 19, 2020 at 8:20 am

    Is there any script available that creates bulk ad-users and copies the properties from a template user?

  51. Mr.Patel on December 3, 2020 at 5:23 pm

    hey ,
    you have any video or document from that i can learn how to make a script for adding bulk user in AD with .bat file ?

    • Robert Allen on December 4, 2020 at 10:05 pm

      Why do you want to use .bat file? The best option for creating bulk users is to use PowerShell or the GUI tool I created.

Leave a Comment