Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
LBI Report Utilization
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Chris Radcliffe
Past 24 Hours:
0
Prev. 24 Hours:
0
Overall:
5187
People Online:
Visitors:
383
Members:
0
Total:
383
Online Now:
New Topics
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Lawson Business Intelligence/Reporting/Crystal
Domain Name Change
3/5/2024 7:45 PM
Our domain name needs to change and was hoping I c
S3 Customization/Development
Cobol calling Shell Script
2/29/2024 1:27 PM
Has anyone created or modified a Lawson Cobol prog
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1351
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
LBI Report Utilization
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
thummel1
Veteran Member
Posts: 121
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
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
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
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
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
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
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
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
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.
You are not authorized to post a reply.