Read attribute from excel write in Active Directory RRS feed

  • Question

  • Hi all,

     i need some help...

    I have an excel file with 2 column : one with samaccount name and  the second with and ID

    what i need is a script that read samaccount name and write in active directory the ID in P.O. Box attribute that matches samaccount

    Someone could help me please?



    Tuesday, December 2, 2014 9:56 AM

All replies

  • Hi,

    Here we only provide logical support of exiting scripts not writing new scripts.

    So, please share your script what did you tried ?

    however just to give Idea below is one sample script

    <p>Import-module ActiveDirectory 
    Import-CSV "C:\Scripts\Users.csv" | % {
    $User = $_.UserName
    $ID = $_.EmployeeID
    Set-ADUser $User -employeeID $ID
     </p><p>please mark it as answer if it helps </p>

    • Proposed as answer by STscripter Tuesday, December 2, 2014 10:39 AM
    Tuesday, December 2, 2014 10:37 AM