• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

Report Auditing

 6 Replies
 0 Subscribed to this topic
 22 Subscribed to this forum
Sort:
Author
Messages
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
11/15/2013 3:31 PM
Since we are now on version 10 of LBI, I've been asked by several users to turn report auditing on.
I've successfully done that and written an audit report with some of the information that the users wanted in it.

My question comes in here. I turned auditing on at 17:00 on the 13th, now at 10:30 on the 15th, I already have 340 rows in the table.

Can I just have my DBA strip the table of older data from the table going forward? Maybe just keep a quarters worth, and strip the rest?
Donna
Veteran Member
Posts: 110
Veteran Member
3/27/2014 4:35 PM
Greg,

Unfortunately, I don't have the answer to your question but I wondered if you are tracking the report activity run time or last run time? We would like to use this statistic to identify inactive reports.

Thank you.

Donna
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
3/27/2014 5:21 PM
Donna:
We are using the REQUESTTIME field.

*Note: I have written a report for last run time that doesn't rely on turning the report auditing on. Let me see if I can dig that one up for you.
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
3/27/2014 5:24 PM
Found it!

See attached.
Attachments
Donna
Veteran Member
Posts: 110
Veteran Member
3/27/2014 6:49 PM
You are the best! Thank you.
Donna
Veteran Member
Posts: 110
Veteran Member
3/27/2014 6:58 PM
Greg,

My system evidently is not populating these fields because the value displayed in both fields is 13-Dec-1901 8:45pm and it appears to only print the scheduled reports.

We will probably need to use the auditing after all. But you are still the best because of your generous sharing of support and information.

Donna
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
3/28/2014 8:01 PM
Perhaps your system is different than ours.. Ours is running an Oracle database, SQL would likely be different. Yes, the report is only for scheduled reports.