Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Bulk User script Generator

Status
Not open for further replies.

elqboy

Technical User
Jun 10, 2009
2
US
I'm a newbie in the IT field, i dont have any experience on the real world yet.
After you've finish testing this project please let me know how useful can this be to an administrator or to the IT staff. Your feedback will be appreciated... Thanks

I've been working on this project for a few weeks now. This project is base on a excel spreadsheet that generates commands to add user to AD. It may sound simple but is a bit complex since every aspect of the process can be customize. You could add user to up to 5 groups, set their home folder and drive, profile and a lot more... just play with it and you will understand everything.

The link to the spreadsheet has been attached. The only knowledge needed is to be able to replicate formulas on excel which is very easy. I have comments on about every cell you can customize so the process is almost self explanatory.

If you want to quickly test drive my project, simply add an entry on the first sheet which is the INFO sheet which consist of a Firstname lastname and OU, that is all you need, everything will be generated for you. if you want to try it with more entries simply copy the formals down on all sheets After this you just have to copy the information on the Results Only sheet into a batch file and you are done.

 
This sort of thing is available already but good on you for making one yourself and in Excel too.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top