How to figure out who deleted a Project and when
After a project is deleted, there is no way to know who actually did it from within the StarTeam client? The server audit logs do not track this information. How do you know who deleted and project and when?
Run the following SQL Query (might have to modify depending on your database backend):
SELECT syn_Project.Name, syn_Project.DeletedUserID, syn_Project.DeletedTime, syn_UserObject.Full_Name AS Deleted_User_Name FROM syn_Project LEFT OUTER JOIN syn_UserObject ON syn_Project.DeletedUserID = syn_UserObject.ID WHERE (syn_Project.Name LIKE "%%")
This will yield a table with 4 columns: The project name that matched the LIKE search, the time the project was deleted (0 if not deleted), the user ID who deleted the Project (-1 if not deleted), and the Name of the User who deleted the project (NULL if not deleted).
To convert the integer value from the DeletedTime field, simply
copy and paste the value into Excel (or similar application) and
paste the value into any cell. Tell the application that the
cell is a Date type, and it will convert it into a readable value
Author: Daniel Rice