Whenever data functions, IronPython scripts, JavaScripts, or custom queries are trusted in analysis file, the file gets a "TrustedScripts" property assigned. This article describes how to verify if the analysis file has TrustedScripts property or not.

How to verify if the analysis has TrustedScripts property

This can be verified in following ways:

Option 1) Library Administrator file properties
Navigate to Tools > Library Administrator > select the analysis file > Right click > Edit Properties > Properties. Check if the TrustedScripts property is present in the properties list (highlighted below). In this properties list, any one of the trusted scripts hash value will be seen i.e. if analysis contains 10 trusted scripts, only one of them will be seen.


Option 2) Spotfire Database
Execute the following query on the TIBCO Spotfire application database like below (update "<filename>" with the analysis file name) and there will TrustedScripts property present for each trusted data function, IronPython script, Javascript, or custom query in the analysis:

 SELECT li.ITEM_ID,li.Title as "DXP Title", Property_name, Property_value FROM LIB_PROPERTIES p JOIN LIB_ITEMS li on li.ITEM_ID = p.ITEM_ID JOIN LIB_ITEMS par on li.PARENT_ID = par.ITEM_ID where li.Title= '<filename>'

For example:

Note: For each trusted IronPython script, Javascript, or custom query there may be two trusted scripts hash generated, one in SHA-1 and one in SHA-512 whereas for each data function, there will only be one  trusted script hash in SHA-512. This is because IronPython scripts, Javascripts, or custom queries could have been trusted before version 10.3 when the SHA-512 hash was introduced.

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.

Option 3) CLI Tool report
Use the find-analysis-scripts command line command which will generate a report_<DATE>.csv file. See the Wiki article Script and Data function trust in Spotfire 10.3 and later for more details. Open this report in the TIBCO Spotfire installed client, and you can filter on Trusted = True to get a list of analysis files with trusted data functions, IronPython scripts, JavaScripts, or custom queries in the library.

Option 4) Library Administrator Search
Navigate to Tools > Library Administrator and then search for the following in the search box:

 TrustedScripts:*

This will display all analysis files which contain trusted data functions, IronPython scripts, JavaScripts, or custom queries. See KB 000031575 How to display the list of all analysis files with 'Trusted Scripts' in the Spotfire Library? for more details

Additionally, see  KB 000031299 How scripts trust works and tips for troubleshooting intermittent script trust issues for details on steps to take when experiencing intermittent script trust issues.

Doc: Script and Data function Trust

• https://docs.tibco.com/pub/sfire-analyst/10.3.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/vis/vis_script_and_data_function_trust.htm?rhtocid=_12_6_1#bc-1

Wiki: Script and Data function trust in Spotfire 10.3 and later

• https://support.tibco.com/s/article/How-to-display-the-list-of-all-analysis-files-with-Trusted-Scripts-in-the-Spotfire-Library

KB: 000035067 SQL query to display count of trusted scripts for all the analysis files that contains IronPython scripts

• https://support.tibco.com/s/article/SQL-to-display-count-of-trusted-scripts-for-all-the-analysis-that-contains-scripts-in-it

KB: 000031575 Display all dxps with Trusted Scripts/Data functions

• https://support.tibco.com/s/article/How-to-display-the-list-of-all-analysis-files-with-Trusted-Scripts-in-the-Spotfire-Library

KB 000031299 How scripts trust works and tips for troubleshooting intermittent script trust issues

• https://support.tibco.com/s/article/How-scripts-trust-works-and-tips-for-troubleshooting-intermittent-script-trust-issues