Problem:

Is it possible to get a list of all StarTeam projects and the date they were created?

Resolution:

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

This can be achieved using the code below. This SQL code needs to be executed against either SQL Server or Oracle using an appropriate SQL query tool. The code below will return a list of Project ID"s and Project Names.

SELECT
ID "Project ID", NAME "StarTeam Project Name",
CAST("01/01/1900" AS datetime) CREATEDTIME "Project created on this date"
FROM
SYN_PROJECT
WHERE DELETEDTIME = 0

Removing the "where deletedtime = 0" line will retrieve all projects including deleted projects.