Solved

CRM 2011 - How to get a view with list of all entities

Posted on 2012-03-24
2
1,277 Views
Last Modified: 2012-03-24
I will like to see a list of entities and their ownership? What is the way to do that?
0
Comment
Question by:tommym121
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
Feridun Kadir earned 500 total points
ID: 37761751
Try running this query against the crm databsae in sql server management studio:

select Name,OwnershipTypeMask from metadataschema.entity

The SDK has the following info for ownershiptypemask:

BusinessOwned Value = 4. Specifies that the entity is owned by a business unit. Not supported.
BusinessParented Value = 16. Specifies that the entity is parented by a business unit. Not supported.
None Value = 0. Specifies that the entity does not have an owner.
OrganizationOwned Value = 8. Specifies that the entity is owned by an organization
TeamOwned Value = 2. Specifies that the entity is owned by a team.  
UserOwned Value = 1. Specifies that the entity is owned by a system user.

Remarks
The only valid values for custom entities are OrgOwned or UserOwned. For Microsoft Dynamics CRM 2011 and Microsoft Dynamics CRM Online, UserOwned is interpreted as TeamOwned.
0
 

Author Closing Comment

by:tommym121
ID: 37762020
Thanks.
0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
Desired Skill Set for Microsoft Dynamics CRM Technical Resources – Part I
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question