Area - Iteration - WorkItems - ChangeSets - Files (Custom Report)


  • 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.


    Thank you

    Thursday, December 18, 2008 10:07 PM


  • Thank you Dmytro,

    I successfully created and deployed the report.
    Thank you for your  help

    Pedro Reinoso
    • Marked as answer by Pedro Reinoso Tuesday, December 23, 2008 4:40 PM
    Tuesday, December 23, 2008 4:39 PM

All replies