Intune Settings Catalog ViewerIntune Settings
Browse
OIB Lookup
LookupChangelog
MS Baselines
LookupChangelog
ComplianceChangelogMCPAbout

Data sourced from Microsoft Graph API. Not affiliated with Microsoft. By Lewis Barry | Enhanced by Roy Klooster.

Try rmmguard.com · Last updated: November 13, 2026

HomeMicrosoft Office 2016Business DataSynchronizationSet query items limit (User)

Set query items limit (User)

Windows

Category: Synchronization

WindowsMDM

Description

This policy setting allows you to specify the maximum number of items that will be added to the client’s cache as the result of executing a query. Several bulk operations (especially queries) can return a large number of items to be added to the cache. This increases the size of the cache, potentially exceeding the 4GB limit imposed by Microsoft SQL Server CE. It also increases the amount of work required to keep the cache synchronized and increases the load on the LOB server. In order to protect the system, a limit is used – any results processed before reaching the limit are still committed, but the operation is marked as failed and will be retried later. If you enable this policy setting, you may specify the maximum number of items that will be added to the client’s cache as the result of executing a query. If you disable or do not configure this policy setting, a default value of 2000 items will be used.

Options (2)

Disabled(default)
Enabled
./User/Vendor/MSFT/Policy/Config/office16v2~Policy~L_MicrosoftOfficeSystem~L_BusinessData~L_Synchronization/L_QueryInstancesLimit

Child Settings (1)

Query instances limit (User)