找出最近 6 个月内登录 TFS 的用户 [英] Find out the users that has logged-in to TFS in last 6 months

问题描述

我正在尝试找出过去 6 个月内登录 TFS 2015 Update 3 的用户.

I am trying to find out the users that has logged into TFS 2015 Update 3 in last 6 months.

使用 C#/REST API 的解决方案很好，如果不可用，有没有办法使用 SQL 生成报告.

Solution using C#/ REST API is good, if not available is there a way to generate the report using SQL.

我遵循了这个:这个.我认为查询与 TFS 2015 Update 3 数据库不兼容.

I have followed this:This. I think the Query is not compatible with TFS 2015 Update 3 database.

推荐答案

这仅在您不清理或存档 TFS 数据库中 tbl_command 的内容时才有可能.默认情况下，这些会在 7 天后清除(从我的头顶开始).限制可以更改通过更改作业定义(可能需要在每次安装 Service Pack 后重做).

This is only possible if you don't clean up or archive the contents of the tbl_command in the TFS databases. By default these are cleaned up after 7 days (from the top of my head). The limit can be changed by altering the job definition (which may need to be redone after each service pack installation).

或者您可以设置一个自定义作业，将 tbl_command 的内容复制到自定义表/数据库以供将来参考.

Or you can setup a custom job that copies the contents of tbl_command to a custom table/database for future reference.

这让您可以查看用户在过去 6 个月内是否进行了任何工作项更改或签入代码、将任何构建排入队列、触发了任何发布......每个人都使用不同的 API，其中很多都没有据我所知，通过用户界面提供一个简单的查询.

Which leaves you to see whether a user has made any work item changes or checked in code in he last 6 months, queued any builds, triggered any releases... Each uses a different API and a lot of these don't offer a easy query by user interface as far as I can know.

这篇关于找出最近 6 个月内登录 TFS 的用户的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！