Is it possible to get a list of all StarTeam projects and the date they were created?
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.
ID "Project ID", NAME "StarTeam Project Name",
CAST("01/01/1900" AS datetime) CREATEDTIME "Project created on this date"
WHERE DELETEDTIME = 0
Removing the "where deletedtime = 0" line will retrieve all projects including deleted projects.