Hello everyone,
I’m trying to build a report on audit DB, to get the reports last access date viewed or run,
but the results that I get from the field ADS_EVENT.Start_Time is not accurate,
This the query I use:
SELECT
ADS_EVENT.Object_Name,
Convert(VARCHAR(8),ADS_EVENT.Start_Time,112),
ADS_EVENT_CATEGORY_STR.Event_Category_Name,
ADS_EVENT_TYPE_STR.Event_Type_Name,
ADS_EVENT.Top_Folder_Name,
ADS_EVENT.Object_Folder_Path,
ADS_OBJECT_TYPE_STR.Object_Type_Name,
CAST( ADS_EVENT.Start_Time AS CHAR ),
ADS_EVENT.User_Name
FROM
ADS_EVENT_TYPE_STR INNER JOIN ADS_EVENT_TYPE ON (ADS_EVENT_TYPE.Event_Type_ID=ADS_EVENT_TYPE_STR.Event_Type_ID AND ADS_EVENT_TYPE_STR.Language = ‘en’)
INNER JOIN ADS_EVENT ON (ADS_EVENT.Event_Type_ID=ADS_EVENT_TYPE.Event_Type_ID)
INNER JOIN ADS_OBJECT_TYPE_STR ON (ADS_EVENT.Object_Type_ID=ADS_OBJECT_TYPE_STR.Object_Type_ID AND ADS_OBJECT_TYPE_STR.Language = ‘en’)
INNER JOIN ADS_EVENT_CATEGORY_STR ON (ADS_EVENT_TYPE.Event_Category_ID=ADS_EVENT_CATEGORY_STR.Event_Category_ID AND ADS_EVENT_CATEGORY_STR.Language = ‘en’)
WHERE
(
ADS_OBJECT_TYPE_STR.Object_Type_Name IN ( ‘Web Intelligence’ )
AND
ADS_EVENT_TYPE_STR.Event_Type_Name IN ( ‘Run’,‘View’,‘Refresh’ )
)