cancel
Showing results for 
Search instead for 
Did you mean: 

Audit View Count (By opening, by Running,By Clicking a link)

Former Member
0 Kudos
42

Hi, Running the query below and need to know if this one would give the exact count of any report viewed by running manually the report or view from instance or view by clicking a viewer link sent via email.

Any help or ideas appreciated. I'm assuming this is the same for XIR2 and XI 3.1

Thanks,

SELECT

top 1000

AUDIT_EVENT.Start_Timestamp,

AUDIT_EVENT.Event_ID,

AUDIT_EVENT.Event_Type_ID,

EVENT_TYPE.Event_Type_Description,

DERIVED_OBJECT_NAME.Detail_Text,

AUDIT_EVENT.User_Name

FROM

AUDIT_EVENT,

EVENT_TYPE,

( select

AUDIT_EVENT.Server_CUID, AUDIT_EVENT.Event_ID, cast(AUDIT_DETAIL.Detail_Text as nvarchar(128)) as Detail_Text

from AUDIT_EVENT, AUDIT_DETAIL

where

(AUDIT_EVENT.Server_CUID = AUDIT_DETAIL.Server_CUID) and

(AUDIT_EVENT.Event_ID = AUDIT_DETAIL.Event_ID) and

(AUDIT_DETAIL.Detail_Type_ID = 3)

) DERIVED_OBJECT_NAME

WHERE

( AUDIT_EVENT.Event_Type_ID=EVENT_TYPE.Event_Type_ID )

AND ( AUDIT_EVENT.Event_ID=DERIVED_OBJECT_NAME.Event_ID and AUDIT_EVENT.Server_CUID=DERIVED_OBJECT_NAME.Server_CUID )

AND AUDIT_EVENT.Event_Type_ID In ( 131073,131074,196609,196610 ,65537 )

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I doubt that Auditing is same in R2 and 3.1. Client tool activity added from 3.

From Xi 3 onwards, I think it shouldn't matter how you access the report. It should capture all the events.

If you have Auditor configured, it comes with some standard reports. You can edit either "Least Accessed reports" or "Most Accessed Reports" and remove the Ranking from the reports. You'll get all reports statistics.

Note: Refresh events are not captured in case of Crystal Reports.