工作项目的附件 [英] Attachments of work items

问题描述

有谁知道存储的位置以及我应该在哪里查找TFS 2017中WIT附件的文件？

Does anyone know where are stored and where should I look for files that were attachments to WITs in TFS 2017 ?

祝你好运，

Sanja

推荐答案

<嗨Sanja，

 所有附件信息都存储在集合数据库的WorkItemFiles表中。

 All the attachments information are stored in the WorkItemFiles table in the collection database.

如果您配置报告您的TFS，您可以使用下一个sql server查询语言来查找附件：

If you configure Reports for your TFS, you could use next sql server query language to find the attachments:

SELECT DISTINCT [ID] AS "Work Item ID"
      ,B.System_Title AS "Work Item Name"
	  ,B.System_WorkItemType As "Work Item Type"
	  ,[OriginalName] As "Attachments File Name"
  FROM [Tfs_DefaultCollection].[dbo].[WorkItemFiles] as A
  Left join [Tfs_Warehouse].[dbo].[DimWorkItem] As B 
  on A.ID = B.System_Id 

最好的问候

这篇关于工作项目的附件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！