LSA tables for creating a report

Sort:
You are not authorized to post a reply.
Author
Messages
Kate Liamero
Veteran Member
Posts: 70
Veteran Member

    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
    Veteran Member
    Posts: 109
    Veteran Member
      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
      Veteran Member
      Posts: 1498
      Veteran Member
        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.