Lawson Security Reports

 9 Replies
 0 Subscribed to this topic
 15 Subscribed to this forum
Sort:
Author
Messages
Arvin Ojales
Advanced Member Send Private Message
Posts: 24
Advanced Member

I implemented a Lawson Security Reporting that is viewable via Web browser. With a simple XSL transformation, HTML and JavaScripting I created a web site that will render the RM informations to a web browser.  I was able to report the ff informations:

Roles, Security Classes, Rules, Roles attached to a user, all security policies for a user, all users that has access to specific form and the type of access, date stamp and userid when a security class was last modified.

See attachment for screen shots. I wanted to share this information to the group and how I created this report.

The report relies on the lsdump output XML file, I used the XML file and transform it to HTML using XSL stylesheets, if the lsdump scrpt is change on future lawson release, then you may or may not need to change your XSL documents, depends on the changes to the XML output file.

I scheduled the lsdump script to run every night in recdef, that will refresh my XML file, after the dump, I have another script to split the XML file into two parts for performance reason. Once the XML files are out, I use that to render the data in the web browser.

Arvin Ojales Sr. Systems Analyst/Programmer Park Nicollet Health Services

 

 

 

 

 

 

Attachments
MattM
Veteran Member Send Private Message
Posts: 82
Veteran Member
This is very nice, can you put out any other pieces of the code?
KazS
New Member Send Private Message
Posts: 1
New Member

THIS IS AWESOME!!  Would you be willing to share the code written for this utility?   Can you share any of the complexity in getting set up?

Thank you kindly,

Kevin

Arvin Ojales
Advanced Member Send Private Message
Posts: 24
Advanced Member
Matt, Kaz, please send me an email arvin.ojales@parknicollet.com and I will try to zip and send the code, setting this up is just a matter of FTPing the scripts and codes to your web directories in your server, I created this in unix and compatible with IE browser since IE is the only browser we are using here.
Saurabh
Veteran Member Send Private Message
Posts: 94
Veteran Member
Hi Arvin, This looks realy great. I have emailed you a request as i think this is something I could utilise for my organisation to answer queries of who has what access etc Thanks in advance Saurabh
Arvin Ojales
Advanced Member Send Private Message
Posts: 24
Advanced Member

I apologize, I thought I can share this code, but due to company policy I cannot send the code to those interested.

K
New Member Send Private Message
Posts: 1
New Member
Hi Arvin, Can you tell us the source tables used to create the reports? I'm trying to re-create via ODBC connection: *Form ID Security Report *User Information Listing
Arvin Ojales
Advanced Member Send Private Message
Posts: 24
Advanced Member
This aren't LAUA security report so it is not in any tables, because this are Lawson Security, the result of the lsdump script is the source for this report. If you want direct connection, you may be able to connect to your LDAP using the OLEDB provider for Microsoft directrory services driver. Arvin Ojales
xxxxxttysfh
Veteran Member Send Private Message
Posts: 62
Veteran Member
How could you map Security class to the access they have?
Jeff Shumate
Advanced Member Send Private Message
Posts: 31
Advanced Member
Are you hoping to see all the tokens, etc. that a security class has assigned to it? If so, I run a user report for a user I know has that security class, and send it to CSV. It is easy to sort and eliminate other security classes, then you can see what access is associated with your security class.