Lawson Security Reports

 9 Replies
 0 Subscribed to this topic
 15 Subscribed to this forum
Sort:
Author
Messages
Arvin Ojales
Advanced Member
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
    Posts: 82
    Veteran Member
      This is very nice, can you put out any other pieces of the code?
      KazS
      New Member
      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
        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
          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
            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
              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
                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
                  Posts: 62
                  Veteran Member
                    How could you map Security class to the access they have?
                    Jeff Shumate
                    Advanced Member
                    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.