Created On:  09 March 2011

Problem:

A list is required to show all StarTeam users including their status, i.e. whether they are 'Active' or 'Suspended'. Can this be achieved without using the User Manager section of the StarTeam Admin Console.

Resolution:

This can be achieved by executing SQL statements against the StarTeam database. For example, with SQL Server,

To find the total number of users (active & suspended) run the following query against the StarTeam database:
SELECT COUNT(*) AS "Number of Users" FROM syn_user

To return the number of Active users:

SELECT COUNT(*) AS "Number of Active Users" FROM syn_user WHERE status=0

To return the number of Suspended users:

SELECT COUNT(*) AS "Number of Active Users" FROM syn_user WHERE status=2

To return the full name and login name of all Active users:

SELECT ID, Full_name, LoginName FROM syn_user WHERE status=0

To return the full name and login name of all Suspended users:

SELECT ID, Full_name, LoginName FROM syn_user WHERE status=2
Incident #2485425