MSCRM 3.0 ships with a really cool web page that allows you to view the current CRM system schema. If you browse to the following location:
http://[your crm server]/sdk/list.aspx
You will receive a list of all of the entities within the current CRM system.
Clicking on the Definition icon ( little yellow box ), will show a web page containing a complete overview of just about everything you need to know about that Entity: Type information, Attributes, and Relationships.
Copy that page, paste it into an Excel worksheet, and you have fully documented most of the information about that Entity.
Caveats:
- The List doesn't show you any JavaScript Event information ( OnLoad, OnSave, OnChange ).
- The Entities are listed by their Schema name so if you've renamed system entities, you will find them listed under their original name.
- Custom entities are listed by their Schema name as well: new_entityname. ( Assuming you haven't altered the custom prefix. )
I think the thing I like the most about this feature is that it let's me see the Entity layout in a quick, at-a-glance, view without having to resort to SQL Enterprise Manager or SQL Query Analyzer. This is very useful when you are creating several related Entities that need to have similar or exact table structures.
Loading ...
[...] CRM metadata browser It was interesting to see Mitch Milam's post about the metadata browser. This was a little tool I put together pre-V1.0 ship, but which didn't make the schedule until V3. Mitch points out the "published" component which displays the entity metadata in a nice format. If you edit list.aspx you'll see two sections commented out that provide links to individual entity schemas. This is unsupported and undocumented functionality that we considered calling "sample code". Turns out that it made it into the box but not enabled by default. These schemas work nicely with the code generators that I blogged about a while back. [...]
That is just awesome. Very cool.
Thanks.
-Ryan
[...] Don't forget that you can also view CRM metadata via the CRM Metadata Browser by visiting the following link: [...]
Exactly what I am needing, thanks for sharing this info!
Any thoughts on how I could get a similar list to show OnLoad, OnSave, OnChange stuff?
Thanks
This is useful, thanks very much. Next Q :-) is there a way to change the properties of an entity in an existing implementation to allow it to be viewable in advanced find?
Rory,
Edit the Entity, go to the Attributes section, then edit an Attribute.
Set Searchable to Yes.
Publish the Entity and you're good.
Mitch
Really usefull. Thanks you very much.