Where are History Comments stored in TFS Database?

Question

Hello,

As you are probably aware, each time a user updates a Work Item in TFS they have the opportunity to write a comment in the History tab of said work item.

My question is:

Where is that history comment stored?

We have checked in all the work item tables (dbo.FactCurrentWorkItem, dbo.FactWorkItemChangeset, dbo.FactWorkItemHistory, etc.) but we are still unable to find it.

Thank you in advance for your help.

Answer 1

The TFS database associated with the collection in the table WorkItemLongText in the field named Words. These link back to the actual work item found in the WorkItemFiles table.

this is how it is in TFS 11

Answer 2

Hi JCosta52,

Thank you for your post.

Scott is right, you can check the dbo.WorkItemLongTexts table in collection database.

Best regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 3

Thank you very much for the information Scott.

Looks like I need to get access to the Project Collection database so I can retrieve that info.

Answer 4

Hi,

through this thread i have found my history data so thanks! however how do i join between the dbo.DimWorkItem on tfs_warehouse and the dbo.WorkItemLongTexts on Tfs_DefaultCollection

thanks