LBI Report Usage Statistics

I've Created some Simple SQL Statements you can run from SSMS or Crystal -

------ Who ran what most recently------------
SELECT Upper(USERID) [USERID]
,DASHLINKID
,DASHLINKNAME
,REQUESTTIME
,DASHLINKURL
,USERIP
,ACCESSVALUE
FROM LawsonFS.dbo.FS_AUDIT
Order by REQUESTTIME desc

---- What has been run most frequently ------
SELECT
COUNT(DASHLINKID) [COUNT]
,DASHLINKID
,DASHLINKNAME
,DASHLINKURL
FROM LawsonFS.dbo.FS_AUDIT
Group by DASHLINKID,DASHLINKNAME,DASHLINKURL
Order by COUNT(DASHLINKID) desc

-- Each User First / Last time Ran LBI Report ---------
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)

I've got a real simple report that I seem to find helpful. There are no parameters in the report, so it will return everything that is contained in the audit table... so you'll have to limit it to your liking, but this should get you a start.

Interesting. How can I turn on Audit?

I would also be interested in knowing how to turn on the audit.

I was able to get Greg's report to work but we have no data in the audit table.

You'll need to do this in all 3 spots Framework, Reporting, and SmartNotifications (if you want it in all 3).
From the Tools dashboard, select System Settings. The very last thing on the page should be 'Allow Dashboard Audit'
Set this to Yes. Save Changes, and re-start the App Server.
For Reporting: From Reporting Services Administration - select System Settings. Set 'Document Audit' to True.
For SN: From the Admin button, select System Config Assistant. Set 'Audit User Requests' to Yes. Save and re-start App Server.

Xin Li: What version of LBI are you on? Perhaps you'll need to upgrade to get the auditing feature.

Unfortunately I cant see it either. Does anyone know of any other way to turn the audits on?

Are you both Admins to LBI? -- In the LBI administrator group? From Tools dashboard | System Settings | 'Administrative Resource Manager Group'
I believe that is the only way that these options may show up.