PaulDotCom mailing list archives

Network Admin - User Creation Spreadsheet


From: bytesabit at gmail.com (bytes abit)
Date: Wed, 2 Sep 2009 09:50:03 -0300

wasn't really concerned about finding someone who wrote one.. found a few
though, but just wanted to make my own.

Thanks for the cmdlets though, will look into them




On Tue, Sep 1, 2009 at 10:08 PM, Jody & Jennifer McCluggage <
j2mccluggage at adelphia.net> wrote:

 Or you can download the Quest AD Cmdlets for PowerShell to add users/make
changes in mass all in just one line of code.  Cost $0.



Jody


 ------------------------------

*From:* pauldotcom-bounces at mail.pauldotcom.com [mailto:
pauldotcom-bounces at mail.pauldotcom.com] *On Behalf Of *xgermx
*Sent:* Tuesday, September 01, 2009 1:31 PM
*To:* PaulDotCom Security Weekly Mailing List
*Subject:* Re: [Pauldotcom] Network Admin - User Creation Spreadsheet



Not to discredit any of your work, but there are already multiple tools to
do this for you. At my company I use a product called AD Bulk Users (
http://www.dovestones.com/products/Active_Directory_User_Import.asp) to
add users/make changes en mass. It does cost $99 but unless you're an
extremely fast coder, it is far cheaper to use this than to code your own (I
suppose it also depends how much you're making hourly).
That being said, you've already done the leg work of coding this, so I'll
definitely be giving it a try.

 On Tue, Sep 1, 2009 at 10:49 AM, bytes abit <bytesabit at gmail.com> wrote:

I have created an Excel Spreadsheet that allows one to PASTE a list of
"Last Name, First Name" into the Name column and it auto-generates a batch
file that creates the list of names into Active Directory user accounts.

I have changed some of the random code and aspects to keep my usage hidden,
but have created an example file for the PDC community.


I hope this helps someone out, saves me about 4 hours a month, as we
generate many users.


NOTE:  Some of the options are not available and are simply there for
concept.  Also, this example could be used for any command :)

I also realize this can probably be done in many languages, but I was
teaching Excel at the time and thought it a good example to my class on
embedded formulas :P



The batch file will be created in the same location that the file resides.


++ As per anything, I welcome and suggest you check the code out first to
ensure I have... errrr BOB has not been meddling with the file or trying
something sneaky.





_______________________________________________
Pauldotcom mailing list
Pauldotcom at mail.pauldotcom.com
http://mail.pauldotcom.com/cgi-bin/mailman/listinfo/pauldotcom
Main Web Site: http://pauldotcom.com



No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.5.409 / Virus Database: 270.13.75/2340 - Release Date: 09/01/09
20:03:00

_______________________________________________
Pauldotcom mailing list
Pauldotcom at mail.pauldotcom.com
http://mail.pauldotcom.com/cgi-bin/mailman/listinfo/pauldotcom
Main Web Site: http://pauldotcom.com

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.pauldotcom.com/pipermail/pauldotcom/attachments/20090902/2c7a1828/attachment.htm 


Current thread: