Printable View
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.
I use a simple vbscript to run through the ou, and update attributes for each user in the ouAl colleague is writing a scrip that will update UPN's from sims so moodle courses can be automatically createdCode:
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 ;)"
edit: just look in hte adsiedit/ldap for the attribute names of fistname,lastname etc
Ok, that'll work fine for email addresses. What about First/Last/Display Names? I have the information in a CSV file currently.
Quote:
objuser.put "middleName"
Quote:
objuser.put "givenName"
sirnameQuote:
objuser.put "sn"
= displayname ?Quote:
objuser.put "name"
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
this http://www.wisesoft.co.uk/Products/PasswordControl/ has just been updated to bulk change pretty much any information in activedirectory
hope this helps
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.
@Geoff, ok - I guess a vbscript guru is needed. I just pulled that from my collection, rather than my head ;)
Geoff there is a program called hygena
www.systemtools.com 30 days full evaluation
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:Quote:
Originally Posted by Geoff
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. :(
I will give this a go when I'm at work tomorrow :D
So close. That works for everything apart from changing the cn attribute. :(
Code: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.
I'm pretty sure that CSVDE will do what you want... I found http://www.computerperformance.co.uk...ogon_CSVDE.htm a useful resource.
Do you have a download url for CSVDE?
It's a Windows commandline tool. It should be installed on your DCs already IIRC.Quote:
Originally Posted by Geoff