Is it possible to find out which user deleted a folder in StarTeam?

0 Likes

Problem:

Is it possible to find out which user deleted a folder in StarTeam?

Resolution:


  • Product Name: StarTeam
  • Product Version: ALL
  • Product Component: Client
  • Platform/OS Version: ALL

This can be achieved by querying the database. The following SQL should be used to query the database, substituting the actual folder name for %FOLDER NAME%

SELECT Name, DeletedTime, DeletedUserID
FROM syn_Folder
Where Name like "%FOLDER NAME%"

This will return a deleted time and deleted ID for the folder specified in line three. Then the deleted ID can be queried against the user table using the following SQL:

SELECT ID, Full_Name
FROM syn_User
Where ID = "%ID%"

The above query will now return the details of the user who has deleted the folder specified in the first query.


Old KB# 30277
Comment List
Related
Recommended