Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

LBI Report Utilization

 8 Replies
 2 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
thummel1
Veteran Member
Posts: 121
Veteran Member
9/14/2015 4:30 PM
    Hi,

    We are in the process of preparing for an LBI upgrade. As part of preparations, we would like to understand LBI report utilization, that is, how frequently are our 400+ LBI reports in Production being used. Knowing this information will help us better prepare and prioritize our work. Is there a feature in LBI that will tell us how often each report is utilized, and perhaps by which Users or which User Security Groups?

    Thank you!
    Randy
    Veteran Member
    Posts: 50
    Veteran Member
    9/14/2015 4:56 PM
      I put some SQL together a while back that shows some of that info. Who's running what, when. I know you can turn on LBI auditing, but I found it placed a lot of records in the table that a bit confusing, we turned it back off.

      I'll try to did out the SQL if that would be useful?


      thummel1
      Veteran Member
      Posts: 121
      Veteran Member
      9/14/2015 5:14 PM
        Hi,

        Yes, if you have SQL that you can share that would be great.
        Randy
        Veteran Member
        Posts: 50
        Veteran Member
        9/14/2015 6:10 PM





          /* Current Run */
          SELECT Upper(USERID) [USERID]
          ,DASHLINKID
          ,DASHLINKNAME
          ,REQUESTTIME
          ,DASHLINKURL
          ,USERIP
          FROM LawsonFS.dbo.FS_AUDIT
          Order by REQUESTTIME desc



          /* Report Utilization */
          SELECT
          COUNT(DASHLINKID) [COUNT]
          ,DASHLINKID
          ,DASHLINKNAME
          ,DASHLINKURL
          FROM LawsonFS.dbo.FS_AUDIT
          Group by DASHLINKID,DASHLINKNAME,DASHLINKURL
          Order by COUNT(DASHLINKID) desc


          /* User Utilization by Last Access */
          Select
          Upper(USERID) [USERID]
          ,Count(DASHLINKID) [COUNT]
          ,MAX(REQUESTTIME) [LAST ACCESS]
          ,MIN(REQUESTTIME) [FIRST ACCESS]
          FROM LawsonFS.dbo.FS_AUDIT
          Group by USERID
          Order by MAX(REQUESTTIME)
          thummel1
          Veteran Member
          Posts: 121
          Veteran Member
          9/14/2015 6:25 PM
            Thank you for this information. What version of Lawson do you need to be able to access this, or does that not matter? We will be upgrading to version 10 in the next month.
            Wondering if this table name "FS_AUDIT" is available in all versions?
            Greg Moeller
            Veteran Member
            Posts: 1498
            Veteran Member
            9/14/2015 6:38 PM
              No, it isn't available in all releases. The earliest document that I have where it shows up is in version 10.2.x
              thummel1
              Veteran Member
              Posts: 121
              Veteran Member
              9/14/2015 6:53 PM
                Thank you. We are on version 9.0.1. It sounds like this feature may not be available for us until we upgrade to 10 in about a month.
                Donna
                Veteran Member
                Posts: 110
                Veteran Member
                9/21/2015 3:42 PM
                  How do you identify the dashboard with the report display? We have found the statistics and the report names as well as other Idneitifcation but have not found a table with the dashboard identity.

                  Thank you.

                  Donna
                  Donna
                  Veteran Member
                  Posts: 110
                  Veteran Member
                  10/9/2015 3:05 PM
                    I found the url for the report with the report number in the string in the field ENPENTRYATTR.ATTRSTRINGVALUE. The key field that controls access to the url is
                    ENPENTRYATTR. ATTRID and on our system the ATTRID value is 8. The additional filter that you may need is ENPBATREE.ENTRYCATEGORY, the value 57 works for our reports.

                    With these fields I am able to create a report that includes the Dashboard with the Dashboard name, Report ID from Lawson FS and link to other report fields in .Lawson RS.