How to get users details under Teams using SQL query in CRM?

Run the below query to get all the users details under all the Teams available in CRMS.

Select
Team.name [Team Name],
SysUser.Fullname [User Name],
SysUser.mobilephone [Mobile Phone],
SysUser.internalemailaddress [Primary Email]
from
dbo.FilteredSystemUser SysUser
inner Join
dbo.FilteredTeamMembership TeamMem
on SysUser.Systemuserid = TeamMem.Systemuserid
Inner join dbo.FilteredTeam Team
on Team.TeamID = TeamMem.TeamID
–where Team.name in –Uncomment this where condition to specify the required Team names
–(
–Sales Person
–)
order by Team.NAME

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.