Is it possible to get a list of users and the groups they belong to?

0 Likes

Problem:

Is it possible to get a list of users and the groups they belong to?

Resolution:


  • Product Name: StarTeam
  • Product Version: 2006 - 2009
  • Product Component: Server
  • Platform/OS Version: Windows

You can get a list of the users and the groups they belong to by querying the StarTeam backend database using SQL.

In order to get the information run the following query using either Oracle"s SQL Plus or SQL Server"s Query Analyzer:

SELECT

GroupName, UserID, Full_Name

FROM

Syn_Group, Syn_GroupMembers, Syn_User

WHERE

Syn_Group.ID = GroupID AND Syn_User.ID = UserID

ORDER BY

GroupName


Old KB# 29770
Comment List
Related
Recommended