Mark - something I did once that proved pretty easy is as follows: 1) Grab a list of first names and a list of last names from a genealogy site - as many as you can, but make sure they are not the same number (i.e. 97 last names and 93 first names) 2) make a spreadsheet with the last names in column A 3) first names in column B 4) middle initials A through Z in column C 5) now drag and fill (drag the plus) down each column individually 6) since the numbers of each name part are offset, they will mix in many combinations and aren't likely to repeat. 7) create formulas to create email and logon addresses i.e. D1 =LOWER(LEFT(B1,1)&C1&A1) for username, E1 =D1&"@contoso.net" then fill drag those down the page, then copy them and paste the values over them 8) create formulas to check for duplicates - Sort the data by logon names and then make a formula to compare each with the previous one i.e. =IF(D2=D1,"DUPLICATE","") and then fill drag it down, and manually browse for dupes and delete them
I created several thousand users this way, from dead people's names :) ----------------------------------------------------------------------- Rich Milburn MCSE, Microsoft MVP - Directory Services Sr Network Analyst, Field Platform Development Applebee's International, Inc. 4551 W. 107th St Overland Park, KS 66207 913-967-2819 ---------------------------------------------------------------------- ”I love the smell of red herrings in the morning” - anonymous -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Parris Sent: Tuesday, January 03, 2006 10:35 AM To: ActiveDir.org Subject: Re: [ActiveDir] OT: Request for Test AD Poplulation Data Al, This is what I was going to do, I was just hoping that I did not have to reinvent the wheel. Mark -----Original Message----- From: Al Mulnick <[EMAIL PROTECTED]> Date: Tue, 3 Jan 2006 10:37:27 To:ActiveDir@mail.activedir.org Subject: Re: [ActiveDir] OT: Request for Test AD Poplulation Data I haven't seen a generic user creation utility, however in similar situations I prefer to have a bit more control than that and would instead create a list of user names that I can easily glance at and know the originating directory. If you truly want random names to work with, you may want to consider building such a dictionary and building that directory based on that. Something that uses maybe census or population data would be useful I'm sure. I'd likely build the template directory with script and then use ldif to export it for future use. Does that help or is that not what you can use? On 1/3/06, Mark Parris <[EMAIL PROTECTED]> wrote: I utilise VBScript too, but I wanted user data with a little more substance. 500 names in an ldf file is a lot more use to me than a vbs file which creates user 1, 2, 3 etc etc Mark -----Original Message----- From: Tomasz Onyszko <[EMAIL PROTECTED]> Date: Tue, 03 Jan 2006 15:49:22 To:ActiveDir@mail.activedir.org Subject: Re: [ActiveDir] OT: Request for Test AD Poplulation Data Rick Kingslan wrote: > Tomasz, I think that Mark is looking to populate his metabase with data > other than User 1, User 2, User 3, etc. with simple or blank attributes. > So, he's looking for stuff like Homer Simpson, with all of the user data, > then Marge, etc. So stuill I don't think he will find such .. I use vbscript to populate my AD with test data. -- Tomasz Onyszko http://www.w2k.pl List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/ .+w֧B+v*rz Vryi˽箊 -------APPLEBEE'S INTERNATIONAL, INC. CONFIDENTIALITY NOTICE------- PRIVILEGED / CONFIDENTIAL INFORMATION may be contained in this message or any attachments. This information is strictly confidential and may be subject to attorney-client privilege. This message is intended only for the use of the named addressee. If you are not the intended recipient of this message, unauthorized forwarding, printing, copying, distribution, or using such information is strictly prohibited and may be unlawful. If you have received this in error, you should kindly notify the sender by reply e-mail and immediately destroy this message. Unauthorized interception of this e-mail is a violation of federal criminal law. Applebee's International, Inc. reserves the right to monitor and review the content of all messages sent to and from this e-mail address. Messages sent to or from this e-mail address may be stored on the Applebee's International, Inc. e-mail system. List info : http://www.activedir.org/List.aspx List FAQ : http://www.activedir.org/ListFAQ.aspx List archive: http://www.mail-archive.com/activedir%40mail.activedir.org/