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 !
Nice tip, thanks