How to fetch Creation Date, Modified Date, Last accessed Date details for all analysis files in the TIBCO Spotfire library

How to fetch Creation Date, Modified Date, Last accessed Date details for all analysis files in the TIBCO Spotfire library

book

Article ID: KB0074694

calendar_today

Updated On:

Products Versions
Spotfire Server All

Description

You can find the list of all TIBCO Spotfire analysis files and details from the table "LIB_ITEMS" in the TIBCO 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 mentioned in the "Resolution" below can be used.

Issue/Introduction

How to fetch Creation Date, Modified Date, and Last accessed Date details for all analysis files in the TIBCO Spotfire library

Environment

All

Resolution

Here is an example query that can be run on the TIBCO Spotfire Server application database: 
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 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.
Powered by Wolken Software