AD Bulk User Creation Utility with extras?

[gshaw]

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

[Stuart_C]

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).

[binky]

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.

[gshaw]

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....

[plexer]

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

[sted]

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

[Gatt]

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

[gshaw]

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

[Gatt]

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

[gshaw]

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

[TheScarfedOne]

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!! :-)

[DAckroyd]

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

[binky]

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.

[DAckroyd]

any recommendations for server 208?

[jamesb]

PowerShell.