How to get group membership for a user from the TIBCO Spotfire database

How to get group membership for a user from the TIBCO Spotfire database

You may need to find the list of group memberships for a particular user in TIBCO Spotfire. This article contains an example query which can be used to return this information from the TIBCO Spotfire Server application database. To find the USER_ID for the user of interest, run the following query (replace "tibco@example.com" with the user's user name):

Select * from USERS where USER_NAME='tibco@example.com';

This will return the user_id. Copy the GUID and use it in the below query.


Execute the following example query on the TIBCO Spotfire Server application database to find the list of group memberships for a given user (replace "3897ed0d-6729-4938-bae2-872d30a059cc" with the GUID from the above query):

select u.USER_ID,u.USER_NAME, g.DISPLAY_NAME from USERS u 
  join GROUP_MEMBERS gm on gm.MEMBER_USER_ID = u.USER_ID 
  join GROUPS g on g.GROUP_ID=gm.GROUP_ID
where USER_ID ='3897ed0d-6729-4938-bae2-872d30a059cc'

Important note:

• The output does not include "Everyone" group.
• The above query is an example tested on Microsoft SQL server.

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.