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.