web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Owner and team table i...

Microsoft Dynamics CRM (Archived)

Owner and team table in SQL

(0) Share

Report

Report

Posted on by Community Member

Hi all,

I'm writing a query in SQL to return all records owned by a certain user. I want to extend this to be able to say return all records owned by anyone in a certain team.

Does anyone know how to do this in SQL?

Thanks very much in advance.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Hosk on at

Like (0)

Report
Copy link

Link copied!

I would do the query in advanced find and then look at the fetchxml it may give you some ideas of how the data is linked

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

This did the trick! Thanks. The SQL is:

select

t.Name,

tm.SystemUserId,

su.FullName

from

Team t

left join TeamMembership tm on t.TeamId = tm.TeamId

left join SystemUser su on tm.SystemUserId = su.SystemUserId

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1

JS-09031509-0 3

#2

AS-17030037-0 2

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans