General discussion

Locked

User account script

By dcapossela ·
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

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

User account script

by DKlippert In reply to User account script
Collapse -

User account script

by dcapossela In reply to User account script

The question was auto-closed by TechRepublic

Collapse -

User account script

by Joseph Moore In reply to User account script

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

Collapse -

User account script

by dcapossela In reply to User account script

The question was auto-closed by TechRepublic

Collapse -

User account script

by waynetsui In reply to User account script

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.

Collapse -

User account script

by dcapossela In reply to User account script

The question was auto-closed by TechRepublic

Collapse -

User account script

by malik_ajay In reply to User account script

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

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

Collapse -

User account script

by dcapossela In reply to User account script

The question was auto-closed by TechRepublic

Collapse -

User account script

by dcapossela In reply to User account script

This question was auto closed due to inactivity

Back to Windows Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums