PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 08/19/2015 4:22 PM by  Jared Lytle
compare AD to HR11 termed users
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Jared Lytle
Financial Application Specialist
University Medical Center
New Member
(8 points)
New Member
Posts:6


Send Message:

--
08/19/2015 4:22 PM

    We are attempting to do some clean up in Lawson Security / Active Directory.

    I don't have much experience with querying against AD or ATOMS in LDAP, but has anyone developed a sql query that allows visibility of users that have been termed in HR11 in the last 30 days then compare that to any LDAP information so we can display what AD accounts should be inactivated?

    Currently, we use a manual process in which we take a similar query below and security manually inactivates users in ActiveDirectory.

    SELECT E.EMPLOYEE
    , E.FIRST_NAME
    , E.LAST_NAME
    , E.TERM_DATE
    FROM EMPLOYEE E
    WHERE E.EMP_STATUS IN ('TE','TP')
    AND E.TERM_DATE BETWEEN DATEADD(DAY, -30, GETDATE()) AND DATEADD(DAY, 0, GETDATE())
    ORDER BY E.TERM_DATE ASC

     

    Any best practices for "terming" people in Lawson Security would be helpful also. We currently delete the users out of the LSA tool once the term is generated.

    You are not authorized to post a reply.