---
sourceDocument: Australia ServiceNow AI Platform Capabilities
sourceDocumentLink: https://www.servicenow.com/docs/r/australia/servicenow-platform

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia ServiceNow AI Platform Capabilities

ft:clusterId :

    - platcap

bundleId :

    - platcap

workflow :

    - Platform


---

# Property settings for CMDB Query Builder

# Property settings for CMDB Query Builder {#ariaid-title1}

Release version: Australia  
Updated March 12, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read
Summarize  
![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI  
This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.  

## Summary of Property settings for CMDB Query Builder

These properties allow ServiceNow administrators withsncmdbadminoradminroles to configure the behavior and performance of the CMDB Query Builder.
Settings control query result limits, execution timeouts, batch sizes, table exclusions, and query execution modes.
Adjusting these properties helps optimize query processing, improve scalability, and tailor the query environment to organizational needs.
Show full answer Show less  

## Key Properties and Their Practical Use

* **Maximum Results Limit (glide.cmdb.query.maxresultslimit)**: Caps the number of records returned in scheduled queries and when loading all results in the Query Builder. Default is 10,000, helping manage system load and avoid excessive data retrieval.
* **Batch Time Limit (glide.cmdb.query.batchtimelimitinsec)**: Defines the maximum time (in seconds) allowed to process one batch of 100 query results. Default is 300 seconds, balancing query responsiveness with workload.
* **Overall Query Time Limit (glide.cmdb.query.querytimelimitinsec)**: Sets the total time limit for completing an entire query. Default is 1800 seconds, preventing excessively long-running queries.
* **Non-CMDB Table Exclusions (glide.cmdb.query.noncmdb.blacklistedtables)**: Enables exclusion of specified non-CMDB tables from appearing in the Query Builder. Supports comma-separated lists and wildcard patterns, allowing cleaner query building focused on relevant tables.
* **Batch Size (glide.cmdb.query.batchsize)**: Controls the number of records processed per batch when saved queries run. Default value is 100, helping regulate resource usage during query execution.
* **Default Execution Mode (glide.cmdb.query.executionmode)** : Specifies which query engine to use when running saved queries without a defined execution mode. Options include **V1** (legacy engine) and **V2** (enhanced engine optimized for performance and scalability). Default is V2.
* **OR Execution Mode (glide.cmdb.query.orexecutionmode)**: Determines the execution engine for queries containing logical OR operators. It takes precedence over the default execution mode and affects output format. Options are the same as above, with V2 as the default.

## Key Outcomes for ServiceNow Customers

* Fine-tune query performance and system resource consumption by adjusting result limits, timeouts, and batch sizes.
* Enhance query relevance and usability by excluding non-essential tables from the Query Builder interface.
* Leverage improved query engines to handle complex queries efficiently, especially those with logical OR conditions.
* Maintain control over query execution behavior to prevent long-running queries that could impact platform performance.
* Ensure a better user experience for CMDB administrators by customizing query settings to fit organizational scale and complexity.  
Set property values to configure query processing.

## Access and Role required {#cmdb-querybldr-sysproprties__section_gwn_2tz_mhb}

The sn_cmdb_admin or the admin role is required to view and edit Query Builder properties.  
Note:  
To open the System Properties \[sys_properties\] table, enter <kbd class="ph userinput">sys_properties.list</kbd> in the navigation filter.
{#cmdb-querybldr-sysproprties__table_y4d_htz_mhb__entry__2}

| Property | Description |
|-|-|
| Limits the number of results for a scheduled query and in the results section in the Query Builder when you select Load All Results. glide.cmdb.query.max_results_limit | * Type: integer * Default value: 10000 * Location: ConfigurationCMDB PropertiesQuery Builder Properties {#cmdb-querybldr-sysproprties__ul_z4d_htz_mhb} |
| Time limit (in seconds) for running one batch to get one batch of query results (100 results). glide.cmdb.query.batch_time_limit_in_sec | * Type: integer * Default value: 300 * Location: ConfigurationCMDB PropertiesQuery Builder Properties {#cmdb-querybldr-sysproprties__ul_apd_htz_mhb} |
| Time limit (in seconds) for running an entire query to get all results. glide.cmdb.query.query_time_limit_in_sec | * Type: integer * Default value: 1800 * Location: ConfigurationCMDB PropertiesQuery Builder Properties {#cmdb-querybldr-sysproprties__ul_bpd_htz_mhb} |
| Exclude list of non-CMDB tables. The specified tables will not appear in the CMDB Query Builder when a user creates a query. glide.cmdb.query.non_cmdb.black_listed_tables | * Type: string * Default value: empty * Other values: Comma-separated list of table names (not labels). Can include '\*abc' to exclude all tables containing 'abc' in their table name. * Location: ConfigurationCMDB PropertiesQuery Builder Properties {#cmdb-querybldr-sysproprties__ul_cpd_htz_mhb} |
| glide.cmdb.query.batch_size | Batch size allocated globally when saved queries run. * Type: integer * Default value: 100 * Location: [Add to System Properties \[sys_properties\]](https://www.servicenow.com/docs/access?context=t_AddAPropertyUsingSysPropsList&version=australia&pubname=australia-platform-administration&ft:locale=en-US) table. * Learn more: [Batch size for CMDB Query Builder queries](https://www.servicenow.com/docs/nFyXaQTwAi0KjTrqPMpQ6Q#batch-size-query "In a base system, a global batch size of 100 is allocated for every Query Builder query run. If needed, you can use a system property to override the default global batch size, or optimize the batch size value per saved query.") {#cmdb-querybldr-sysproprties__ul_o3d_tpv_3nb} |
| glide.cmdb.query.execution_mode | Default execution engine to use when running a saved query when the query's execution mode isn't set (Query Execution Mode is 'None'). Used in combination with other settings to determine which engine execution mode to use for running a query. * Type: string * Values: * V1: Use the legacy query execution engine. * V2: Use an enhanced query execution engine which is designed for improved performance and scalability. {#cmdb-querybldr-sysproprties__ul_wny_mkv_lgc} * Default value: V2 * Location: System Properties \[sys_properties\] table. * Learn more: [Set execution mode for running a query](https://www.servicenow.com/docs/YLq2VKDynCD4l3wOPkjpYA "Configure the execution mode to use when running a query, at the query-level. The execution mode determines whether the query runs using a performance-enhancing engine (V2) or the legacy engine (V1).") {#cmdb-querybldr-sysproprties__ul_fk5_f5p_lgc} |
| glide.cmdb.query.or_execution_mode | Default execution engine to use for queries that contain at least one logical OR operator. This property also affects which output format to use, which is distinctively different between the V1 and V2 modes. This property is used in combination with other settings to determine which engine execution mode to use for running a query, and has precedence over the glide.cmdb.query.execution_mode system property. * Type: string * Values: * V1: Use the legacy query execution engine. * V2: Use an enhanced query execution engine which is designed for improved performance and scalability. {#cmdb-querybldr-sysproprties__ul_hp4_fp1_nhc} * Default value: V2 * Location: System Properties \[sys_properties\] table. * Learn more: [Set execution mode for running a query](https://www.servicenow.com/docs/YLq2VKDynCD4l3wOPkjpYA "Configure the execution mode to use when running a query, at the query-level. The execution mode determines whether the query runs using a performance-enhancing engine (V2) or the legacy engine (V1).") {#cmdb-querybldr-sysproprties__ul_gp4_fp1_nhc} |
[Table 1. Properties for CMDB Query Builder]

{#cmdb-querybldr-sysproprties__table_y4d_htz_mhb}

*[\>]: and then