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.