SAP Webi Reports- Last refresh time.

[former_member661363]

Hi All,

I want to understand how we can extract list of all Webi reports with their last refresh time using audit database.

I can find the last executed time of the instances which are created on reports but unable to find the "Reports last refreshed time".

I have created below query.

SELECT max(A.Start_time) as Start_time ,Object_ID ,A.Object_Name ,C.Object_Type_Name ,A.Object_Type_ID ,A.Object_Folder_Path ,Duration_ms ,Added_To_ADS ,User_ID ,User_Name ,Action_ID ,A.Event_Type_ID ,B.Event_Type_Name ,A.Status_ID ,E.Status_Name ,A.Event_ID --,G.Event_Detail_Value ,A.Service_Type_ID ,F.Service_Type_Name FROM ADS_EVENT A INNER JOIN ( SELECT * FROM [dbo].[ADS_EVENT_TYPE_STR] WHERE Language ='EN' )B ON A.Event_Type_ID=B.Event_Type_ID INNER JOIN ( SELECT * FROM [dbo].[ADS_OBJECT_TYPE_STR] WHERE LANGUAGE='EN' )C ON A.Object_Type_ID=C.Object_Type_ID INNER JOIN ( SELECT * FROM [dbo].[ADS_SERVER_NAME_STR] WHERE Language='EN' )D ON A.Server_ID=D.Server_ID AND A.Cluster_ID=D.Cluster_ID INNER JOIN ( SELECT * FROM [dbo].[ADS_STATUS_STR] WHERE Language='EN' )E ON A.Status_ID=E.Status_ID AND A.Event_Type_ID=E.Event_Type_ID INNER JOIN ( SELECT * FROM [dbo].[ADS_SERVICE_TYPE_STR] WHERE Language='EN' )F ON A.Service_Type_ID=F.Service_Type_ID INNER JOIN ADS_EVENT_DETAIL G ON A.Event_ID=G.Event_ID and A.Event_Type_ID IN (1011,1012) group by D.Server_Name ,Object_ID ,A.Object_Name ,C.Object_Type_Name ,A.Object_Type_ID ,A.Object_Folder_Path ,Duration_ms ,Added_To_ADS ,User_ID ,User_Name ,Action_ID ,A.Event_Type_ID ,B.Event_Type_Name ,A.Status_ID ,E.Status_Name ,A.Event_ID --,G.Event_Detail_Value ,A.Service_Type_ID ,F.Service_Type_Name

Could you help me to understand from which table I can get this info ?