Count Attributes per entity

(0) Share

Report

Posted on by gavibe

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

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Radu Chiribelea 6,667 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Kokulan 18,054 on at

Like (0)

Report

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");
}
}

Was this reply helpful? Yes No
Suggested answer

Kalpavruksh D365 CoE 2,545 on at

Like (0)

Report

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.

Was this reply helpful? Yes No

Community site session details

Count Attributes per entity

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates

Community site session details

Count Attributes per entity

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Featured topics

Product updates