Network Admin - User Creation Spreadsheet

[j2mccluggage at adelphia.net (Jody & Jennifer McCluggage)]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.pauldotcom.com/pipermail/pauldotcom/attachments/20090901/eb9444f0/attachment.htm