Get all project admins in collection using SQL query
USE Tfs_FabrikamFiberCollection
SELECT member.SamAccountName,grp.Displayname
FROM
[ADObjects] grp
JOIN ADObjectMemberships
om ON om.ObjectSID = grp.ObjectSID
JOIN ADObjects member ON om.MemberObjectSID = member.ObjectSID
WHERE
grp.SamAccountName = 'Project Administrators'
Thanks for the post anvesh it was really good
ReplyDelete