PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/14/2016 12:03 PM by  Jeff Shumate
Lawson Security Reports
 9 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Arvin Ojales
Private
Private
Advanced Member
(66 points)
Advanced Member
Posts:24


Send Message:

--
03/17/2010 11:38 AM

    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
    Tags: lawson security, lawson security reporting, ls
    MattM
    Private
    Private
    Veteran Member
    (214 points)
    Veteran Member
    Posts:82


    Send Message:

    --
    03/17/2010 12:10 PM
    This is very nice, can you put out any other pieces of the code?
    KazS
    President
    Kaz and Company, Inc.
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    03/17/2010 12:25 PM

    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
    Private
    Private
    Advanced Member
    (66 points)
    Advanced Member
    Posts:24


    Send Message:

    --
    03/18/2010 11:07 AM
    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
    Private
    Private
    Veteran Member
    (216 points)
    Veteran Member
    Posts:94


    Send Message:

    --
    03/19/2010 5:11 AM
    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
    Private
    Private
    Advanced Member
    (66 points)
    Advanced Member
    Posts:24


    Send Message:

    --
    03/25/2010 9:49 PM

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

    K
    Private
    Private
    New Member
    (3 points)
    New Member
    Posts:1


    Send Message:

    --
    07/22/2010 1:40 PM
    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
    Private
    Private
    Advanced Member
    (66 points)
    Advanced Member
    Posts:24


    Send Message:

    --
    07/22/2010 1:51 PM
    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
    System admin
    Independent
    Veteran Member
    (127 points)
    Veteran Member
    Posts:61


    Send Message:

    --
    10/13/2016 7:05 PM
    How could you map Security class to the access they have?
    Jeff Shumate
    Private
    Private
    Advanced Member
    (87 points)
    Advanced Member
    Posts:29


    Send Message:

    --
    10/14/2016 12:03 PM
    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.
    You are not authorized to post a reply.