PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 05/29/2015 9:26 AM by  Greg Moeller
LSA tables for creating a report
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Kate Liamero
Private
Private
Veteran Member
(144 points)
Veteran Member
Posts:70


Send Message:

--
05/28/2015 4:34 PM

    I want to create a security report to see which users are active along with their email , who has add-ins, the RMID, SSOP id and requester name.  I need info from all 3 segments RM, Identities and Environment.  Can anyone tell me what tables I need? 

    Thanks Kate

    Carl.Seay
    Private
    Private
    Veteran Member
    (295 points)
    Veteran Member
    Posts:101


    Send Message:

    --
    05/28/2015 7:47 PM
    Environment data is in GEN.R_USER, but everything else is in the Lawson LDAP. It is possible (difficult) to write LDAP queries against it, however there are several third party products available to easily report off it. One of which is sold on this website
    Greg Moeller
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    05/29/2015 9:26 AM
    If you are on a Unix platform for LSF, I can share some scripts that may get you close to what you need.
    You are not authorized to post a reply.