PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/09/2015 11:05 AM by  Donna
LBI Report Utilization
 8 Replies
Sort:
You are not authorized to post a reply.
Author Messages
thummel1
Data Analyst II
Fairview Health Services
Veteran Member
(183 points)
Veteran Member
Posts:101


Send Message:

--
09/14/2015 12: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
    Systems Administrator
    Rochester Regional Health
    Advanced Member
    (85 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    09/14/2015 12: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
    Data Analyst II
    Fairview Health Services
    Veteran Member
    (183 points)
    Veteran Member
    Posts:101


    Send Message:

    --
    09/14/2015 1:14 PM
    Hi,

    Yes, if you have SQL that you can share that would be great.
    Randy
    Systems Administrator
    Rochester Regional Health
    Advanced Member
    (85 points)
    Advanced Member
    Posts:31


    Send Message:

    --
    09/14/2015 2: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
    Data Analyst II
    Fairview Health Services
    Veteran Member
    (183 points)
    Veteran Member
    Posts:101


    Send Message:

    --
    09/14/2015 2: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
    Private
    Private
    Veteran Member
    (3873 points)
    Veteran Member
    Posts:1377


    Send Message:

    --
    09/14/2015 2: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
    Data Analyst II
    Fairview Health Services
    Veteran Member
    (183 points)
    Veteran Member
    Posts:101


    Send Message:

    --
    09/14/2015 2: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
    Private
    Private
    Veteran Member
    (256 points)
    Veteran Member
    Posts:106


    Send Message:

    --
    09/21/2015 11:42 AM
    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
    Private
    Private
    Veteran Member
    (256 points)
    Veteran Member
    Posts:106


    Send Message:

    --
    10/09/2015 11:05 AM
    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.
    You are not authorized to post a reply.