none
SQL to Communicate With Active Directory RRS feed

  • Question

  • Experts please help,

    Objective:

    1. Add users to existing OUs in Active Directory using SQL
    2. Modify user records in Active directory (AD) using SQL, including add/change member of security group

    Method:

    Build SQL stored procedures with input parameters to update AD either using SQL or PowerShell script  

    AD items to add/change using SQL

    General:

    • First name
    • Last Name
    • Display Name
    • Description
    • Telephone Number
    • E-mail

    Address:

    • Street
    • P.O. Box
    • City
    • State/Province
    • Zip/Postal Code
    • Country/region

    Account:

    • User login name @

    Profile:

    • Home folder
      • Connect K: to \\xxx.xxx.xx.x\Users\[User login name]

    Telephones:

    • Home
    • Pager
    • Mobile
    • Notes

    Organization:

    • Job Title
    • Department

    Member of:

    • Add Domain User = Default
    • Ability to add user to existing security group

    Will also need:

    • SQL to pull list of existing OUs
    • SQL to pull list of existing security groups

     

    Monday, July 8, 2019 8:12 PM

All replies