Product: TIBCO Spotfire®
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 "firstname.lastname@example.org" with the user's user name):
Select * from USERS where USER_NAMEemail@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'
- The output does not include "Everyone" group.
- The above query is an example tested on Microsoft SQL server.