Table WorkItemsLatest (TFS 2010) missing in TFS 20

问题:

We recently migrated from TFS 2010 to TFS 2015 and came across that some of the reporting services are not working anymore.

One of the view we created was pulling various information (WorkItem State, Title,Fld10118) from "WorkItemsLatest" table, however, checking the collection database of TFS 2015 indicates that there is no more "WorkItemsLatest" table in TFS 2015 collection database.

I would appreciate if you can advise how to get above mentioned fields in TFS 2015 collection database. I understand that the operational databases are not supported by Microsoft and encourages to retrieve data from Warehouse database, however, we would like to retrieve this data and will allocate some development time in the future to ensure that data is retrieved from the Warehouse database.

回答1:

WARNING

Even though you've already mentioned this yourself, querying the database tables directly can lead to breaking functionality between updates. With the recent amount of churn in the work item space (new template customization features landing on VSTS and probably coming to TFS vNext and the new workitem form), expect these items to keep changing in the near future.

Ok, I get it

So, you're probably looking for the following two views:

• [Tfs_DefaultCollection].[dbo].[vw_denorm_WorkItemCoreLatest]
• [Tfs_DefaultCollection].[dbo].[vw_denorm_WorkItemCustomLatest]

And join them with tbl_Field to be able to identify which Custom Field ID matches which Field Name.