• Search Forums
    Advanced Search Topics Posts
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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 Send Private Message
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.