Skip to content

Latest commit

 

History

History
33 lines (23 loc) · 1.26 KB

work-item-changeset-tables.md

File metadata and controls

33 lines (23 loc) · 1.26 KB
title description titleSuffix ms.technology ms.topic ms.assetid ms.author author ms.date
Work Item Changeset tables
Query for data about work items that are linked to changesets
Azure DevOps Server
devops-analytics
reference
0c017c1e-b19b-40b6-9927-b88b48700976
kaelli
KathrynEE
10/17/2017

Work Item Changeset tables

[!INCLUDE temp]

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

Related articles