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 !


  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 !


One Response to “Audit Trail on TFS Source Control.”

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: