how to get all the Users along with Team Iteration of a project of TFS WIQL?

Question

i want to get all the users with there Iteration in a project. Lets say Project 'Precient' has 9 distinct users with 20 iteration so i want distinct users with all the Iteration in the project WIQL C#.it's related to the Question. WIQL query to get all the team and the users in a Project?
but does not help me fully

Answer 1

You may get that through REST API or Net API. This is sample for Net API.

1. You may get all users from group "Project Valid Users"

2. You may get all Iterations from Project root Iterations.

   using Microsoft.TeamFoundation.Client;
   using Microsoft.TeamFoundation.Framework.Client;
   using Microsoft.TeamFoundation.Framework.Common;
   using Microsoft.TeamFoundation.Server;
   using Microsoft.TeamFoundation.WorkItemTracking.Client;
   using System;
   using System.Collections.Generic;
   
   namespace GetUserіAndItearions
   {
       class Program
       {
           public class Iteration
           {
               public string Path;
               public DateTime DateFrom;
               public DateTime DateTo;
           }
   
           static void Main(string[] args)
           {
               string _teamProject = "Your_Project_Name";
   
               try
               {
                   TfsTeamProjectCollection _tpc = new TfsTeamProjectCollection(new Uri("http://your_server:8080/tfs/DefaultCollection"));
   
                   GetAllUsers(_tpc, _teamProject);
                   GetAllIterations(_tpc, _teamProject);
   
               }
               catch (Exception ex)
               {
                   Console.WriteLine("Error: " + ex.Message);
                   Console.WriteLine(ex.StackTrace);
               }
           }
   
           private static void GetAllIterations(TfsTeamProjectCollection pTpc, string pProjectName)
           {
               List<Iteration> _its = new List<Iteration>();
               WorkItemStore _wistore = pTpc.GetService<WorkItemStore>();
   
               var _css = pTpc.GetService<ICommonStructureService4>();
   
   
               foreach (Node _node in _wistore.Projects[pProjectName].IterationRootNodes)
                   FillIterations(_css, _node, _its);
   
   
               Console.WriteLine("Iterations:");
               foreach (Iteration _it in _its) Console.WriteLine("{0}:{1}-{2}", _it.Path, 
                   (_it.DateFrom == DateTime.MinValue) ? "0" : _it.DateFrom.ToShortDateString(), (_it.DateTo== DateTime.MinValue) ? "0" : _it.DateTo.ToShortDateString());
           }
   
           private static void FillIterations(ICommonStructureService4 pCss, Node pNode, List<Iteration> pIts)
           {
               var _nodeInfo = pCss.GetNode(pNode.Uri.AbsoluteUri);
   
               pIts.Add(new Iteration { Path = _nodeInfo.Path,
                   DateFrom = (_nodeInfo.StartDate == null) ? DateTime.MinValue : (DateTime)_nodeInfo.StartDate,
                   DateTo = (_nodeInfo.FinishDate == null) ? DateTime.MinValue : (DateTime)_nodeInfo.FinishDate });
   
               if (pNode.HasChildNodes)
                   foreach (Node _node in pNode.ChildNodes)
                       FillIterations(pCss, _node, pIts);
           }
   
           private static void GetAllUsers(TfsTeamProjectCollection pTpc, string pProjectName)
           {
               List<string> listUsers = new List<string>();
   
               WorkItemStore _wistore = pTpc.GetService<WorkItemStore>();
               var _gss = pTpc.GetService<IIdentityManagementService>();
   
               var _teamProject = _wistore.Projects[pProjectName];
               string _validGroupName = "[" + pProjectName + "]\\Project Valid Users";
   
               TeamFoundationIdentity _group = _gss.ReadIdentity(IdentitySearchFactor.DisplayName, _validGroupName, MembershipQuery.Expanded, ReadIdentityOptions.ExtendedProperties);
   
               List<string> _memebersIds = new List<string>();
               foreach (var _member in _group.Members) _memebersIds.Add(_member.Identifier);
   
               var _members = _gss.ReadIdentities(IdentitySearchFactor.Identifier, _memebersIds.ToArray(), MembershipQuery.Expanded, ReadIdentityOptions.ExtendedProperties);
   
               foreach (var _member in _members) if (!_member[0].IsContainer) listUsers.Add(_member[0].DisplayName);
   
               Console.WriteLine("Users:");
               foreach (var _user in listUsers) Console.WriteLine("{0}", _user);
           }
   
       }
   }