Tarun Arora

Visual Studio ALM MVP
posts - 58, comments - 187, trackbacks - 0

My Links

News


Tarun Arora is a Microsoft Certified professional developer for Enterprise Applications. He has extensively travelled around the world gaining experience learning and working in culturally diverse teams. Tarun has over 5 years of experience developing 'Energy Trading & Risk Management' solutions for leading Trading & Banking Enterprises. His passion for technology has earned him the Microsoft Community Contributor and Microsoft MVP Award.




View Tarun Arora's profile on LinkedIn

profile for Tarun Arora at Stack Overflow, Q&A for professional and enthusiast programmers

Tag Cloud

Article Categories

Archives

Post Categories

Image Galleries

TFS SDK Get Groups Users Permissions using TFS API with Linqpad

 

Download a working Demo:

Working Demo Download

In this blog post I'll show you how to use the TFS API to get the security groups, members, permissions and security settings of users in Team Projects in TFS.

Problem

I would like to see the version control permissions and security settings for each user in a Group for each Team Project. Can I see all of this in one place in a report?

Solution

Is the report below similar to what you are looking for? Let’s build one using the TFS SDK… if you enjoy the post, remember to subscribe to http://feeds.feedburner.com/TarunArora.

image

 

=> Connect to TFS programmatically

I have a separate blog post on how to connect to TFS programmatically using the TFS API. In the below code snippet you can see I am getting a list of team projects using the VersionControlServerService.

var tfs = TfsTeamProjectCollectionFactory
                .GetTeamProjectCollection(new Uri("https://avanade.tfspreview.com/defaultcollection")); 
tfs.EnsureAuthenticated();
// Version control service exposes methods to work with TFS version control
var vcs = tfs.GetService<VersionControlServer>();

// Since we'll be reporting groups for all team projects, imp to get all team projects
var teamProjects = vcs.GetAllTeamProjects(false);

=> Get all Application Groups programmatically

When I say application groups I am referring to the list of groups that you expect to see if you were to right click on Team Project => Click Team Project Settings => And choose Group Membership. I will be using the IGroupSecurityService service to get the list of application groups.

image

 

// Group Security service exposes methods to get groups, users and security details
var sec = tfs.GetService<IGroupSecurityService>();
Identity[] appGroups = sec.ListApplicationGroups(teamProject.ArtifactUri.AbsoluteUri);

 

=> Get all members with in the Application Groups programmatically

When I say application groups I am referring to the list of users you would expect to see if you double click on the group name in the group membership window. This will allow you to get the details of which group the user is a member of as well.

image

 

foreach (Identity group in appGroups)
{
     Identity[] groupMembers = sec.ReadIdentities(SearchFactor.Sid, new string[] { group.Sid }, QueryMembership.Expanded);
                    
     foreach (Identity member in groupMembers)
     {
         var groupM = new GroupMembership {GroupName = member.DisplayName, GroupSid = member.Sid};
                        
         if (member.Members != null)
         {
             foreach (string memberSid in member.Members)
             {
                 Identity memberInfo = sec.ReadIdentity(SearchFactor.Sid, memberSid, QueryMembership.Expanded);

                 var userName = memberInfo.Domain + "\\" + memberInfo.AccountName;
                 var permissions = vcs.GetEffectivePermissions(userName, teamProject.ServerItem);

 

=> Get the security settings of a user programmatically

When I say security settings I am referring to the list of project security that you expect to see if you were to right click on Team Project => Click Team Project Settings => And choose Security. I will be using the VersionControlServer service to get the list of permissions. This will allow me to see if these permissions have been inherited or explicitly allowed or denied.

image

 

var actualPermission = vcs.GetPermissions(new string[] { teamProject.ServerItem },
                                                                          RecursionType.Full);
foreach (var memberOf in memberInfo.MemberOf)
{
      // Get information about the members
}

=> Version Control Permissions

When I say Version Control permissions I am referring to the list of permissions you expect to see if you were to right click on Team Project => Security. I will be using the VersionControlServer service to get the list of permissions.

image

var permissions = vcs.GetEffectivePermissions(userName, teamProject.ServerItem);

foreach (var permission in permissions)
{
     versionControlPermissions.Add(new VersionControlPermission(){Name = permission});
}

=> Putting everything together

Lets put all the snippets together, you can also download the working demo Linqpad query from this blog post. Look for the demo download link at the top of the post.

        public class TeamProject
        {
            public string Name { get; set; }
            public string TeamProjectCollectionName { get; set; }
        }

        public class GroupMembership
        {
            public string GroupName { get; set; }
            public string GroupSid { get; set; }
            public List<GroupMember> GroupMember { get; set; }
        }

        public class GroupMember
        {
            public string MemberName { get; set; }
            public string MemberSid { get; set; }
            public string Domain { get; set; }
            public string Email { get; set; }
            public List<VersionControlPermission> VersionControlPermissions { get; set; }
        }

        public class VersionControlPermission
        {
            public string Name { get; set; }
        }

        public class Security
        {
            public TeamProject TeamProject { get; set; }
            public List<GroupMembership> GroupMembership { get; set; }

        }

        void Main()
        {
            // Connect to TFS - VersioControlServer service
            var tfs =
                TfsTeamProjectCollectionFactory
                .GetTeamProjectCollection(new Uri("https://avanade.tfspreview.com/defaultcollection")); 
            tfs.EnsureAuthenticated();

            // Group Security service exposes methods to get groups, users and security details
            var sec = tfs.GetService<IGroupSecurityService>();

            // Version control service exposes methods to work with TFS version control
            var vcs = tfs.GetService<VersionControlServer>();

            // Since we'll be reporting groups for all team projects, imp to get all team projects
            var teamProjects = vcs.GetAllTeamProjects(false);

            var securities = new List<Security>();

            for (int i = 0; i < 1; i++)
            {
                var teamProject = teamProjects[i];
                var security = new Security();
                var myTeamProj = new TeamProject();
                myTeamProj.Name = teamProject.Name;
                myTeamProj.TeamProjectCollectionName = teamProject.TeamProjectCollection.Name;
                security.TeamProject = myTeamProj;
                var groupMemberships = new List<GroupMembership>();
                Identity[] appGroups = sec.ListApplicationGroups(teamProject.ArtifactUri.AbsoluteUri);

                foreach (Identity group in appGroups)
                {
                    Identity[] groupMembers = sec.ReadIdentities(SearchFactor.Sid, new string[] { group.Sid }, QueryMembership.Expanded);

                    foreach (Identity member in groupMembers)
                    {
                        var groupM = new GroupMembership { GroupName = member.DisplayName, GroupSid = member.Sid };

                        if (member.Members != null)
                        {
                            var groupMCollection = new List<GroupMember>();
                            foreach (string memberSid in member.Members)
                            {
                                Identity memberInfo = sec.ReadIdentity(SearchFactor.Sid, memberSid, QueryMembership.Expanded);
                                
                                // The above is a group and so build a collection of users in the group
                                // Member Name and other available properties about the user

                                var groupMM = new GroupMember();
                                groupMM.MemberName = memberInfo.AccountName;
                                groupMM.MemberSid = memberInfo.Sid;
                                groupMM.Domain = memberInfo.Domain;
                                groupMM.Email = memberInfo.MailAddress;

                                var userName = memberInfo.Domain + "\\" + memberInfo.AccountName;
                                var permissions = vcs.GetEffectivePermissions(userName, teamProject.ServerItem);
                                var actualPermission = vcs.GetPermissions(new string[] { teamProject.ServerItem },
                                                                          RecursionType.Full);
                                var versionControlPermissions = new List<VersionControlPermission>();
                                
                                foreach (var permission in permissions)
                                {
                                    versionControlPermissions.Add(new VersionControlPermission() { Name = permission });

                                }
                                groupMM.VersionControlPermissions = versionControlPermissions;

                                foreach (var memberOf in memberInfo.MemberOf)
                                {
                                }

                                groupMCollection.Add(groupMM);
                            }
                            groupM.GroupMember = groupMCollection;
                        }
                        groupMemberships.Add(groupM);

                    }
                }
                security.GroupMembership = groupMemberships;
                securities.Add(security);
            }

            securities.Dump(10);
        }

 

Enjoyed the post, remember to subscribe to http://feeds.feedburner.com/TarunArora? Have ideas/feedback/questions, please feel free to add comments.

Cheers, Tarun

Share this post :

Print | posted on Friday, September 30, 2011 9:42 PM | Filed Under [ TFS2010 TFS API TFS SDK Tfs11 ]

Feedback

Gravatar

# re: TFS SDK Get Groups Users Permissions using TFS API with Linqpad

Download link doesn't work
10/3/2011 5:11 PM | Merc
Gravatar

# re: TFS SDK Get Groups Users Permissions using TFS API with Linqpad

Hi Merc,

Thanks for pointing the broken link out. I'll correct that and post an updated link shortly.

Cheers, Tarun
10/3/2011 5:25 PM | Tarun Arora
Gravatar

# re: TFS SDK Get Groups Users Permissions using TFS API with Linqpad

Hi Marc,

I have corrected the download link. Please give it another try.

Cheers, Tarun
10/3/2011 7:39 PM | Tarun Arora
Gravatar

# re: TFS SDK Get Groups Users Permissions using TFS API with Linqpad

Hi Tarun,

Could you please share the dump method. I really like to the excel layout that you "dumped"

Thanks
Oran
12/1/2011 11:59 AM | Oran
Gravatar

# re: TFS SDK Get Groups Users Permissions using TFS API with Linqpad

Hi Oran,

You already have it, navigate to "C:\Program Files (x86)\Microsoft Visual Studio 10.0\Samples\1033\CSharpSamples\LinqSamples\ObjectDumper" (the path might vary between Program x86 or program depending on x86 or x64 bit).

The Object Dumper project shows you a sample implementation of the Dump() method, include that in your project add ref and you should be able to use it right away.

Feedback, questions, suggestion, feel free to add to the thread.

Cheers, Tarun
12/1/2011 12:28 PM | Tarun Arora
Gravatar

# re: TFS SDK Get Groups Users Permissions using TFS API with Linqpad

What I don't see is the work item permissions. These are controlled primarily from area path permissions. I think many of us set permissions on the root area node and inherit by default on the descendant nodes. Would be helpful to have those permissions as well.
2/24/2012 8:21 PM | Tim Pacl
Post A Comment
Title:
Name:
Email:
Website:
Comment:
Verification:
 
 

Powered by: