Bulk update of Active Directory user info

[Geoff]

Slightly different from the usual 'bulk creation' question. I already have my AD users created. However my predecessor did not fill in all the information. In paticular i would like to fill in the First Name/Surname/Display Name fields (for ABTutor) and email address (for Moodle LDAP). Any suggestions how to do this?

Note I do not want to re-create the accounts, just modify them.

[CyberNerd]

I use a simple vbscript to run through the ou, and update attributes for each user in the ou

Set objParent = GetObject("LDAP://OU=Year group,OU=address,DC=dot,DC=com")

objparent.Filter = Array("user")



for each objUser in objParent

  'Wscript.Echo "Modifying " & objUser.Get("sAMAccountName")

	objUser.put "mail", objUser.Get("sAMAccountName") & "@email.address.com"


	objuser.put "proxyAddresses", "SMTP:" & objUser.Get("sAMAccountName") & "@email.address.com"

	objuser.EmployeeType = "STUDENT"

	objUser.put "UserPrincipalName", objUser.Get("sAMAccountName") & "@address.com"

objuser.Setinfo

 

    

next

Wscript.Echo "Done ;)"

Al colleague is writing a scrip that will update UPN's from sims so moodle courses can be automatically created


edit: just look in hte adsiedit/ldap for the attribute names of fistname,lastname etc

[Geoff]

Ok, that'll work fine for email addresses. What about First/Last/Display Names? I have the information in a CSV file currently.

[CyberNerd]

objuser.put "middleName"

objuser.put "givenName"

objuser.put "sn"

sirname

objuser.put "name"

= displayname ?

you can find all these in the adsi edit - incase you need some extra fields in future.
Also with moodle it's worth having some content filter on the email side - any instant messages the student sends through moodle should get caught by the email filter

[fooby]

this http://www.wisesoft.co.uk/Products/PasswordControl/ has just been updated to bulk change pretty much any information in activedirectory

hope this helps

[Geoff]

Cybernerd, I understand that aspect of it. But like I said, I need to read the information in from a CSV and match it up with accounts based on the login.

fooby, thanks for the link. I'll try the software as soon as my registration comes through.

[CyberNerd]

@Geoff, ok - I guess a vbscript guru is needed. I just pulled that from my collection, rather than my head

[mrtechsystems]

Geoff there is a program called hygena

www.systemtools.com 30 days full evaluation

[Geoff]

fooby, password control does not give me any way to import extra info into AD, just modify existing settings in bulk.

mrtech, same problem.

[Wiseman82]

fooby, password control does not give me any way to import extra info into AD, just modify existing settings in bulk.

mrtech, same problem.

Another recent offering of mine might help though:

http://www.wisesoft.co.uk/Scripts/di...pt.aspx?id=178

Password Control/Bulk Modify allows you do base modifications on other attributes - you could set the display name to "firstname, surname" but not to load the first name and surname information from a spreadsheet.

The VBScript above will allow you to update AD Attributes from a CSV file - hope this helps.

As a side note I have been thinking of adding another tool to allow users to sync active directory with a database (HR database for example or a spreadsheet). I've also been thinking of adding an import utility (you can always use account management spreadsheet for now). The site and tools are all updated in my spare time - I often have lots of ideas but not enough time to implement them.

[Geoff]

I will give this a go when I'm at work tomorrow

[Geoff]

So close. That works for everything apart from changing the cn attribute.

LDAP://CN=T Nicholson,OU=Year10,OU=Pupils,OU=All Users,DC=carrhill,DC=lancs,DC=sch,DC=uk

Change cn from 'T Nicholson' to 'Thomas Nicholson'

Commit Changes: Failed.

[Ric_]

I'm pretty sure that CSVDE will do what you want... I found http://www.computerperformance.co.uk...ogon_CSVDE.htm a useful resource.

[Geoff]

Do you have a download url for CSVDE?

[Ric_]

Do you have a download url for CSVDE?

It's a Windows commandline tool. It should be installed on your DCs already IIRC.