none
如何查询TFS的用户数? RRS feed

答案

  • TFS 2013  Tfs_Configuration 数据库中运行以下查询(先修改项目名称)

    select

    i.DisplayName,

    g.DisplayName,

    gs.Name

    from

    [dbo].[tbl_GroupMembership] gm

    inner join [dbo].[tbl_Identity] i

    on gm.MemberId = i.Id

    inner join [dbo].[tbl_Group] g

    on gm.ContainerId =g.Id

    inner join [dbo].[tbl_GroupScope] gs

    on g.InternalScopeId = gs.InternalScopeId

    where gs.Name='teamprojectname'


    专注于.NET MIS开发框架,C/S架构,SQL Server + ORM(LLBL Gen Pro) + Infragistics WinForms

    2016年5月17日 1:49