PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/1/2018 1:03 PM by  TBonney
Update user's attributes in AD
 3 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Rkapoor
Admin
Private
Basic Member
(22 points)
Basic Member
Posts:10


Send Message:

--
9/19/2018 4:47 PM

    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
    Private
    Private
    Veteran Member
    (1438 points)
    Veteran Member
    Posts:510


    Send Message:

    --
    9/20/2018 3:44 PM
    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
    Private
    Private
    Advanced Member
    (93 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    9/20/2018 3:58 PM
    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
    Private
    Private
    Veteran Member
    (637 points)
    Veteran Member
    Posts:273


    Send Message:

    --
    10/1/2018 1:03 PM

    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.

    You are not authorized to post a reply.