Prev
Next
Forums Infor / Lawson Platforms S3 Security

LSA tables for creating a report

 2 Replies
 2 Subscribed to this topic
 15 Subscribed to this forum
Sort:
Author
Messages
Kate Liamero
Veteran Member
Posts: 70
Veteran Member
5/28/2015 8: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
    Veteran Member
    Posts: 109
    Veteran Member
    5/28/2015 11: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
      Veteran Member
      Posts: 1498
      Veteran Member
      5/29/2015 1:26 PM
        If you are on a Unix platform for LSF, I can share some scripts that may get you close to what you need.