Organization Table Metadata (Advanced Settings)

  • Article

[Applies to: Microsoft Dynamics CRM 2011]

The Organization table contains organization settings required outside the organization context. This data can be retrieved using the RetrieveAdvancedSettingsRequest message. The settings that have IsWritable set to 1 can be updated using the UpdateAdvancedSettingsRequest message. For more information about how to edit these settings with PowerShell, see Read and Update Advanced Settings with PowerShell.

The following table lists the settings for this table.

Name Description Type SchemaType PrimaryKey Locator Cached Length Nullable Uniqueifier Min Max Default IsWritable

AggregateQueryRecordLimit

Specifies the upper limit of records that can be aggregated in a query result for this organization.

int

Settings

1

1

1

AsyncRemoveCompletedJobs

Indicates for this organization whether the completed asynchronous operations are deleted from the database after the operation is completed.

bit

Settings

1

1

0

1

1

DisableAppFabricPost

Indicates whether to disable Windows Azure Service Bus posts.

bit

Settings

1

1

1

1

ExecuteMultipleMaxBatchSize

Specifies the maximum number of execute requests in a single execute multiple operation per organization.

int

Settings

1

1

1

1

IsDisabledForAsyncProcessing

Indicates whether asynchronous processing is disabled for this organization. This behavior is only enabled when the deployment setting RunAsyncServiceInSafeMode is set to true.

bit

Settings

1

1

0

1

IsLocalReportBacklogPresent

Indicates whether report replication backlog is present for the local data center.

bit

Settings

1

1

0

1

IsRemoteReportServerConfigured

Indicates whether the remote report server for this organization is configured.

bit

Settings

1

1

0

1

1

SqlConnectionMaxPoolSize

Specifies t he maximum number of connections allowed in the pool for this organization.

int

Settings

1

1

1

1

UserRootPath

Active Directory search root for finding new users for the organization.

nvarchar

Settings

1

1

1024

1

1

UseWebQueryForLiveExport

For on-premises installations, determines whether to use web query rather than SQL query in online client access mode. Replaces registry key.

bit

Settings

1

1

1

1

See Also

Concepts

Use Advanced Configuration Settings (ConfigDB)
Deployment Entities and Deployment Configuration Settings

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.