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 Send Private Message
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 Send Private Message
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 Send Private Message
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.