Problem:

Is it possible to extract the group name that a user belongs to from the StarTeam Database?

Resolution:

• Product Name: StarTeam
• Product Version: All
• Product Component: Database
• Platform/OS Version: N/A

Yes. This is possible via two methods. The first is a manual check via the StarTeam Server Administration tool. Using the Admin tool the user manager console will list the all StarTeam users and the groups they belong to.

The second option is to query the StarTeam database.

1. Query the user tables to find the user ID of the user whose group you would like to check on
   
   SELECT ID, LoginName, Full_Name
   FROM syn_User
2. Query the group members view to see which group your selected user belongs to
   
   SELECT Group ID, UserID
   FROM syn_GroupMembers
   WHERE UserID=xxxx
   
   Replace "xxxx" with the user ID returned in part one of the query.
3. Now that we have the Group ID that the selected user belongs to you can run the following
   
   SELECT ID, GroupName
   FROM syn_Group
   WHERE ID =xxxxxxxxx
   
   Replace xxxxxxxxx with the GroupID number returned from part two of the query above