Hi,
We can use this query to retrieve different teams and the users belonging to that team within Microsoft Dyanmics CRM
Select FT.name TeamName,FSU.Fullname UserName, FSU.Systemuserid from
dbo.FilteredSystemUser FSU
inner Join
dbo.FilteredTeamMembership FTM
on FSU.Systemuserid = FTM.Systemuserid
Inner join dbo.FilteredTeam FT
on FT.TeamID = FTM.TeamID
ORDER BY FT.NAME
Bye