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

30 Views

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 )