?
Solved

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

Posted on 2012-03-24
2
Medium Priority
?
1,301 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 30

Accepted Solution

by:
Feridun Kadir earned 2000 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

[Webinar] Lessons on Recovering from Petya

Skyport is working hard to help customers recover from recent attacks, like the Petya worm. This work has brought to light some important lessons. New malware attacks like this can take down your entire environment. Learn from others mistakes on how to prevent Petya like worms.

Question has a verified solution.

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

On Sep 22nd 2014 Microsoft released Update Rollup 1 for Microsoft Dynamics CRM 2013 Service Pack 1 and back in July Update Rollup 3 was released.  So we now have:   Update Rollup 1Update Rollup 2Update Rollup 3Service Pack 1Update Rollup 1 for S…
Automatically creating a Trello card using data from a Microsoft Dynamics CRM record turned out to be an easy project that yielded great results.  Here's how I did this for an internal team at General Code.
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…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

765 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