1

I've got a client with recurring complaints about check-ins that fail to include some changes he makes, and he "loses" the changes. The only common thread I could find to his complaints are that his developers use the Source Control Explorer to manually check out files.

I suspect human error. I suspect that they aren't checking out the files that later go missing.

Problem is that his people are adamant that they are doing everything right, and TFS (2010) is now suspect of being dangerously sub-standard.

I understand that in 2008, there was a TfsActivityLogging database that could show me a check-out history. In 2010, since they added collections, the structure changed, and I can't find a way to do that.

Does anybody know how I can find a checkout history for a certain file?

Zoe
  • 27,060
  • 21
  • 118
  • 148
Assaf Stone
  • 6,309
  • 1
  • 34
  • 43
  • http://stackoverflow.com/questions/1327593/does-tfs-log-undo-checkouts Does that question somewhat cover what you are asking? – billinkc Aug 02 '11 at 14:27
  • Unfortunately no, it doesn't. The post you suggested is about 2008, not 2010 (there are changes), and they refer to something else altogether. – Assaf Stone Aug 02 '11 at 18:08

1 Answers1

1

User activity, e.g. commmands issued to TFS, are logged in tbl_Command. When I checkout I get a number of entries in this table, the most likely one being Command='PendChanges'. I've used this query:

SELECT TOP 100
    *
FROM    
    [Tfs_DefaultCollection].[dbo].[tbl_Command] 
WHERE   
    Application = 'Version Control'
    AND IdentityName = '<domain>\<user>'
ORDER BY 
    commandid DESC
Henryk
  • 1,119
  • 1
  • 10
  • 16
  • Hi, this gives me a list of the checkout (PendChanges) commands I initiated, but it doesn't tell me _which_ files I checked out. Is there another table I can join to, that might give me the answer? – Assaf Stone Aug 14 '11 at 09:07
  • I guess this is the closest I can get... :( – Assaf Stone Aug 31 '11 at 18:02