是否可以从SQLServer列出TFS组中的所有用户-IsitpossibletolistallusersinaTFSgroupfromSQLServer

6  

Here's a query I use to list all users and memberships within a TFS Collection.

这是我用来列出TFS集合中所有用户和成员资格的查询。

Select    Object1.DisplayName as Name, 
          Object2.DisplayName as Membership
From      ADObjectMemberships Member1, 
          ADObjects Object1,
          ADObjects Object2
Where     Object1.ObjectSID = Member1.MemberObjectSID and
          Object2.ObjectSID = Member1.ObjectSID
Order By  Membership, Name

2  

After poking around and some trial-and-error, I found that the following SQL seems to work

在探讨了一些试错之后,我发现以下SQL似乎有效

USE MyCollection;

SELECT
   --grp.[SamAccountName] 'group_name',
    member.SamAccountName 'member_name'
FROM
    [ADObjects] grp
    JOIN ADObjectMemberships om ON om.ObjectSID = grp.ObjectSID
    JOIN ADObjects member ON om.MemberObjectSID = member.ObjectSID
WHERE
    grp.SamAccountName = 'MyGroup'