How to list all groups for which a TIBCO Spotfire Statistics Services URL is defined in the preferences

How to list all groups for which a TIBCO Spotfire Statistics Services URL is defined in the preferences

The TIBCO Spotfire Statistics Services (TSSS) URL for particular engine types are configured in Spotfire for particular groups using the following steps:

1. Log in to Spotfire Professional using administrator credentials.
2. Click Tools > Administration Manager.
3. Select the main Preferences tab.
4. Select the group for which you want to set the URL, and then select the secondary Preferences tab.
5. Scroll through the preferences until you find TIBCO Spotfire Statistics ServicesSpotfire Statistics Services. Expand this option and select Statistics Services.
   The right pane displays the default URLs for all engine types.
6. Select the engine for which you want to set the URL, and then click Edit.
7. In the resulting box, type the URL for Spotfire Statistics Services. Include the service name. For example, http://MyServer:8080/TERRServer. 

If an administrator has to find the list of groups for which a TSSS URL has been configured, the only option is to visit each and every group manually. If there are many groups this could be very time consuming. In a situation when there is an upgraded Spotfire version which has old and invalid TSSS URLs configured for different groups, this query may be helpful to find such groups in order to remove the old URLs. This is also helpful for scenarios where multiple URLs are configured for the same engine type across multiple groups and the jobs are not executing on the expected TSSS.
  Here is an example query that can be run on the TIBCO Spotfire database running on Microsoft SQL Server:

SELECT GROUP_NAME, CATEGORY_NAME, PREFERENCE_NAME as [ENGINE TYPE],  PREFERENCE_VALUE as [TSSS URL in encrypted format] 
FROM PREFERENCE_KEYS A 
INNER JOIN PREFERENCE_VALUES B ON A.PREFERENCE_ID =  B.PREFERENCE_ID 
INNER JOIN GROUPS C ON B.GROUP_ID = C.GROUP_ID 
WHERE PREFERENCE_VALUE != '#null' and CATEGORY_NAME = 'TIBCO Spotfire Statistics Services'

Note that the actual URL text is encrypted in the database and not in a readable format. This query will at least give a list of the groups for you to investigate in the Administration Manager.

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 TIBCO Spotfire to use TIBCO Spotfire Statistics Services

• https://docs.tibco.com/pub/sf_statsvcs/7.11.0/doc/html/TIB_sf_statsvcs_7.11.0_installation/GUID-2CF39D5B-AEEB-4F50-9A33-ED644AAE1740.html