90
Hi I have been trying to count the number of attributes per entity in a CRM 2016 environment. While there are some good things to aid this on XRM Toolbox there is nothing I can find that will give a total count.
Is there a SQL script out there that might help this or better still any documentation that gives an exact count on the total of OOB entity attributes? I.e, Account, contact, Case etc
Thanks
*This post is locked for comments
Hi,
You can get the information related to Entity wise attributes in the below link
https://docs.microsoft.com/en-us/dynamics365/customer-engagement/customize/create-edit-metadata
If found useful, please mark this answer as verified answer.
Hi
I dont see why you cant the following query on XrmToolBox Code Now plugin
EntityQueryExpression entityQueryExpression = new EntityQueryExpression
{
Properties = new MetadataPropertiesExpression
{
AllProperties = false,
PropertyNames = { "LogicalName", "DisplayName", "Attributes", "PrimaryIdAttribute", "ObjectTypeCode", "SchemaName" }
},
AttributeQuery = new AttributeQueryExpression
{
Properties = new MetadataPropertiesExpression(AttributeMetadataProperties)
{
AllProperties = false
}
},
};
RetrieveMetadataChangesRequest retrieveMetadataChangesRequest = new RetrieveMetadataChangesRequest
{
Query = entityQueryExpression,
ClientVersionStamp = null
};
var response = (RetrieveMetadataChangesResponse)service.Execute(retrieveMetadataChangesRequest);
Console.WriteLine("Entity attribute coutnts");
if (response.EntityMetadata != null && response.EntityMetadata.Any())
{
foreach (var entityMetadata in response.EntityMetadata)
{
Console.WriteLine(entityMetadata.LogicalName + "has " + entityMetadata.Attributes.Count() + " attributes");
}
}
Hello,
You can query the MetaDataSchema.Attribute table in the <CRMORG>_MSCRM database if you are using CRM OnPremise. The query you'd need would be something like this :
SELECT COUNT(DISTINCT AttributeId) from Attribute
-> You need to use distinct as attributes are solution aware components and you can have multiple entries for the same AttributeId (different solutions that contain this component) but this doesn't add to the total count of attributes per entity.
Another way to do this is via the SDK. An easy way to do it is via the CrmServiceClient:
docs.microsoft.com/.../microsoft.xrm.tooling.connector.crmserviceclient.getallattributesforentity -> for a specific entity
docs.microsoft.com/.../microsoft.xrm.tooling.connector.crmserviceclient.getallentitymetadata -> for all entity metadata
Or you can use the RetrieveAllEntitiesRequest - docs.microsoft.com/.../gg327609(v%3dcrm.8)
Keep in mind that you might see attributes that appear in the request but not in the UI - this is due to the fact that CRM uses also logical attributes for internal operations which can't be altered or deleted.
Hope this helps,
Radu
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (