How to calculate caching time of an scheduled analysis file using TIBCO Spotfire action logs

How to calculate caching time of an scheduled analysis file using TIBCO Spotfire action logs

You can get the caching time of an scheduled analysis file using the following query. Please note that this query only helps if "scheduled_updates" action log category is configured in Action logs otherwise it will return zero results. In case, if you want to enable action log web service for all the categories then follow the steps described in this document: Configuring the action log web service using the configuration tool before executing the below query. For example:
 

SELECT dc.ARG2 as AnalysisName, dc.ORIGINAL_TIME as StartTime,ac.ORIGINAL_TIME as EndTime,DATEDIFF(SECOND,dc.ORIGINAL_TIME,ac.ORIGINAL_TIME) as TimeToCacheinseconds
  FROM [dbo].[ACTIONLOG] ac
  Inner Join
  (SELECT ORIGINAL_TIME,ID1,ARG2
  FROM [dbo].[ACTIONLOG] where ARG1='load' and ARG2='library-path-of-dxp') dc
  on ac.ID1=dc.ID1 and ac.ARG3='COMPLETED'

This will return output like below:

AnalysisName	StartTime	EndTime	TimeToCacheinseconds
/Export and Review	2020-09-29 10:40:03.930	2020-09-29 10:40:23.687	20
/Export and Review	2020-09-29 10:40:18.920	2020-09-29 10:40:23.703	5
/Export and Review	2020-09-29 10:41:18.913	2020-09-29 10:41:18.990	0
/Export and Review	2020-09-29 10:42:03.907	2020-09-29 10:42:03.987	0
/Export and Review	2020-09-29 10:42:03.907	2020-09-29 10:44:03.970	0
/Export and Review	2020-09-29 10:46:03.913	2020-09-29 10:46:03.977	0

Note: Make sure to update ARG2 with library path of the dxp

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. Doc: Configuring the action log web service using the configuration tool

• https://docs.tibco.com/pub/spotfire_server/10.10.0/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/configuring_the_action_log_web_service_using_the_configuration_tool.html

Doc: Action logs and system monitoring

• https://docs.tibco.com/pub/spotfire_server/10.10.0/doc/html/TIB_sfire_server_tsas_admin_help/server/topics/action_logs_and_system_monitoring.html???????