Discussion Locked

User account script

0 helpful
9 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have to create over 500 user accounts, i have all the user info in an excel spread sheet. Are there any scripts I can use to create these accounts off of excel. Thank you

9 replies

by joseph moore

You could add the NET USER command in a cell before the user names. The full syntax for NET USER is this:
NET USER [username [password | *] [options]] [/DOMAIN]
username {password | *} /ADD [options] [/DOMAIN]
username [/DELETE][/DOMAIN]

You could add the /DOMAIN switch, and the password you want the users to use.

After that, export it as a tab delimited text file, and save it as a .BAT file.
Then double-click the BAT file on your domain controller.

hope this helps

by waynetsui

You could try to use addusers.exe from the resources kit. But I don't know whether import from excel file is ok or not. Anyway, you could export the excel file to a text file and import the user account by this tool.

by malik_ajay

You can use the below command for creating users through excel sheet.

ADDUSERS Utility
addusers [ \\computername ] { /c [/p:{l | c | e | d}] | /d | /e } filename [/s:x] [/?]
Where:
\\computername
is the computer on which you want to createuser accounts or from which you want to write user accounts.
/c
creates user accounts, local groups, and global groups as specified by filename.
/p:
followed by l, c, e, or d, or any combination of the four, sets the following account-creation options (must be used in conjuction with /c):
? l
users do not have to change passwords at next logon.
? c
users cannot change passwords.
? e
passwords never expire (implies l option).
? d
accounts are disabled.
/d
dumps (writes) user accounts, local groups, and global groups to filename.

/e
deletes user accounts as specified by filename.
Caution Be careful when erasing user accounts, as it is not possible to recreate the user account with the same SID. This option, however, cannot erase built-in default accounts.
Also, be aware that when a local or global group is included in the text file, the /e switch does not just remove the user from the group, but also eliminates the entire group.
filename
is the comma-delimited input/output file that addusers will use for data.
/s:x

changes the character used for separating fields in the file. the x should be replaced with the new character to be used for separating fields. for example, /s:~ would make the "~" (tilde) the field-separation character.
if this option is not specified, the default separator, a comma (","), is used.
/?
displays a usage screen with this syntax

This discussion is closed to new replies.