PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 03/28/2014 4:01 PM by  Greg Moeller
Report Auditing
 6 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Greg Moeller
Private
Private
Veteran Member
(4028 points)
Veteran Member
Posts:1434


Send Message:

--
11/15/2013 10:31 AM
    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
    Private
    Private
    Veteran Member
    (266 points)
    Veteran Member
    Posts:110


    Send Message:

    --
    03/27/2014 12: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
    Private
    Private
    Veteran Member
    (4028 points)
    Veteran Member
    Posts:1434


    Send Message:

    --
    03/27/2014 1: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
    Private
    Private
    Veteran Member
    (4028 points)
    Veteran Member
    Posts:1434


    Send Message:

    --
    03/27/2014 1:24 PM
    Found it!

    See attached.
    Attachments
    Donna
    Private
    Private
    Veteran Member
    (266 points)
    Veteran Member
    Posts:110


    Send Message:

    --
    03/27/2014 2:49 PM
    You are the best! Thank you.
    Donna
    Private
    Private
    Veteran Member
    (266 points)
    Veteran Member
    Posts:110


    Send Message:

    --
    03/27/2014 2: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
    Private
    Private
    Veteran Member
    (4028 points)
    Veteran Member
    Posts:1434


    Send Message:

    --
    03/28/2014 4: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.
    You are not authorized to post a reply.