+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 41
Windows Thread, AD Bulk User Creation Utility with extras? in Technical; Originally Posted by DAckroyd you can just do a concotonate in one cell and fill down - 2mins work if ...
  1. #16
    gshaw's Avatar
    Join Date
    Sep 2007
    Location
    Essex
    Posts
    2,662
    Thank Post
    166
    Thanked 220 Times in 203 Posts
    Rep Power
    67
    Quote Originally Posted by DAckroyd View Post
    you can just do a concotonate in one cell and fill down - 2mins work if the file is otherwise prepared
    Ye that's the trick I was using before to get firstname.surname for the username field... was hoping the program would save an edit but maybe not

  2. #17

    Join Date
    Nov 2007
    Location
    Rotherham
    Posts
    1,678
    Thank Post
    122
    Thanked 126 Times in 102 Posts
    Rep Power
    45
    Personally I use the Windows Server command DSAdd. Output form my MIS into excel, bit of messing around (would be easier if I coudl use joe.bloggs for usernames but I'm stuck with the syntax that was here before I started) to get the syntax and copy it into a .bat file and run it. Something similar using "mkdir" to create the home area, "subinacl" to set the security on your home area and job done.

    All using stuff built into Windows server (or downloadable from Microsoft, I think subinacl is in a toolkit).

  3. #18
    binky's Avatar
    Join Date
    Sep 2006
    Posts
    290
    Thank Post
    1
    Thanked 19 Times in 16 Posts
    Rep Power
    0
    Quote Originally Posted by Cools View Post
    Im with ben on this..
    Active Directory Tools, Active Directory Software
    so easy and no farting about..
    Whoa, just went on this site and i thought I was on OPSoftware, are they affiliated.

  4. #19
    gshaw's Avatar
    Join Date
    Sep 2007
    Location
    Essex
    Posts
    2,662
    Thank Post
    166
    Thanked 220 Times in 203 Posts
    Rep Power
    67
    Looks like CSV tweaking is pretty unavoidable then, with the usernames and passwords in the CSV then any of the above should do the trick by the looks of it....

  5. #20

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,232
    Thank Post
    667
    Thanked 1,638 Times in 1,463 Posts
    Rep Power
    423
    Quote Originally Posted by binky View Post
    Whoa, just went on this site and i thought I was on OPSoftware, are they affiliated.
    Nothing to do with OP Software as far as I know.

    Ben

  6. #21


    Join Date
    Mar 2009
    Location
    Leeds
    Posts
    6,647
    Thank Post
    229
    Thanked 865 Times in 743 Posts
    Rep Power
    297
    Quote Originally Posted by gshaw View Post
    Looks like CSV tweaking is pretty unavoidable then, with the usernames and passwords in the CSV then any of the above should do the trick by the looks of it....
    you can use excel to do most of the work does everything but duplicate checking for me i litteraly feed in first name last naem and year of entry and it generates usernames/folders/appliesscripts/profiels etc just copy and past the output to a batch file (i cant really post it as someone else at work wrote it ive just been tweaking it) ut in a nutshell it just creates a list of md and dsadd commands

  7. #22

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,678
    Thank Post
    861
    Thanked 650 Times in 431 Posts
    Rep Power
    499
    We use this tool from the chaps over at WiseSoft - Resources for IT Professionals
    http://www.wisesoft.co.uk/software/a...t/default.aspx

    Simple spreadsheet that uses a DLL and lets you set all the necessary parameters via a nice easy VB function

  8. #23
    gshaw's Avatar
    Join Date
    Sep 2007
    Location
    Essex
    Posts
    2,662
    Thank Post
    166
    Thanked 220 Times in 203 Posts
    Rep Power
    67
    Well the magic bullet for creating usernames in my case is

    =LOWER(CONCATENATE(A1,".",B1))

    That does the trick in Excel and the free AUM tool seems to do the best job of working with the CSV, no mess no fuss and it does the profile path as well, result

    Adding to a group would be easy enough through ADUC anyway so near enough sorted this now wahey

    Just need a "Thank All" button now hehe

  9. #24

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,678
    Thank Post
    861
    Thanked 650 Times in 431 Posts
    Rep Power
    499
    Quote Originally Posted by gshaw View Post
    Well the magic bullet for creating usernames in my case is

    =LOWER(CONCATENATE(A1,".",B1))

    That does the trick in Excel and the free AUM tool seems to do the best job of working with the CSV, no mess no fuss and it does the profile path as well, result

    Adding to a group would be easy enough through ADUC anyway so near enough sorted this now wahey
    My formula is very similar, but with a few nested IF's to create the DNs and CNs (Checks for a middle initial and adds an extra space and cell ref if there is, otherwise a space and the surname)

    Not got the formula to hand - will try and post it tomorrow

  10. #25
    gshaw's Avatar
    Join Date
    Sep 2007
    Location
    Essex
    Posts
    2,662
    Thank Post
    166
    Thanked 220 Times in 203 Posts
    Rep Power
    67
    AUM creates the display names and SAMaccountname fields automatically as well so one less bit of work there

    Only manual work is the add to group operation but it's one right click then some typing and a left click so can't be too picky

  11. #26
    TheScarfedOne's Avatar
    Join Date
    Apr 2007
    Location
    Plymouth, Devon
    Posts
    1,143
    Thank Post
    677
    Thanked 169 Times in 154 Posts
    Blog Entries
    78
    Rep Power
    85
    Thumbs up for AUM here too...

    It will also do the add to group if you put the groups you want in the template for the OU. Have a gander at the user guide - it tells you how to do it. Only one down point on it is that it cant do Exchange 07 mailboxes...

    Otherwise - AUM is spot on!! :-)

  12. #27

    Join Date
    Feb 2009
    Posts
    460
    Thank Post
    66
    Thanked 34 Times in 21 Posts
    Blog Entries
    1
    Rep Power
    19
    I've just installed AUM on one of my 2008 DC's and get an error when trying to activate saying "The Activation Code entered has not been accepted" anyone else experiance this or is it a 2k8 thing?
    thanks

  13. #28
    binky's Avatar
    Join Date
    Sep 2006
    Posts
    290
    Thank Post
    1
    Thanked 19 Times in 16 Posts
    Rep Power
    0
    Quote Originally Posted by DAckroyd View Post
    I've just installed AUM on one of my 2008 DC's and get an error when trying to activate saying "The Activation Code entered has not been accepted" anyone else experiance this or is it a 2k8 thing?
    thanks
    I did this and AUM was VERY unstable, especially with the permissions, it accepted the activation code - but I would not recommend it on 2k8.

  14. #29

    Join Date
    Feb 2009
    Posts
    460
    Thank Post
    66
    Thanked 34 Times in 21 Posts
    Blog Entries
    1
    Rep Power
    19
    any recommendations for server 208?

  15. #30

    Join Date
    Mar 2008
    Location
    Surrey
    Posts
    2,168
    Thank Post
    98
    Thanked 319 Times in 261 Posts
    Blog Entries
    4
    Rep Power
    113
    PowerShell.

SHARE:
+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. Windows Server 2008: Bulk User Creation
    By DAckroyd in forum Windows Server 2008
    Replies: 4
    Last Post: 3rd February 2009, 08:25 PM
  2. Bulk user Creation
    By Jamie_a in forum Windows
    Replies: 10
    Last Post: 14th January 2009, 06:30 PM
  3. bulk user creation
    By jonbones in forum Network and Classroom Management
    Replies: 1
    Last Post: 18th June 2008, 10:43 AM
  4. Bulk User Creation Tools
    By mark in forum Downloads
    Replies: 16
    Last Post: 10th July 2007, 04:24 PM
  5. Bulk user creation
    By Dos_Box in forum How do you do....it?
    Replies: 63
    Last Post: 13th November 2006, 07:02 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •