Audit Trail on TFS Source Control.

Today I got the question if I could see when a person did a Get Latest Version on TFS Source Control.

Check-ins are easily found in the Source Control History but Get Latest Versions are not in the history. After some searching I found the tbl_Command in the TFS Collection Database.This contains all actions that happen on TFS limited to a date range. So not everything is stored forever.

In my case it helped me out !

SELECT *

  FROM [dbo].[tbl_Command]

  where application = 'Version Control'

  and Command = 'Get'

There are many other actions you can check. For example CreateBranch, QueryAnnotation etc.. Remove the where statement and see for yourself

Enjoy !