I have been having difficulties creating a custom report that lists all the files included in all change sets associated with all work items associated with an area and iteration.
I cannot find the association between change sets and files in the TfsWarehouse database.
I have successfully create a query that brings the desired results using the [Code Churn] table. Unfortunately we are also tracking changes for Crystal reports files (.rpt) which are not included in the [Code Churn] table.
The report is very simple and it will be used for release and deployment management.
Does anyone have a suggestion? Maybe someone has already create this report.
See this Microsoft KB article:
Also note that you'll need to grant the TfsReports user R/O permissions to the TfsSourceControl database.
Please mark the post as an answer if it does solve the problem. Thanks!
- Proposed as answer by Bill.Wang Tuesday, December 23, 2008 6:31 AM