I need to add about 300 users to AD. What would be the easiest and quickest way to do this.

All of the users have the same security groups. I need to add first,middle, last name;ID;state Number;Grade;Homeroom;Gender;Birth date and ethnicity for each user. Also an email address for each user is necessary with first initial and last name. AD is linked to google so it will create the account once email address is inserted in AD. Students vary from grades 9-12 so we would need to split them up into 4 different folders in active directory.
LVL 1
NOC123Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Scott CSenior EngineerCommented:
User PowerShell

See Example #4.

http://www.windowsnetworking.com/articles-tutorials/windows-server-2012/creating-active-directory-accounts-using-powershell.html

A good example of how you can use Windows PowerShell to automate a common Active Directory management task is the bulk creation of users.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cliff GaliherCommented:
If you have this list in a digital format already (such as a .csv file) then a Powershell script would be the fastest way to do that.  Since each file can be different and you may have unique criteria, you'll probably want to hand-code one, but it'd realistically only be a few lines and a for loop. 10 minutes of coding, with debugging, under normal circumstances and requirements.
0
Scott CSenior EngineerCommented:
Do you have your new users in a text file?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Dustin SaundersDirector of OperationsCommented:
Pop up a sample of your CSV structure and I'll code it out for you.
0
Adam BrownSr Solutions ArchitectCommented:
Some of the attributes you have (Homeroom, Grade, Age, Gender, and Ethnicity) don't have a good spot in AD to go by default. You can extend the AD schema to add those attributes ( Http://www.showmehowtodoit.com/create-custom-active-directory-attributes-for-user-properties/ has instructions), just be aware that modifying the schema is a potentially dangerous (and extremely confusing) proposition that few, if any, people are willing to undertake.

You could potentially add those values in existing AD attributes like the Notes field, but that will confuse people and if you use the Notes field for all of that info, you won't be able to easily search for student info based on grade, homeroom, age, or whatever.

If you do extend the schema, those values will only be visible in the Attributes Tab of their Account Properties by default, but you can change what AD Users and Computers shows so that info is displayed when browsing the directory ( https://blogs.technet.microsoft.com/undocumentedfeatures/2016/01/19/extending-active-directory-users-and-computers-with-custom-attributes/ )

As to how to get all that data added, Powershell is probably the easiest way. If you have the data in a CSV file, let us know what the headings are for each line, where you want the data to go in AD, and someone will be able to build a quick script to get it put in for you. Note, the headings should have no spaces or special characters.
0
Matthias RudolphCommented:
Hi,

Use the PowerShell cmdlet New-ADUser

Here's a step-by-step beginners tutorial including the .csv way

http://activedirectoryfaq.com/2016/04/ad-powershell-basics-new-aduser/

Regards,
Matthias
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Active Directory

From novice to tech pro — start learning today.

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.