How to figure out who deleted a Project and when

0 Likes

Problem:

How to figure out who deleted a Project and when

Resolution:

  • Product Name: StarTeam
  • Product Version: 2008
  • Product Component: Server and Database
  • Platform/OS Version: All Supported OS

Description:

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?




Answer/Solution:

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 for you.


Author: Daniel Rice

Old KB# 29106
Comment List
Related
Recommended