+ Post New Thread
Page 2 of 3 FirstFirst 123 LastLast
Results 16 to 30 of 32
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,803
    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,803
    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,803
    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,590
    Thank Post
    109
    Thanked 762 Times in 593 Posts
    Rep Power
    180
    @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,803
    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
    39
    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,286
    Thank Post
    80
    Thanked 45 Times in 31 Posts
    Rep Power
    30
    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,343
    Thank Post
    624
    Thanked 1,584 Times in 1,421 Posts
    Rep Power
    414
    Does ADModify work for these attributes?

    Ben

  15. #29

    Join Date
    Jul 2010
    Posts
    3
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    In case the issue is still open to anybody, there is a solution called Softerra Adaxes (http://www.adaxes.com). Its functions set covers bulk update of Active Directory user info. Features - Business Units for objects in different domains & Basket for objects in the same domain. Thanks.

  16. #30

    tmcd35's Avatar
    Join Date
    Jul 2005
    Location
    Norfolk
    Posts
    5,628
    Thank Post
    845
    Thanked 884 Times in 732 Posts
    Blog Entries
    9
    Rep Power
    326
    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).

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 3 users browsing this thread. (0 members and 3 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
  •