Work Item Test Result tables

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 VSTS, see Dashboards, charts, & widgets.

TFS 2018 and later versions no longer support native integration with SharePoint products. If you're planning to upgrade to TFS 2018, read About SharePoint integration to learn about the options available to you.

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

Fact Table for Work Items linked to Test Results

FactWorkItemTestResult is associated with the following dimension tables:

  • DimTeamProject

  • DimTestResult

  • DimWorkItem

Test results
Test Result tables
Current Work Item tables
Test Management Reports
Testing overview
Table reference for the relational warehouse database