Created On:  08 September 2011

Problem:

Is there a query to return all email addresses of licensed StarTeam users?

Resolution:

This can be achieved by running the following query:

Star Team 2008 and above databases:
Select Full_Name, Email_Address
From syn_User
Where LicenseType =1

Star Team 2005 R2 Databases:
Select Full_Name, Email_Address
From syn_UserObject
Where LicenseType =1

Possible values for license type
1 = Concurrent user
2 = Named user
3 = Flex or Belise

Incident #2525748