TFS的SQL查询 [英] SQL Queries for TFS

问题描述

大家好，

Hi All,

有没有办法从SQL数据库获取用户访问详细信息/日志，例如登录的用户数，时间，时间/他们在过去6个月内访问/访问的内容等...还有多少用户是活跃用户等。

Is there any way to get user access detail/logs from SQL database like how many users are login, what time, when/what they are accessing/accessed for past 6 months etc... Also how many users are active users etc..

1.我们无法找到正确的表格，我们可以获得日志&所有这些细节。 

1.We could not find the correct tables where we can get logs & all these details. 

2.如何获得TFS整体和每个集合的用户列表 

2.How to get list of users in TFS overall and on each collection 

3。我们是否有任何MS站点或任何讨论此SQL脚本的站点？

3.Do we have any MS Site or any site which talks about this SQL scripts?

< span style ="font-size：14px">请帮助我获取SQL脚本以获取来自单个数据库和整个服务器的所有详细信息。

推荐答案

您需要找到一个专门讨论TFS的论坛，以获得与TFS数据库中存储的数据相关的问题的答案。

You would need to find a forum devoted to TFS to get answers on questions that pertain to the data that is stored in TFS databases.

虽然，我认为这些表是禁止的。您应该通过TFS中的API，报告等获得答案。

Although, I believe that the tables are off-limits. You are supposed to get answers through the APIs, reports etc in TFS.

这篇关于TFS的SQL查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！