Update user's attributes in AD

 3 Replies
 1 Subscribed to this topic
 52 Subscribed to this forum
Sort:
Author
Messages
Rkapoor
Basic Member
Posts: 10
Basic Member

    Goal  - Capture employee changes from Lawson and update AD attributes with new changes, such as phone number/Manager's info/Activate/Deactivate user.

    I am planning to read HRHistory table to capture the changes at end of the day into CSV file, then  update AD with new information.

    Is it possible to use sycmd node to run power-shell script to update AD?

     

     

    JimY
    Veteran Member
    Posts: 510
    Veteran Member
      I execute Perl scripts using a syscmd node so I don't know why you couldn't. Have you tried this:

      powershell.exe -File D:\directory\power_shell_script.ps1
      Jeff Shumate
      Advanced Member
      Posts: 31
      Advanced Member
        If you are on prem, you should be able to do a syscmd. If you are ST or MT, things get more complicated. Check your sys cmd tab on your configuration to make sure you know what machine you are running the command on. We just drop a CSV fie of employee changes and have a scheduled powershell script pick it up later in the day to update our AD.
        TBonney
        Veteran Member
        Posts: 281
        Veteran Member

          Jeff,

          Would you be willing to share any portion of this process, either publicly or privately?

          We will be going through an cleanup and integration of 2 separate Active Directories and migration to a new domain this year. I wonder if this D update process might be helpful in identifying which profiles are true (active) user profiles that need to be transitioned to the new domain as part of this AD cleanup & consolidation process. I'm thinking if we could update some field in AD with a static value that uniquely links it to a specific person's Lawson userid, that would identify that profile as an active Lawson user, and thus an active employee whose profile needs to be copied to the new domain. (The two existing domains being consolidated have numerous accounts that either have not been properly maintained, so part of the migration will need to include a high volume of cleansing of the existing directories prior to consolidating them into a new one.)

          Thank you.