Microsoft Dynamics CRM (Archived)

How to get actual metadata for Attributemask field from Audit Table ?

(0) Share

Report

Posted on by Community Member

Hi,

I am trying to export data out of CRM into SQL Server.

I want to know actual values for below data from Attribute mask column(Audit Table).

Which contains values like

,47,45,42,96,93,107,201,28,25,53,32,14,90,178,121,61,55,108,11,35,8,177,120,69,122,117,209,46,80,78,59,10051,30,102,50,71,4,202,73,3,5,128,54,51,206,210,236,19,126,124,38,184,34,31,231,118,33,43,98,52,10037,70,123,129,132,133,103,39,114,22,48,56,10026,235,99,97,181,183,95,234,18,21,200,10045,49,106,109,110,16,24,67,74,175,44,27,139,125,208,134,10053,180,130,2,41,36,92,76,94,179,113,127,17,10039,101,233,10022,15,176,174,10043,29,203,119,37,72,40,20,173,211,91,111,105,131,10047,6,116,104,23,12,57,10041,66,100,115,26,

Also help me If Attribute and Entity tables present in CRM

how can I get this tables?

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Thangamani 507 on at

Like (0)

Report

Hi Sri,

Attribute table is available for all the attributes.

String map table is there for option set attribute details and

Entityview table stores the entity information.

Regards,

Thangamani

Was this reply helpful? Yes No
Suggested answer

Thangamani 507 on at

Like (0)

Report

Hi,

Pls chk this Link for the details.

community.dynamics.com/.../ms-crm-audit-database-table-details

Regards,

Thangamani

Was this reply helpful? Yes No
Suggested answer

ajithnairms 32 on at

Like (1)

Report

I have been searching answers to this. It is here.

carldesouza.com/.../

https://<CLIENT_URL>/api/data/v9.2/EntityDefinitions(LogicalName='<TABLE_NAME>')/Attributes?$select=SchemaName,ColumnNumber&$filter=(SchemaName eq '<FIELD_NAME>')

Was this reply helpful? Yes No
Suggested answer

Vaishnav Sudhakar 3 on at

Like (0)

Report

Hi

You can query the API for the EntityDefintions with your Entity name

Please update the org and entity details and you should be good

https://<org>.crm.dynamics.com/api/data/v9.2/EntityDefinitions(LogicalName='<entity_name>')/Attributes?$select=LogicalName,ColumnNumber

Example:

https://<org>.crm.dynamics.com/api/data/v9.2/EntityDefinitions(LogicalName='account')/Attributes?$select=LogicalName,ColumnNumber

Since you are intrested in the Audits, Better to filter out only the audit enabled fields

https://org.crm.dynamics.com/api/data/v9.2/EntityDefinitions(LogicalName='<entity_name>')/Attributes?$select=LogicalName,ColumnNumber,IsAuditEnabled&$filter=IsAuditEnabled/Value eq true

Example:

https://<org>.crm.dynamics.com/api/data/v9.2/EntityDefinitions(LogicalName='account')/Attributes?$select=LogicalName,ColumnNumber,IsAuditEnabled&$filter=IsAuditEnabled/Value%20eq%20true

Documentation : https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/query-metadata-web-api

PS: I have only explored the support for v9.2, v9.0 but it should for most versions

Was this reply helpful? Yes No

Community site session details

How to get actual metadata for Attributemask field from Audit Table ?

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

How to get actual metadata for Attributemask field from Audit Table ?

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