Shulou(Shulou.com)06/03 Report--

Today, the editor will bring you an article on how to import user accounts in bulk. The editor thinks it's pretty good, so I'll share it for you as a reference. Let's follow the editor and have a look.

How to import a large number of user accounts? Is one of the things we need to consider after the 2008R2 installation is set up.

The way to do this is to sort out the user information in the Excel document, and then import it into AD with commands or scripts.

Of course, the method is as simple as possible, and the less we need to modify, the better.

We first got an excel form of the employee roster from the personnel department.

For us, the important thing is the name and job number, the three departments. Of course, for AD administrators, the more detailed the user account information, the better.

Let's edit this material:

First add two columns, login name and password

Then save the form as C:\\ aduserdata.csv (on DC)

Close the csv file.

Running CMD as an administrator

The command format and parameters of For do can be downloaded from Baidu.

As a result, an error was reported and the file could not be found. The reason is that when CSV is open, it cannot be read by the command. If you close it and then run the command, you will OK.

Open ADUC and you can see

We open any user and view the properties.

Test OK, all created successfully

In fact, people with work experience will find that there is a problem with the above creation.

If there is no OU, what if I run GPO later?

In general, we create an organizational OU before importing users.

For example, Shanghai headquarters and Shanghai subsidiaries, as shown in the following figure

It is suggested that the name of ou is better in English, sometimes there are garbled codes in Chinese, and it is more troublesome to edit.

If you follow the above method, you must make a CSV file for the employees of each department.

Next, let's do the personnel account of the head office and save it as C:\\ SHHQHRUSER.CSV

Just add the corresponding OU selection when using the command of for do

Test OK

:) even if you give me 5K users, you won't worry.

After reading the content of the appeal, do you have a general understanding of how to import user accounts in bulk? If you want to know more, you are welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.