Search code examples
dynamics-crmdynamics-crm-4

CRM 4.0 search for team members

How can you search for all members of named team(s) in Dynamics CRM 4.0? I am unable to create this advanced search, and I am wondering if it is possible at all.

Solution

  • Doesn't look like its possible from the advanced search but here is the SQL:

    SELECT FSU.fullname
FROM FilteredTeam FT
LEFT OUTER JOIN FilteredTeamMembership FTM
ON FTM.teamid = FT.teamid
LEFT OUTER JOIN FilteredSystemUser FSU
ON FTM.systemuserid = FSU.systemuserid
WHERE FT.name = 'TEAM_NAME'