How to find Creation Date, Modified Date and Last Accessed Date of analysis files in the Spotfire library

How to find Creation Date, Modified Date and Last Accessed Date of analysis files in the Spotfire library

You can find the list of all Spotfire analysis files and details from the table "LIB_ITEMS" in the Spotfire Server application database. To retrieve Creation Date, Modified Date, and Last Accessed Date details for all analysis files in a Spotfire library, the query below can be used:

SELECT TITLE, ITEM_ID, PARENT_ID, CREATED,MODIFIED,ACCESSED 
FROM LIB_ITEMS 
WHERE ITEM_TYPE IN ( 
SELECT TYPE_ID 
FROM LIB_ITEM_TYPES 
WHERE FILE_SUFFIX='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 Spotfire 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.