How to get the list of all user groups which are synchronized externally to Spotfire ?

How to get the list of all user groups which are synchronized externally to Spotfire ?

All user groups information is stored in "GROUPS" table in Spotfire database.

list-groups  CLI command Lists all groups in the user directory. There isn't a filter condition available in this command to list only externally synchronized groups.

SQL query mentioned in Resolution section can be run on Spotfire database to get list of all externally synchronized groups. Here is an example query that can be run on the TIBCO Spotfire database running on Microsoft SQL Server:

------------------------
SELECT 
       [GROUP_NAME]
      ,[DOMAIN_NAME]
      ,[EXTERNAL_ID]
      ,[PRIMARY_GROUP_ID]
      ,[DISPLAY_NAME]
      ,[EMAIL]
      ,[CONNECTED]
  FROM [dbo].[GROUPS] where EXTERNAL_ID is NOT NULL
-------------------------

Note:  For Spotfire Database which is on Oracle or PostgreSQL( Applicable for Spotfire Server version 10.9 and higher) , query syntax need to be changed accordingly .

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.

• https://docs.tibco.com/pub/spotfire_server/10.3.9/doc/html/TIB_sfire_server_tsas_admin_help/GUID-8A5259E7-30E5-4265-AF6F-CD4C465B9D29.html