CRM Crate

Update database settings in the Power Platform environment.

We will learn how to update database settings in an environment & understand its significance in Power Platform. Before we start, make sure to subscribe to CRM Crate so that you can stay up to date in the field of Power Platform.

Learn to update environment database settings in Power Platform.

You have the option to construct databases and develop applications utilizing Dataverse as a data repository. This involves the choice of either building your personalized tables or utilizing the pre-established ones. In this article we will learn how to modify Power Platform environment database settings for fulfilling your application designing requirements.

Modify database settings in Power Platform environments

Each environment has a set of database settings that determine default option behavior. You can modify these default options using a specialized tool called OrgDBSettings. This tool enables the system administrator to override the default database settings.

Follow the below steps for installing the OrganizationSettingsEditor tool in your Power Platform environment.

  1. Download the latest OrganizationSettingsEditor tool from the above given link.
  2. Login into Power Platform Admin Center ( and open an environment of your choice.
  3. Navigate to Advance Settings >> Solution.
  4. Import the solution downloaded from the above link into your environment.

Follow the below steps for modifying & overriding database settings of your environment.

  1. In your environment, go to Settings > Solution.
  2. Find the OrganizationSettingsEditor solution and double-click the OrganizationSettingsEditor record.
  3. Within the solution page, navigate to “Configuration“.
  4. For each respective database setting, click on “Add”. Further this “Add” link changes to “Edit”.
  5. Further, edit the settings as per your application’s requirement. Click on Update once done.
update database settings in the Power Platform
update database settings in the Power Platform
power platofrm environment database

The below table signifies the meaning of each database settings available for modification.

Setting Name Default ValueTypeSetting DescriptionMinimum Supported VersionMaximum Supported Version 
ActivateAdditionalRefreshOfWorkflowConditionsFALSEBooleanEnables an additional refresh of workflows that contain wait conditions and that may have to be resumed. This is required to be enabled to enable a fix that was originally released as a Critical On Demand hotfix, and was publically released starting with Update Rollup 13. When events in a Wait Until condition are met, the condition is not triggered as documented in KB 2918320.5.0.9690.34455.0.9690.3731 
ActivityConvertDlgCampaignUncheckedTRUEBooleanControls the default value of the Record Closed Campaign Response option. When you convert an activity to an opportunity, this default option controls whether the source campaign is set or not.5.0.9690.2720N/A 
False- Record Closed Campaign Response checked and source campaign will be set. 
True – Record Closed Campaign Response not checked and source campaign is not set. 
ActivityRollupChildRecordLimit50000NumberLimit the number of total aggregated activities to rollup in the Actvity Rollup Default:50, 
Used with: VisibleRecordThreshholdSwitchToMultiplelineTVF and TotalRecordThreshholdSwitchToMultiplelineTVF 
AddressBookMaterializedViewsEnabledTRUEBooleanChanges the way the CRM Client queries SQL CE5.0.9690.2903N/A 
AllowParamsNoEqualsFALSEBooleanTrue to enable, False to disable(preserve existing behavior). 
True will to skip the = in the query URI for empty string parameters 
AllowPromoteDuplicatesFALSEBooleanFalse= Does not allow for the promotion of duplicate records.   True=  Allows for the promotion of duplicate records.  This setting is NOT SUPPORTED IN CRM2013 as of build 8095.0.9690.3731N/A 
allowRoleAssignmentOnDisabledUsersFALSEBooleanEnables the assignment of a security role for user accounts with a disabled status. This allows for scenarios where stub users can be created and assigned a different security role. This is needed when a stub/disabled user account needs to own records, especially when these records are from custom entities where custom security roles are required. 
False – By default, a security role cannot be assigned to users with disabled status. This is shipped by default. 
True – Allows security role to be assigned to users with disabled status. 
AllowSaveAsDraftAppointmentFALSEBooleanSetting value to true will provide the capability to create appointments in Dynamics 365 as “draft” without synchronizing with Exchange. Appointment form will have a “Save as Draft” command and a “Send” command, so that you can save, add details and update an appointment activity without synchronizing to Exchange. Default value is set to false to preserve existing behavior. 
AlwaysCheckTraceLogDeletePrivilegeFALSEBooleanNote: TraceLog is used to log ServerSide Sync messages (not plugin logs). 
False: Only allow the user to delete if they are the *owner* of the regarding object. 
If the setting is True: if unconditional privilege checks are enabled or if the caller has prvDeleteTraceLog then allow the user to delete the trace log entries. 
AuditRetentionPeriod30Number-1 is forever, otherwise the value should be 30 days or greater. 
All audit records that fall beyond the maximum retention will eventually be deleted. 
AutoCreateContactOnPromoteTRUEBooleanDisables the ability of the organization to create contact records automatically when an email message is tracked in CRM. This option can also be disabled from the user settings area for each user.5.0.9688.583N/A 
False – Disables the automatic creation of contacts. 
True – Enables the automatic creation of contacts. 
AutoTrackSentFolderItemsFALSEBooleanSetting value to True will result in Server Side Sync auto tracking of emails from Sent Items. For more information, see Automatically track sent folder items with server-side synchronization. 
Default value is set to False to preserve the existing behavior. 
Note: Prior to version 9.1.0000.20463, this setting is only applied if the mailbox was configured to track “All Email Messages”. 
BackgroundSendBatchSize10IntSets the number of email messages to download in one batch for the BackgroundSend API.5.0.9690.583N/A 
BPFInstanceDaysModifiedForOfflineSync365NumberControl the last x days of BPF Instances to sync during offline sync. 
BUIdsCountBeforeUsingSubqueryForPostsSecurity500NumberLimits the BUid’s parameterized in the query and will fall back to using a subquery to avoid having too man sql parameters. 
CanCreateApplicationStubUserFALSEBooleanAllow the creation of application stub user. 
ChangeDoubleQuoteToSingleQuoteFALSEBooleanChanges double quotation marks to single quotation marks within KB articles when the article is viewed.5.0.9690.3541N/A 
CleanInheritedAccessWhenReparentOrShareCascadingNoneFALSEBooleanClean out all inherited access when reparenting or after cascade sharing is set to none. 
ClearSystemUserPrincipalsWhenDisableTRUEBooleanClear and/or populates SystemUserPrincipals values for systemUsers when they’re disabled/enabled6.1.1.123N/A 
ClientDisableTrackingForReplyForwardEmailsFALSEBooleanEnables a user not to automatically track replies and forwarded email messages. Set this to “True” to disable tracking replies and forwarded email messages. 5.0.9690.2903N/A 
NOTE: This setting only applies to Dynamics 365 for Outlook (not Dynamics 365 App for Outlook). 
ClientUEIPDisabledFALSEBooleanDisables the sending of customer experience feedback for the organization. This option can also be disabled from the user settings area for each user.5.0.9688.583N/A 
False – Enables the sending of experience feedback. 
True – Disables the sending of experience feedback. 
CreateQueueItemsForAcceptingQueueRecipientsTRUEBooleanWhen it is enabled, the system will create a queue item for each queue recipient during incoming email processing. If AutoRouteToOwnerQueue is enabled, the system additionally creates a queue item in the email owner’s default queue.9.1.0000.23475N/A 
CreateQueueItemForSynchronizingMailboxTRUEBooleanWhen tracking an email into Dynamics, create a queue item for the queue which is synchronizing the email message (this will affect queue item creation for mailboxes in the BCC line or contained in a distribution list.) 
CreateSPFoldersUsingNameandGuidTRUEBooleanTrue: creates SharePoint folders using the format of {Name}+{GUID}.- false: Creates SharePoint folders using just the name6.0.0.809N/A 
DefaultHeightForWizardReports8.25DoubleWith a default value 0: CRM will use 8.25 inches (A4), any other double value will override the default of 8.25.  Some printers may reject printed reports if the height is any less than the height of the paper loaded in the tray, this setting will override the height used5.0.9690.3541N/A 
DelegateAccessEnabledFALSEBooleanOrg setting to enable Delegate Access. 
DisableClientUpdateNotificationFALSEBooleanSetting DisableClientUpdateNotification to true will disable the outlook client from checking for newer versions7.0.0000.3027N/A 
DisableIECompatModeFALSEBooleanChanges the server-side, automatic, IE Compatibility Mode Flag for Internet Explorer browsers. If you want pages to render in the most recent version of Internet Explorer set this to True. If you have form scripts or other customizations that require earlier versions of Internet Explorer this should be set to False. This is also controlled via Settings | Administration | System Settings | Customization5.0.9690.3233N/A 
DisableImplicitSharingOfCommunicationActivitiesFALSEBooleanChanging this to “True” will disable implicit sharing of records to recipients that are added to existing activities.5.0.9690.2903N/A 
DisableInactiveRecordFilterForMailMergeFALSEBooleanWhen you perform a mail merge, inactive records are not included. This option lets you override that functionality.5.0.9688.583N/A 
False – Inactive records will not be included in the mail merge. 
True – Inactive records will be included in the mail merge. 
DisableLookupMruOnOutlookOfflineFALSEBooleanLookupMRUItems in UserEntityUISettings can cause a large data volume when going online, setting this to true will stop MRU’s from syncing back ONLINE6.1.0002.0106N/A 
DisableMapiCachingFALSEBooleanWhen this value is set to “True,” users can still pin the views. However, the query is sent to the CRM Server to retrieve the results instead of to the local cache to prevent performance issues.  5.0.9690.2903N/A 
Note This value is not valid with CRM 2013. 
DisableNavTourFALSEBooleanOverride the navigation tour setting for the entire Organization this allows you to permanently disable the welcome screen shown to users when they first login to CRM7.1.2.1020N/A 
If this is set to false, a user will be shown the navigation tour every time their browser cookies expire or are cleared and when they login to CRM from an unkown browser (like on a shared PC or different computer).  
Note This value is not valid with CRM 2013.  
DisableSharePointConnectionKeepAliveFALSEBoolean“<b>Use With Caution</b>:Disables the Sharepoint Sync connection KeepAlive property – this should only be used with specific guidance when using an OnPrem Sharepoint URL with Sharepoint Sync and when the onprem sharepoint server has too small of a TLS KeepAlive time configured on their Sharepoint IIS server or NLB9.1.0.2859N/A 
DisableSmartMatchingFALSEBooleanDisables the smart matching functionality and relies on the tracking token on the incoming e-mails for email tracking.5.0.9688.583N/A 
False – Enables smart matching. 
True – Disables smart matching. 
DistinctPhysicalAndLogicalDeletesForExchangeSyncFALSEBooleanServer-Side synchronization needs a mechanism to distinguish between Logical and Physical deletes of entities in CRM8.2.2.0840N/A 
False : No distinction between physical and logical deletes for exchange sync delete scenario 
True : Physical and logical deletes will be distinguished for exchange sync delete scenario 
DoNotAutoTrackEmailTRUEBooleanWhen the setting is enabled, the No Email Messages option is displayed in the user’s or queue’s incoming email filtering method options. 
DoNotCorrelateForwardedEmailsAsRepliesFALSEBooleanIf this setting is set to TRUE, Server-Side Sync will not consider forwarded emails as replies. If the value is FALSE, Server-Side Sync will consider forwarded emails as replies9.2.21035.00195N/A 
Example scenario: A Dynamics user received an email A with message ID <msg-A>. The user decides to forward this email to another user, thus generating a new email B with message ID <msg-B>. This new email message will have an In-Reply-To header pointing back to email message A. Based solely on this information, Server-Side Sync would consider email message B as a reply to email message A, even though it’s a forwarded email. To tell replies apart from forwarded messages, we can look at the recipients of email B. If the sender of email A is a recipient of email B, then we can say it’s a reply. Otherwise, it’s a forwarded email. This OrgDbOrgSettings setting enables this additional comparison for the In-Reply-To correlation criteria. 
NOTE: This setting disables conversationIndex correlation as conversationIndex is incompatible with the feature. Smart matching and tracking token correlation will continue to function and have priority over this setting as their purpose is to correlate emails based on other data (recipients, subject words, tracking token in subject). For this reason we recommend disabling smart matching (OFF by default) and tracking token as they could interfere with this setting in certain cases. 
DoNotIgnoreInternalEmailToQueuesVersion 5.0.9690.1533 to FalseBooleanIf you disable the “Track email sent between CRM users as two activities” setting, email messages from a CRM user to a queue are not delivered. Additionally, if a workflow rule sends an email message to a queue, email messages that are sent by the workflow rule are not delivered.5.0.9690.1533N/A 
Version and higher: TrueFalse – Internal email messages to queues will not be delivered. 
 True – Internal email messages to queues will be delivered. 
DupeDetectionSkipIfNoMatchCodeFieldsChangedFALSEBooleanSkip duplicate detection record updates if none of the relevant/included match code fields change.9.1.0000.10537N/A 
EmailEditorSkipNewLineInIEFALSEBooleanResolution to address the p tag issue in IE9.1.0.2859N/A 
EmailTemplateRetrieveFallbackContactFALSEBooleanScenario: Opportunity/case which refer to a customerId of type account and do that account does not have a primary contact specified. 
False: (Default behavior) Use the primary account and retrieve the primary contact, if the account is null it will leave the contact field in the email template null. 
True: Fall back to using the Opportunity or Case primaryContactId if the account reference is null. 
EnableActivitiesFeatures0NumberBitmask to Enable various activities feature in UCI; 1 to enable, 0 to disable(preserve existing behavior9.1.0.1639N/A 
EnableActivitiesTimeLinePerfImprovement0Number1 to enable, 0 to disable(preserve existing behavior) 
EnableAppointmentBroadcastingForOutlookSync0NumberSetting for Appointment broadcasting for Outlook Synchronization7.0.1.121N/A 
EnableBulkReparentTRUEBooleanDisables and reparents using a one record at a time approach6.0.0.809N/A 
EnableCrmStatecodeOnOutlookCategoryTRUEBooleanEnables Statecode data on contact sync6.1.0.581N/A 
EnableLicenseEnforcementFALSEBooleannline only setting to enable license enforcing for organizations/environments created before 4/1/2020 for customer testing purposes. 
EnableQuickFindOptimization1IntFor more information, see the “Optimizing the Performance of Quick Find Queries” section in the Optimizing and Maintaining the Performance of a Dynamics CRM 2011 Server Infrastructure.5.0.9690.2720N/A 
EnableRetrieveMultipleOptimization0IntFor more information, see the “Optimizing the Performance of Queries against Large Datasets section” in the Optimizing and Maintaining the Performance of a Dynamics CRM 2011 Server Infrastructure.5.0.9690.1533N/A 
EnableReLinkingToExistingCRMRecord0IntEnables a user to re-track contact records.5.0.9690.3445N/A 
EnableSssItemLevelMonitoringFALSEBooleanSetting value to True will enable a new dashboard accessible by users and administrators called Server-Side Synchronization Failures. This dashboard allows the owner of a mailbox to have information about all non-synched incoming/outgoing emails and also appointment, contact, and task (ACT) items. Information is provided for the reason items are not synchronized. Default value is set to False to preserve the existing behavior. You can use the ExchangeSyncIdMappingPersistenceTimeInDays setting to control how long the data for failed emails is retained. 
EnableTDSEndpointFALSEBooleanEnable a SQL TDS Endpoint for your CDS Environment – NOTE: your region will also have to support TDS endpoints, the regions with support for TDS may vary (as documented in the docs url provided here: 
EnableViewSelectorForEmailTemplatesInPersonalOptionsDialogFALSEBooleanSetting to true Enables the View Selector For EmailTemplates in the personalOptions Dialog. 
Default value is set to false. 
ExchangeSyncIdMappingPersistenceTimeInDays3IntThe number of days for which the ExchangeSyncIdMappings are to be persisted for failed emails. This setting is used in relation to the EnableSssItemLevelMonitoring setting. It is not recommended to increase this value higher than 7 days as it can lead to the table growing very large. 
ExportedExcelRetentionWindow5NumberThe number of days to temporarily store Excel exported Office Document Records. 30 days max was selected arbitrarily as this is only a cache. Must be at least 
ForceRetrievePublishedMetadataForRetrieveAllEntitiesFALSEBooleanAll RetrieveAllEntities requests will ignore the AsIfPublished flag so that it always retrieves the published metadata from cache. 
FullTextSpecialCharactersToRemoveFromSearchTokennullStringThis allows an organization to remove certain characters from a fulltext search string. 
Example: To remove a wildcard character from a FullText search, add “*”. To remove multiple characters, add them all together in a single string value “*.’#”. The characters are separated by ToCharArray. 
GrantFullAccessForMergeToMasterOwnerTRUEBooleanWhen two records owned by the same team are merged, the final record is shared with the owner of the record it was merged from. This creates redundant POA records, as a result, if the owner of the record is changed in the future it will be visible to team members of the previously owning team. To do this, set to false.5.0.9690.4449N/A 
GrantSharedAccessForMergeToSubordinateOwnerTRUEBooleanTo turn this setting off, this must be set to false. Records are shared with inherited access to subordinate owners during merge. This will not occur when set to false.5.0.9690.3911N/A 
HideEmailAutoTrackOptionsFALSEBooleanDefault value is false, if it’s set to True: do not show the following track options in Personal Options (Email): ‘All email messages’, ‘Email messages from D365 Leads’, ‘Contacts and Accounts’, ‘Email messages from D365 records that are email enabled’. 
HideStageAndUpgrade1IntChanging this setting to 0 will allow users to see the upgrade solution option in solution import wizard when importing solutions with higher version than previously imported. This setting has a default of 1 which hides the option to perform a stage for upgrade. 
HideTrackAllOptionFALSEBooleanRemoves “All email messages” option from users’ Personal Options under Email tab Select the email messages to track in Microsoft Dynamics 365 area. 
False – “All email messages” option is shown in the dropdown. 
True – “All email messages” option is not shown in the dropdown. If a user already has “All email messages” selected, their synchronization option is not updated in DB. Administrators will need to update this value via SDK. 
HierarchyLevelForHierarchyFeature3NumberThe hierarchy level used for hierarchal security7.0.0000.3027N/A 
IfdAuthenticationMethodnullStringChanges the request sent to the ADFS server, this settings default value5.0.9690.2835N/A 
IgnoreCopiedItemsInSSSForMailboxFALSEBooleanChanges the request sent to the ADFS server, this settings default value5.0.9690.2835N/A 
IncludeHTCTRUEBooleanIgnore creating duplicate for copied items for Server Side Sync9.1.0.11129N/A 
inheritedRolePrivilegesFromTeamRolesTRUEBooleanDisables the Azure AD Group team functionality of the organization in an event that there is a performance related issue. The Azure AD Group team feature is shipped enabled by default. 
False – Disable Azure AD Group Team and members of group teams are required to have their own security role assigned to them directly.  Run-time calls to Azure AD to obtain the user’s AAD groups are stopped. 
True – Azure AD GroupTeam is enabled and members of group teams shall inherit user/basic privileges directly and user privileges are derived at run-time.  Run-time calls to Azure AD to obtain user’s AAD groups are invoked. 
IdsCountBeforeUsingJoinsForSecurity1000IntNot documented in optimization paper.5.0.9690.2720N/A 
IdsCountForUsingGuidStringsForSecurity20IntNot documented in optimization paper.5.0.9690.2720N/A 
IgnoreInternalEmailDetectionEnhancementTRUEBooleanImproves internal email detection logic by ensuring that a sent or received copy of the email being evaluated already exists in Dynamics before rejecting emails from CRM-based senders. 
IgnoreConversationIndexAndInReplyToForCorrelationFALSEBooleanOrg setting to ignore conversation index and in reply to during correlation. 
IntegratedAuthenticationMethodnullStringChanges the request sent to the ADFS server, this settings default value5.0.9690.2835N/A 
IsCommandingModifiedOnEnabledFALSEBooleanSetting to indicate if command bar rendering should use ModifiedOn date for ordering instead of VersionNumber, VersionNumber would be ordered by when it was added or updated in the database irrespective of the modifiedon date9.1.0.8031N/A 
JumpBarAlphabetOverridenullStringHow to customize the Alphabet Bar for the CRM Application Grids for Microsoft Dynamics CRM 
JumpBarNumberIndicatorOverridenullStringHow to customize the Alphabet Bar for the CRM Application Grids for Microsoft Dynamics CRM 
ListComponentInstalledFALSEBooleanIf CRM and SharePoint use ADFS and users click to create a folder for a record in CRM 2011, intermittently, the SharePoint page is shown instead of the list part grid page causing confusion with users. This setting allows you to force CRM to use the installed list grid component in SharePoint when using ADFS. false: use the standard method of detecting Sharepoint Authentication  -true: If CRM and SharePoint have ADFS enabled, force CRM to use the grid display.5.0.9690.3911N/A 
LookupNameMatchesDuringImportFALSEBooleanImporting a solution that was created from an upgraded 4.0 deployment fails. Changing this setting makes the import solution look up the names for forms, views, workflows and security roles.5.0.9690.583N/A 
MailboxStatisticsPersistenceTimeInDays3NumberIf value is 0, dont store ANY MailboxStatistics Data, if the value is greater than zero then store that number of days statistics data. Max value arbitrarily chosen at 1 year, this generates at lot of data so 1 year should be plenty of time8.0.0.1088N/A 
MakeSocialPanePhoneCallCompletedTRUEBooleanBy default (true) Phone calls created in the Social Pane are automatically marked in a completed state and cannot be edited. 
Changing this value to FALSE will create phone calls and will NOT mark them as completed 
MaximumChildUsersCountLimitBeforeUsingJoinForHSM80NumberMaximum Child/Subordinate Users Count Before Using a Join Query for Heirarchical Security Model7.0.0000.3027N/A 
MaximumSubjectLengthOnMailServer255NumberSet the maximum subject length permissible for the ***mail*** server. 
This will ensure server side sync concatinates the subject of emails sent from CDS/Dynamics. 
MinRowCountForFKIndexCreateInReferencingEntity100NumberSetting min row count in referencing table for ForeignKey index creation7.0.0000.3027N/A 
MinRowCountForFKIndexCreateInReferencedEntity100NumberSetting min row count in referenced table for ForeignKey index creation7.0.0000.3027N/A 
OfficeDocumentPersistenceTimeInDays7NumberThe number of days to temporarily store Office Document Records. 30 days max was selected arbitrarily as this is only a cache. 
officeShellServiceTimeout5IntThis setting controls the length, in seconds, that the browser will wait to render the Office Waffle within Dynamics 365. If there are issues with the Office Shell Service, it could impact the browser performance of Dynamics 365. 
OutlookClientEmailTaggerEnabledFALSEBooleanhere are 3 values for this Boolean setting – true, false, and NULL (which is the value when NOT set). True: Will override any and all client registry setting to True. False: Will override any and all client registry setting to False. NULL: If the setting is NULL the outlook clients will use whatever is in the registry of the client. TO SET THIS VALUE TO NULL YOU WILL NEED TO CLICK EDIT, THEN REMOVE THE VALUE TO HAVE IT DEFAULT TO NULL. 
OutlookSyncDataSubscriptionClientsBatchSize100NumberThis setting is used to determine how many record changes (deletes, inserts, and updates) to send back to a syncing client for each request. 
OverrideTrackInCrmBehaviour0IntWhen this option is Enabled, the ‘Track in CRM’ button functions as the Set Regarding button in Dynamics 365 for Outlook. In Dynamics 365 App for Outlook, ‘Track without regarding’ command is not displayed, with Set Regarding as the only way to synchronize Outlook items to Dynamics 365. 
0 – Normal behavior of the “Track in CRM” button not having to set a Regarding record in Dynamics 365 for Outlook. 
‘Track without regarding’ command is displayed in Dynamics 365 App for Outlook. 
1 – The ‘Track in CRM’ button functions as the ‘Set Regarding’ button, and makes you select a regarding record in Dynamics 365 for Outlook. 
In Dynamics 365 App for Outlook, ‘Track without regarding’ command is not displayed, with Set Regarding as the only way to synchronize Outlook items to Dynamics 365. 
NOTE: This setting applies to both Dynamics 365 for Outlook and Dynamics 365 App for Outlook. 
OverrideV5SenderConflictResolutionFALSEBooleanWhen multiple records with the same email address exist in the Dynamics CRM Organization and email is automatically tracked, the email address is resolved to the record for the owner record that was created first. This option lets you override that functionality.5.0.9690.2243N/A 
False – E-mails are tracked to the first record created. 
True – E-mails are not tracked automatically if there are multiple records with the same email address. 
PageSizeForHierarchyFeature5NumberThe hierarchy page size used for hierarchal security7.0.0000.3027N/A 
PercentageOfAccessibleRecordsToUseOrBasedSecurityPredicate-1Number-1 is disabled (default). 
Add support to change the security filter predicate on RetrieveMultiple based on a given percentage of records visible 
QueryColumnCountToForceOrBasedSecurityPredicate-1NumberIndicates what count of columns in a query is considered ‘high’, which may cause the security layer to use a different predicate format to keep the query as small as possible and keep the plan in the plan cache small; -1 is disabled9.1.0.2859N/A 
ReassignAllExtendedTimeout0NumberIncrease script timeout for reassigning all records of a user or team – this allows you to exceed the default extended timeout value. Default extended timeout is 1000000 ms (roughly 15 minutes). WARNING: Care should be taken when increasing this value above the default – always double check the number of minutes before setting this to a value higher than the default7.1.2.1020N/A 
RecordCountLimitToSwitchToCteSecuritySql75000IntFor more information see the Optimizing the Performance of Queries against Large Datasets” section in the Optimizing and Maintaining the Performance of a Dynamics CRM 2011 Server Infrastructure.5.0.9690.2720N/A 
ResolveForInactiveEntitiesFALSEBooleanWhen setting to true, email addresses for inactive tables are ignored for email address resolution of the To and Cc recipient lists. 
Setting it to false ensures inactive records are skipped when resolving. 
Note: This setting doesn’t apply to system users whose accounts have been disabled, who are always excluded. This setting also does not apply to the From field. 
RestrictIRMEmailItemsFALSEBooleanSetting value to TRUE will result in Server Side Sync NOT synchronizing ALL emails that are marked as IRM emails. 
Default value is set to False to preserve the existing behavior. 
To enable this restriction on the organization ” RestrictIRMEmailItems ” should be set to True. 
RetrieveMultipleSharingCountThreshold1000IntFor more information, see the “Optimizing the Performance of Queries against Large Datasets section” in the Optimizing and Maintaining the Performance of a Dynamics CRM 2011 Server Infrastructure.5.0.9690.2720N/A 
SecuritySettingForEmail1Number1: Display a Warning Message And give an option to open – 2: Display a Warning Message and do not give an option to open -3: Do not display a Warning Message and do not give any option to open. This setting is NOT SUPPORTED IN CRM2013 as of build 8095.0.9690.3731N/A 
SecurityQueryHint1NumberUsed to hint the query within GetRightsFromPrincipalObjectAccess. 0=None; 1=Recompile (default); 2=OptimizeForUnkown8.1.0.141N/A 
SendEmailSynchronously0IntIf you have a plugin registered on the email send flow, you should change this setting to “1.” 5.0.9690.2720N/A 
0 – Email is sent asynchronously. 
1 – Email is sent synchronously. 
SetRegardingLookupDefaultEntityTypenullStringChanges default entity for Regarding Lookup Dialog.5.0.9690.2835N/A 
SharingLimitForPOASnapshotTable10IntNot documented in optimization paper.5.0.9690.2720N/A 
skipAadGroupObjectIdValidationFALSEBooleanDisables the validation of Azure AD Group objectID and allows application to create Group team in CDS.  This is used to mitigate the latency in the Azure AD distributed cache where a newly created Azure AD group cannot be validated if the subsequent Azure AD Group graph call goes to a distributed cache server that does not have the new Azure AD group yet. 
False – do not skip Azure AD group objectID validation during Group Team creation.  This is shipped by default. 
True – skip Azure AD group objectID validation to allow application to create Group team. 
SkipGettingRecordCountForPagingFALSEBooleanDisables the record count query. This query is responsible for retreiving the total number of records returned for each view. This query can cause longer search times and may cause SQL timeouts or exceptions.5.0.9690.1992N/A 
False – Enables record depend on views. 
True – Disables record depend on views. 
SkipGettingRecordCountForPagingForAuditFALSEBooleanDisabled the record count query for just the Audit entity. False enables the record count, and True disables the record count8.2.0.0503N/A 
SkipSuffixOnKBArticlesFALSEBooleanDisables the suffix from being used on the automatically generated KB article numbers.5.0.9690.1992N/A 
False – Enables the suffix on KB articles. 
True – Disables the suffix on KB articles. 
SocialPaneQueryHint-1NumberExpected values:<br>None = -1,<br>OptimizeForUnknown = 0,<br>ForceOrder = 1,<br>Recompile = 2,<br>DisableRowGoal =3<br>Any value outside this range will be treated as - 
SolutionExportExtendedTimeout0NumberThis setting makes it possible to override the solution export timeout, this setting is in milliseconds and the default platform timeout is 1000000ms (about 16 minutes). 
If this setting is set to any number LESS than the extendedTimeout value will be ignored and the extendedTimeout will be used instead. 
This setting will ensure your timeout is at least this number of ms long 
SortEmailByReceivedOnFALSEBooleanWhen the Activities tab of the social pane is show, the data ordered by the ‘modifiedon’ date in descending order, toggling this setting to True will enable the social pane to sort emails by RecievedOn Desc instead of modifiedon8.0.1.79N/A 
SortURIQueryParametersTRUEBooleanFalse to disable, True to disable(preserve existing behavior). 
If true, we are sorting the query URI parameters. 
SSSCreateAdditionalQueueItemsForAlreadyTrackedEmailFALSEBooleanWhen it is enabled, Server-Side Synchronization will create an additional queue item for an email message found in a queue mailbox if the email message has already been delivered to Dynamics by another user or queue.9.2.21012.00103N/A 
SSSForceFilteringMethodForUserMailboxes-1IntOverrides the incoming email filtering method for all user mailboxes based on the following values:9.1.0000.25547N/A 
-1: Setting disabled. 
0: All email messages. 
1: Email messages in response to Dynamics 365 Email. 
2: Email messages from leads, contacts, and accounts. 
3: Email messages from Dynamics 365 records that are email message enabled. 
4: No email messages. 
SSSPropagateAppointmentCancellationsToExchangeFALSEBooleanEnabling the feature allows appointment cancellations from Dynamics to propagate to Exchange via SSS. 
SSSSaveOutgoingEmailToExchangeSentFolderTRUEBooleanDetermines if email messages sent from CRM using SSS should be saved to the Sent Items folder in Exchange Server.9.2.21052.00121N/A 
SSSTagAlreadyTrackedEmailsTRUEBooleanAllows Server-Side Synchronization to tag emails in Dynamics 365 recipient mailboxes if the email being evaluated has already been tracked.9.1.0000.23304N/A 
SSSTaskDeletionSyncBehaviorFromExchange0IntSpecifies how task deletions in Exchange are synchronized to their linked Dynamics 365 activity record.9.2.22061.00152N/A 
0: Tasks deleted in Exchange are deleted in Dynamics (default). 
1: Tasks deleted in Exchange are deleted in Dynamics if they are not completed. 
2: Tasks deleted in Exchange are never deleted in Dynamics. 
StoreOutlookSyncDataInSensitivityPropertyTRUEBooleantrue:Preserve existing behavior.- false: Stop storing CRM Sync information in the PidTagSensitivity MAPI property which causes the error: error in the XML document on GetItem for IPM.MSCRMUserId on BlackerBerry Server Traces.5.0.9690.3911N/A 
TabletClientMaxFields75NumberMaximum Tablet Fields max-500/ min- 
TabletClientMaxLists10NumberMaximum Tablet Lists max-50/min- 
TabletClientMaxMashups3NumberMaximum Tablet Mashups7.0.0000.3027N/A 
TabletClientMaxTabs5NumberMaximum Tablet Tabs max-50/min- 
TotalRecordThreshholdSwitchToMultiplelineTVF1000NumberUsed for activity rollup performance tuning along with: VisibleRecordThreshholdSwitchToMultiplelineTVF and ActivityRollupChildRecordLimit9.1.0.8031N/A 
TraceExchangeSyncDataTRUEBooleanEnables exchange sync tracing6.0.0.809N/A 
traceLogPersistenceTimeInDays30IntThis sets the amount of time that TraceLog data is maintained before being removed by the Deletion Service. 
TrackAppointmentFromNonOrganizerTRUEBooleanEnabled users to track appointments organized by another Dynamics 365 user via Dynamics 365 App for Outlook. 
False  –  Dynamics 365 App for Outlook and Server-Side Synchronization users cannot track Outlook appointments whose organizer is a Dynamics 365 user. 
True  –  Dynamics 365 App for Outlook and Server-Side Synchronization users can track Outlook appointments whose organizer is a Dynamics 365 user. 
TrackCategorizedItemsTRUEBooleanSetting value to False will remove the category tracking flag and functionality. 
Default value is set to True to allow category tracking and tracking status visibility for users whom do not use Dynamics 365 for Outlook or Dynamics 365 App for Outlook. 
UseCrmOrganizerForEmptyExchangeOrganizerFALSEBooleanUse the CRM Organizer of an Appointment if the Exchange Organizer doesn’t exist. 
UseFilteringMethodOfSyncingMailboxOnlyForCorrelationFALSEBooleanThis is for controlling which users’ filtering settings will be used  for correlation. 8.2N/A 
False  – filtering method of all recipients of the email will be checked to decide if any user/queue accepts email or not. 
True  – filtering setting of user who synced email to CRM will be used. Filtering  setting of other recipients of the emails will be ignored. 
UseOrganizationServiceForMultiEntityQuickFindFALSEBooleanAllows Multi-entity Quick Find to run serially rather than in parallel. This allows plugins to be executed on RetrieveMultiple. 
UsePlainTextForEmailTemplateBodyFALSEBooleanChanges the Email Template to use plain text where otherwise text with the following symbols would not appear <text>.5.0.9690.2720N/A 
UseDeletePrivilegeInsteadOfAppendToForChildEntityDeleteFALSEBoolean<b>Use With Caution</b>:Use Delete privilege checks and AccessRights checks instead of AppendTo during Deletion of child entity. 
UseXAnchorMailboxInExchangeRequestHeaderFALSEBooleanOrg setting to add XAnchor mailbox to each request header to Exchange. 
VisibleRecordThreshholdSwitchToMultiplelineTVF250NumberUsed for activity rollup performance tuning along with: TotalRecordThreshholdSwitchToMultiplelineTVF and ActivityRollupChildRecordLimit.>N/A 
WorkflowXamlValidationErrorReportFALSEBooleanWorkflowXamlValidationErrorReport is used to fail workflow loads if the XAML is not valid. 
VerboseErrorsOnPromoteToCRM0IntEnables verbose user error messaging when tracking items from Outlook to Dynamics CRM. By default, some error messages during the tracking are suppressed from being shown to the end-user, and this setting enables those errors to be shown.5.0.9690.2165N/A 

5 1 vote
Article Rating
Notify of

Inline Feedbacks
View all comments
error: CRM Crate Security Engine - Disabled Right Click & Selection!


Well Done,
Welcome to CRM Crate

Stay tuned with us and get all latest updates and learning in Microsoft CRM and related techonologes.