Sign in
 
HomeWindows Server 2012Windows Server 2008 R2Windows Server 2003LibraryForums
Windows Server TechCenter >
> 
> 
Updating user fields within AD

已答复 Updating user fields within AD

  • Sunday, February 26, 2012 10:23 PM
     
     
    Sign In to Vote
    0

    Hi,

    Is there a recommended/easy way (step by step instructions) to update hundreds of user property information like description, address, phone, office, job title, etc.?

    I see that you can Export the whole AD by CSVD but is there a way to only do it by an Organizational Unit?  Would like to update the user property info in a spreadsheet then import it back into AD but haven't found a simple way to do that and not a scripting guru.

    Also read some other posts but again haven't found a standardized way of adding additional fields to the Users properties like Employee number.

    Thank you

     

All Replies

  • Sunday, February 26, 2012 11:08 PM
     
     Answered
    Sign In to Vote
    0

    I have a PowerShell script in the gallery that updates users in bulk according to the information in an Excel spreadsheet here:

    http://gallery.technet.microsoft.com/Update-AD-Users-in-Bulk-ca0068f1

    However, this only handles single-valued string attributes. Unfortunately, the description attribute is multi-valued, even though there is never more than one value. I also have two VBScript versions linked below, one of which supports multi-valued attributes and many more datatypes (UpdateUsers2.vbs):

    http://www.rlmueller.net/UpdateUsers.htm

    Richard Mueller - MVP Directory Services

     
  • Sunday, February 26, 2012 11:49 PM
     
     
    Sign In to Vote
    0
    I believe the command CSVDE -i -f filename.csv -k will import the user properties fine.  Now I need to figure out how to lay out the excel spreadsheet to import the proper fields into AD with the proper data properties.
     
  • Monday, February 27, 2012 12:30 AM
     
     Answered
    Sign In to Vote
    0

    You must specify the LDAPDisplayNames of the attributes for csvde. If you need help with the attribute names, refer to the first spreadsheet on this page, which documents the attribute names on many of the tabs in ADUC for user properties:

    http://www.rlmueller.net/UserAttributes.htm

    The second spreadsheet documents all attributes in Active Directory, indicating which apply to users (and groups, computers, etc), syntax, etc. You would have a header row in your spreadsheet, specifying the attribute names. Then you would save as a csv.

    Richard Mueller - MVP Directory Services

     
  • Monday, February 27, 2012 2:39 AM
     
     
    Sign In to Vote
    0

    Created a user with all fields populated and exported with CSVDE.  Noticed there's a column for EmployeeNumber but in the AD GUI when filling in fields there's no option to enter any info?  Is there a way to get this viewed within the GUI?

    Thanks

     
  • Tuesday, February 28, 2012 7:24 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi,

    Thank you for the post.

    To view the EmployeeNumber:
    Open ADUC, click view menu--checked Advanced Features, select your user account--Properties--Attribute Editor--find the EmployeeNumber in the list.

    If there are more inquiries on this issue, please feel free to let us know.

    Regards

    Rick Tan

    TechNet Community Support

     
  • Wednesday, February 29, 2012 12:47 AM
     
     
    Sign In to Vote
    0

    Rick,

    The Attribute Editor tab within the ADUC GUI you can input an employee number but it would be nice to replace something like P.O. Box field with an Employee number field that our staff can enter/view the Employee number within the GUI.

    Thanks