Work Item Changeset tables

Last Update: 3/9/2017

TFS 2017 | TFS 2015 | TFS 2013

IMPORTANT

Excel reports, Reporting Services reports, and SharePoint dashboards are only supported for on-premises TFS. For information on what is supported for Team Services, see Dashboards and reports overview.

You can query for data about work items that are linked to changesets by using FactWorkItemChangeset and the associated dimensions. For information about the measures and dimensions that are associated with these tables in the SQL Server Analysis Services cube, see Test cases and work items.

Fact Table for Work Items Linked to Changesets

FactWorkItemChangeset is associated with the following dimension tables:

  • DimChangeset

  • DimPerson

  • DimWorkItem