+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 31
Windows Thread, Bulk update of Active Directory user info in Technical; Yup, found it....
  1. #16

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,804
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    Yup, found it.

  2. #17

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,804
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    Doesn't work. Changing the CN causes CSVDE to create a new account.

  3. #18

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,804
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    Quote Originally Posted by Geoff View Post
    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.
    Ah ha. According to this:

    http://www.microsoft.com/technet/scr...4/hey1214.mspx

    One must 'move' an LDAP object to alter it's CN. Which explains the problems I was having.

    wiseman, any chance of changing your script so it handles CN moves?

  4. #19
    Wiseman82's Avatar
    Join Date
    Jan 2006
    Location
    North East
    Posts
    48
    Thank Post
    3
    Thanked 14 Times in 11 Posts
    Rep Power
    21
    Quote Originally Posted by Geoff View Post
    Ah ha. According to this:

    http://www.microsoft.com/technet/scr...4/hey1214.mspx

    One must 'move' an LDAP object to alter it's CN. Which explains the problems I was having.

    wiseman, any chance of changing your script so it handles CN moves?
    If the CN is based on another attribute my PasswordControl/BulkModify app will work (use the script for other attribute modifications).

    The script could probably be modified to handle the cn attribute - I might look at this when I get chance (I'm away for the weekend so don't know when I'll get round to it).

  5. #20

    Ric_'s Avatar
    Join Date
    Jun 2005
    Location
    London
    Posts
    7,599
    Thank Post
    109
    Thanked 764 Times in 595 Posts
    Rep Power
    181
    @Geoff: Why not use CSVDE to export your existing users to a CSV, edit the file and then perform the import after deleting the original users?

  6. #21

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,804
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    Because I'd have to reset their passwords.

  7. #22
    Wiseman82's Avatar
    Join Date
    Jan 2006
    Location
    North East
    Posts
    48
    Thank Post
    3
    Thanked 14 Times in 11 Posts
    Rep Power
    21
    It was an easy change to add support for the common-name(cn) attribute:

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

    Hope this helps.

  8. Thanks to Wiseman82 from:

    Geoff (27th February 2008)

  9. #23
    Wiseman82's Avatar
    Join Date
    Jan 2006
    Location
    North East
    Posts
    48
    Thank Post
    3
    Thanked 14 Times in 11 Posts
    Rep Power
    21
    Someone asked about using the "mail" attribute to match their csv data with users in Active Directory. I decided to update the script to allow users to choose the attribute used to search (rather than hard-coded for sAMAccountName).

    Simply change the strSearchAttribute to "mail" to get this to work.

    Other users might want to use the userPrincipalName or other attributes to match rows in the csv file with users in AD.


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

  10. #24
    BarryWAaMC's Avatar
    Join Date
    Oct 2009
    Posts
    22
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Bulk changes to AD

    Hi,

    I am trying to do exacly the same process. I need to add the student enrolment numbers to my students AD account.

    I have tried to use CSVDE, but it doesn't allow you to overwrite existing accounts.
    It will only import or export, it won't let you update.

    If anyone has come up with a solution to bulk editing ad accounts, I would be most interested in it.

    Thanks,

    Barry.

  11. #25


    Join Date
    Jan 2006
    Posts
    8,202
    Thank Post
    442
    Thanked 1,032 Times in 812 Posts
    Rep Power
    339

  12. #26
    jsnetman's Avatar
    Join Date
    Oct 2007
    Posts
    887
    Thank Post
    23
    Thanked 134 Times in 126 Posts
    Rep Power
    40
    You can use DSMOD to change attributes. I had to to it a while back to fill in information for our exchange server. You create a spread sheet with all your users and then add the entries as follows. You can export your users using dsmod or csvde I can't remember which one. and insert them into the sheet

    dsmod user "CN=testpupil,OU=Intake02,OU=student,OU=Accounts,D C=jschs,DC=local" -fn Joe -ln Bloggs -desc PUPIL -office SM -dept SM -company "Your school"

    You then export it from excel to a text file and then change it to a bat file and run it on your domain controller. You can change any attribute you like.
    Last edited by jsnetman; 2nd November 2009 at 11:39 AM.

  13. #27
    kennysarmy's Avatar
    Join Date
    Oct 2005
    Location
    UK
    Posts
    1,300
    Thank Post
    80
    Thanked 46 Times in 32 Posts
    Rep Power
    31
    I used this recently
    AD Infinitum download from Networking category

    30 day demo gave me enough time to make all the changes I needed to...

    reads in from a CSV file and I added all students first name and surname

    was a breeze...

  14. #28

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,657
    Thank Post
    657
    Thanked 1,624 Times in 1,453 Posts
    Rep Power
    422
    Does ADModify work for these attributes?

    Ben

  15. #29

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,685
    Thank Post
    850
    Thanked 899 Times in 744 Posts
    Blog Entries
    9
    Rep Power
    329
    Quote Originally Posted by CyberNerd View Post
    IMHO this is the best answer

    I use wisesoft quiet a lot. I believe the author of the software was a member of these forums (don't know if he still is).

  16. #30

    Join Date
    Nov 2008
    Posts
    4
    Thank Post
    2
    Thanked 2 Times in 2 Posts
    Rep Power
    0
    Bit of an old thread, but i'm doing this just now. I'm in the process of updating my AD fields, i use the addusers command line tool which only fills in the display name, not first/last name.

    I created a csv with student logon, name and surname in separate columns, then mailmerged it with the following:

    dn: CN=<logon>,OU=Year XX Students,OU=School Students,OU=School Users,OU=School Name,OU=Schools,DC=Education
    changetype: modify
    replace: givenName
    givenName: <name>
    -
    replace: sn
    sn: <surname>
    -
    replace: mail
    mail: <logon>@domain.edu
    -
    replace: userPrincipalName
    userPrincipalName: <logon>@domain
    -
    changeType: modrdn
    newRdn: CN=<name> <surname>,OU=Year XX Students,OU=School Students,OU=School Users,OU=School Name,OU=Schools,DC=Education
    deleteOldRdn: 1

    You need to make sure there's one blank line between each record, then use ldifde to import the file. Command line is
    ldifde -i -f filename.txt -s server
    You can also add -j <path> for logging, -v for verbose and -k for ignoring the 'object does not exist' error.

    Bit longwinded but it seems to work.

  17. Thanks to rgriffiths from:

    xenonive (25th June 2013)

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

Similar Threads

  1. Active Directory - Single and Bulk User creation and FREE!!
    By siuko in forum How do you do....it?
    Replies: 39
    Last Post: 20th June 2012, 11:29 AM
  2. Active Directory-Script for Creating Bulk Users
    By calapso in forum How do you do....it?
    Replies: 8
    Last Post: 14th January 2009, 06:32 PM
  3. Replies: 26
    Last Post: 19th May 2008, 11:54 PM
  4. Update Active Directory with mySQL table data?
    By netadmin in forum Windows
    Replies: 8
    Last Post: 30th October 2007, 10:43 PM
  5. Replies: 3
    Last Post: 16th November 2006, 09:55 PM

Thread Information

Users Browsing this Thread

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

Tags for this Thread

Posting Permissions

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