Entity Storage Profile (entitystorageprofile) table/entity reference (Microsoft Dynamics 365)

Precomputed entity-level storage metrics and cascade fan-out averages for the Storage Advisor.

Messages

The following table lists the messages for the Entity Storage Profile (entitystorageprofile) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
`Associate` Event: True	Associate records	Associate records
`Create` Event: True	`POST` /entitystorageprofiles See Create	Create records
`CreateMultiple` Event: True	CreateMultiple	CreateMultipleRequest
`Delete` Event: True	`DELETE` /entitystorageprofiles(entitystorageprofileid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`IsValidStateTransition` Event: False	IsValidStateTransition	IsValidStateTransitionRequest
`Retrieve` Event: True	`GET` /entitystorageprofiles(entitystorageprofileid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: True	`GET` /entitystorageprofiles See Query data	Query data
`SetState` Event: True	`PATCH` /entitystorageprofiles(entitystorageprofileid) Update the `statecode` and `statuscode` properties.	SetStateRequest
`Update` Event: True	`PATCH` /entitystorageprofiles(entitystorageprofileid) See Update	Update records
`UpdateMultiple` Event: True	UpdateMultiple	UpdateMultipleRequest
`Upsert` Event: False	`PATCH` /entitystorageprofiles(entitystorageprofileid) See Upsert a table row	UpsertRequest
`UpsertMultiple` Event: False	UpsertMultiple	UpsertMultipleRequest

Properties

The following table lists selected properties for the Entity Storage Profile (entitystorageprofile) table.

Property	Value
DisplayName	Entity Storage Profile
DisplayCollectionName	Entity Storage Profiles
SchemaName	`entitystorageprofile`
CollectionSchemaName	`entitystorageprofiles`
EntitySetName	`entitystorageprofiles`
LogicalName	`entitystorageprofile`
LogicalCollectionName	`entitystorageprofiles`
PrimaryIdAttribute	`entitystorageprofileid`
PrimaryNameAttribute	`name`
TableType	`Standard`
OwnershipType	`OrganizationOwned`

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

ActionId
ActionType
AvgCascadeRecordCount
AvgCascadeSizeBytes
AvgRecordSizeBytes
CascadeEntityBreakdown
EntityId
EntityLogicalName
EntityObjectTypeCode
entitystorageprofileId
ImportSequenceNumber
IsLiked
LastEvaluatedOn
LogicalCollectionName
MatchingRecordCount
Name
OverriddenCreatedOn
PolicyCriterionId
SampleSize
statecode
statuscode
TimeZoneRuleVersionNumber
TotalDataSizeBytes
TotalIndexSizeBytes
TotalRecordCount
UTCConversionTimeZoneCode

ActionId

Property	Value
Description	Identifier of the action (e.g. bulk delete job or retention policy) associated with this recommendation.
DisplayName	Action Id
IsValidForForm	True
IsValidForRead	True
LogicalName	`actionid`
RequiredLevel	None
Type	Uniqueidentifier

ActionType

Property	Value
Description	Type of action taken on this recommendation (Delete or Retain).
DisplayName	Action Type
IsValidForForm	True
IsValidForRead	True
LogicalName	`actiontype`
RequiredLevel	None
Type	Picklist
DefaultFormValue
GlobalChoiceName	`entitystorageprofile_actiontype`

ActionType Choices/Options

Value	Label
0	Delete
1	Retain

AvgCascadeRecordCount

Property	Value
Description	Average number of cascade-related records per parent record.
DisplayName	Avg Cascade Record Count
IsValidForForm	True
IsValidForRead	True
LogicalName	`avgcascaderecordcount`
RequiredLevel	None
Type	Double
ImeMode	Auto
MaxValue	1000000000
MinValue	0
Precision	2

AvgCascadeSizeBytes

Property	Value
Description	Average total bytes freed per parent delete including cascade.
DisplayName	Avg Cascade Size (Bytes)
IsValidForForm	False
IsValidForRead	True
LogicalName	`avgcascadesizebytes`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

AvgRecordSizeBytes

Property	Value
Description	Average bytes per row including data and index overhead.
DisplayName	Average Record Size (Bytes)
IsValidForForm	False
IsValidForRead	True
LogicalName	`avgrecordsizebytes`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

CascadeEntityBreakdown

Property	Value
Description	JSON breakdown of per-child-entity cascade averages.
DisplayName	Cascade Entity Breakdown
IsValidForForm	True
IsValidForRead	True
LogicalName	`cascadeentitybreakdown`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

EntityId

Property	Value
Description	MetadataId of the entity being profiled.
DisplayName	Entity Id
IsValidForForm	True
IsValidForRead	True
LogicalName	`entityid`
RequiredLevel	None
Type	Uniqueidentifier

EntityLogicalName

Property	Value
Description	Logical name of the entity (e.g. account, contact).
DisplayName	Entity Logical Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`entitylogicalname`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	128

EntityObjectTypeCode

Property	Value
Description	Object type code of the entity.
DisplayName	Entity Object Type Code
IsValidForForm	True
IsValidForRead	True
LogicalName	`entityobjecttypecode`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

entitystorageprofileId

Property	Value
Description	Unique identifier for the entity storage profile record.
DisplayName	Entity Storage Profile
IsValidForForm	False
IsValidForRead	True
LogicalName	`entitystorageprofileid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

ImportSequenceNumber

Property	Value
Description	Sequence number of the import that created this record.
DisplayName	Import Sequence Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`importsequencenumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

IsLiked

Property	Value
Description	Whether the user has marked this recommendation as useful.
DisplayName	Is Liked
IsValidForForm	True
IsValidForRead	True
LogicalName	`isliked`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`_entitystorageprofile_isliked`
DefaultValue	False
True Label
False Label

LastEvaluatedOn

Property	Value
Description	Timestamp of last profile computation.
DisplayName	Last Evaluated On
IsValidForForm	True
IsValidForRead	True
LogicalName	`lastevaluatedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

LogicalCollectionName

Property	Value
Description	Logical collection name of the entity (e.g. accounts, contacts).
DisplayName	Logical Collection Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`logicalcollectionname`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	128

MatchingRecordCount

Property	Value
Description	Number of rows matching this profile's policy criterion at the last evaluation.
DisplayName	Matching Record Count
IsValidForForm	False
IsValidForRead	True
LogicalName	`matchingrecordcount`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Name

Property	Value
Description	Display name for the storage profile record.
DisplayName	Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	256

OverriddenCreatedOn

Property	Value
Description	Date and time that the record was migrated.
DisplayName	Record Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	`overriddencreatedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateOnly
ImeMode	Inactive
SourceTypeMask	0

PolicyCriterionId

Property	Value
Description	Reference to the policy criterion this profile row was computed for.
DisplayName	Policy Criterion
IsValidForForm	True
IsValidForRead	True
LogicalName	`policycriterionid`
RequiredLevel	None
Type	Lookup
Targets	policycriterion

SampleSize

Property	Value
Description	Number of records sampled for cascade estimation.
DisplayName	Sample Size
IsValidForForm	True
IsValidForRead	True
LogicalName	`samplesize`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	0

statecode

Property	Value
Description	Status of the entity storage profile.
DisplayName	Status
IsValidForForm	True
IsValidForRead	True
LogicalName	`statecode`
RequiredLevel	SystemRequired
Type	State
DefaultFormValue
GlobalChoiceName	`entitystorageprofile_statecode`

statecode Choices/Options

Value	Details
0	Label: Active DefaultStatus: 1 InvariantName: `Active`
1	Label: Inactive DefaultStatus: 2 InvariantName: `Inactive`

statuscode

Property	Value
Description	Reason for the status of the entity storage profile.
DisplayName	Status Reason
IsValidForForm	True
IsValidForRead	True
LogicalName	`statuscode`
RequiredLevel	None
Type	Status
DefaultFormValue
GlobalChoiceName	`entitystorageprofile_statuscode`

statuscode Choices/Options

Value	Details
1	Label: Active State:0 TransitionData: None
2	Label: Inactive State:1 TransitionData: None

TimeZoneRuleVersionNumber

Property	Value
Description	For internal use only.
DisplayName	Time Zone Rule Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`timezoneruleversionnumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

TotalDataSizeBytes

Property	Value
Description	Total data pages size in bytes.
DisplayName	Total Data Size (Bytes)
IsValidForForm	False
IsValidForRead	True
LogicalName	`totaldatasizebytes`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

TotalIndexSizeBytes

Property	Value
Description	Total index size in bytes.
DisplayName	Total Index Size (Bytes)
IsValidForForm	False
IsValidForRead	True
LogicalName	`totalindexsizebytes`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

TotalRecordCount

Property	Value
Description	Total number of rows in the entity table.
DisplayName	Total Record Count
IsValidForForm	False
IsValidForRead	True
LogicalName	`totalrecordcount`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

UTCConversionTimeZoneCode

Property	Value
Description	Time zone code that was in use when the record was created.
DisplayName	UTC Conversion Time Zone Code
IsValidForForm	False
IsValidForRead	True
LogicalName	`utcconversiontimezonecode`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-1

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.

CreatedBy
CreatedOn
CreatedOnBehalfBy
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OrganizationId
VersionNumber

CreatedBy

Property	Value
Description	Unique identifier of the user who created the record.
DisplayName	Created By
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Date and time when the record was created.
DisplayName	Created On
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who created the record.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	`createdonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedBy

Property	Value
Description	Unique identifier of the user who modified the record.
DisplayName	Modified By
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Date and time when the record was modified.
DisplayName	Modified On
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who modified the record.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	`modifiedonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

OrganizationId

Property	Value
Description	Unique identifier for the organization
DisplayName	Organization Id
IsValidForForm	False
IsValidForRead	True
LogicalName	`organizationid`
RequiredLevel	None
Type	Lookup
Targets	organization

VersionNumber

Property	Value
Description	Version Number
DisplayName	Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`versionnumber`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

lk_entitystorageprofile_createdby
lk_entitystorageprofile_createdonbehalfby
lk_entitystorageprofile_modifiedby
lk_entitystorageprofile_modifiedonbehalfby
organization_entitystorageprofile
policycriterion_entitystorageprofile_PolicyCriterionId

lk_entitystorageprofile_createdby

One-To-Many Relationship: systemuser lk_entitystorageprofile_createdby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdby`
ReferencingEntityNavigationPropertyName	`createdby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_entitystorageprofile_createdonbehalfby

One-To-Many Relationship: systemuser lk_entitystorageprofile_createdonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdonbehalfby`
ReferencingEntityNavigationPropertyName	`createdonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_entitystorageprofile_modifiedby

One-To-Many Relationship: systemuser lk_entitystorageprofile_modifiedby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedby`
ReferencingEntityNavigationPropertyName	`modifiedby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_entitystorageprofile_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_entitystorageprofile_modifiedonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedonbehalfby`
ReferencingEntityNavigationPropertyName	`modifiedonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

organization_entitystorageprofile

One-To-Many Relationship: organization organization_entitystorageprofile

Property	Value
ReferencedEntity	`organization`
ReferencedAttribute	`organizationid`
ReferencingAttribute	`organizationid`
ReferencingEntityNavigationPropertyName	`organizationid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

policycriterion_entitystorageprofile_PolicyCriterionId

One-To-Many Relationship: policycriterion policycriterion_entitystorageprofile_PolicyCriterionId

Property	Value
ReferencedEntity	`policycriterion`
ReferencedAttribute	`policycriterionid`
ReferencingAttribute	`policycriterionid`
ReferencingEntityNavigationPropertyName	`PolicyCriterionId`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

entitystorageprofile_AsyncOperations
entitystorageprofile_BulkDeleteFailures
entitystorageprofile_MailboxTrackingFolders
entitystorageprofile_PrincipalObjectAttributeAccesses
entitystorageprofile_ProcessSession
entitystorageprofile_SyncErrors

entitystorageprofile_AsyncOperations

Many-To-One Relationship: asyncoperation entitystorageprofile_AsyncOperations

Property	Value
ReferencingEntity	`asyncoperation`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`entitystorageprofile_AsyncOperations`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

entitystorageprofile_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure entitystorageprofile_BulkDeleteFailures

Property	Value
ReferencingEntity	`bulkdeletefailure`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`entitystorageprofile_BulkDeleteFailures`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

entitystorageprofile_MailboxTrackingFolders

Many-To-One Relationship: mailboxtrackingfolder entitystorageprofile_MailboxTrackingFolders

Property	Value
ReferencingEntity	`mailboxtrackingfolder`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`entitystorageprofile_MailboxTrackingFolders`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

entitystorageprofile_PrincipalObjectAttributeAccesses

Many-To-One Relationship: principalobjectattributeaccess entitystorageprofile_PrincipalObjectAttributeAccesses

Property	Value
ReferencingEntity	`principalobjectattributeaccess`
ReferencingAttribute	`objectid`
ReferencedEntityNavigationPropertyName	`entitystorageprofile_PrincipalObjectAttributeAccesses`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

entitystorageprofile_ProcessSession

Many-To-One Relationship: processsession entitystorageprofile_ProcessSession

Property	Value
ReferencingEntity	`processsession`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`entitystorageprofile_ProcessSession`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

entitystorageprofile_SyncErrors

Many-To-One Relationship: syncerror entitystorageprofile_SyncErrors

Property	Value
ReferencingEntity	`syncerror`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`entitystorageprofile_SyncErrors`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Feedback

Was this page helpful?

Last updated on 2026-09-19