How to find the scheduled cache start and end times of reports cached in Scheduled Updates from TIBCO Spotfire action logs

Products	Versions
Spotfire Server	10.3 and higher

Description

TIBCO Spotfire "Action logs" collects information about the user activity. When "Enable Web Service" is set to "Yes" and all "_wp" (Eg:library_wp ...) action categories are enabled in the action log dialog box under TIBCO Spotfire Server configuration tool, user actions on the TIBCO Spotfire Web Player will be logged to Spotfire Action log database.

With the help of Action log queries mentioned in the resolution, you can identify the start and end times of report initial loads and updates.

Resolution

Initial Load:

Here is the query for the initial load of a report scheduled to be cached in Scheduled Updates (a 'first time load'):

select Original_Time as Start_Time,Arg5 as WebPlayer_InstanceID 
from [dbo].[ACTIONLOG] 
where USER_NAME='scheduledupdates@SPOTFIRESYSTEM' and  LOG_CATEGORY='library_wp' and LOG_ACTION='load_start' and ID2=''Library_Path_Of_Dxp' AND ID1=''ScheduleRuleLib_Item_ID'

Example:
To find the start time of the scheduled analysis file:

select Original_Time as Start_Time,Arg5 as WebPlayer_InstanceID 
from [dbo].[ACTIONLOG] 
where USER_NAME='scheduledupdates@SPOTFIRESYSTEM' 
and LOG_CATEGORY='library_wp' 
and LOG_ACTION='load_start' 
and ID2='/test/testreport' 
and ID1='47706716-574d-4a06-90b7-79e5a13ac877'

To find the end time of the scheduled analysis file:

select Original_Time as End_Time,Arg5 as WebPlayer_InstanceID 
from [dbo].[ACTIONLOG] 
where USER_NAME='scheduledupdates@SPOTFIRESYSTEM' 
and LOG_CATEGORY='library_wp' 
and LOG_ACTION='load' 
and ID2='/test/testreport' 
and ID1='47706716-574d-4a06-90b7-79e5a13ac877'

Update:

Here is the query for the update of a report cached in Scheduled Updates (a 'cache update'):

select Original_Time as Start_Time,Arg5 as WebPlayer_InstanceID 
from [dbo].[ACTIONLOG] 
where USER_NAME='scheduledupdates@SPOTFIRESYSTEM' 
and LOG_CATEGORY='library_wp' 
and LOG_ACTION='update_start' 
and ID2=''Library_Path_Of_Dxp' 
and ID1=''ScheduleRuleLib_Item_ID'

Example:
To find the start time of when a scheduled analysis file is updated:

select Original_Time as Start_Time,Arg5 as WebPlayer_InstanceID 
from [dbo].[ACTIONLOG] 
where USER_NAME='scheduledupdates@SPOTFIRESYSTEM' 
and LOG_CATEGORY='library_wp' 
and LOG_ACTION='update_start' 
and ID2='/test/testreport' 
and ID1='47706716-574d-4a06-90b7-79e5a13ac877'

To find the end time for the update:

select Original_Time as End_Time,Arg5 as WebPlayer_InstanceID 
from [dbo].[ACTIONLOG] where USER_NAME='scheduledupdates@SPOTFIRESYSTEM' 
and LOG_CATEGORY='library_wp' 
and LOG_ACTION='update' 
and ID2='/test/testreport' 
and ID1='47706716-574d-4a06-90b7-79e5a13ac877'

Note: Ensure to update ID2 and ID1 with respective details of 'Library_Path_Of_Dxp' and 'ScheduleRuleLib_Item_ID' respectively.

Disclaimer: The content of this article is for informational purposes only. The subject material may change in any new versions with no notice and there is no responsibility by TIBCO to maintain or support future access to this internal application content. Modification of any internal application content is not recommended and can lead to an unsupported configuration. It is not intended to be used "As Is" in a Production environment. Always test in a Development environment.