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

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil 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: Brazil  
Updated September 10, 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

The CMDB Query Builder properties enable ServiceNow customers to configure how queries are processed within the Configuration Management Database (CMDB).
These settings control query execution limits, performance parameters, and which query engine version to use, helping to optimize and tailor query behavior to organizational needs.
Show full answer Show less  

## Key Features

* **Result Limits:** Property `glide.cmdb.query.maxresultslimit` sets the maximum number of results returned for scheduled queries or when "Load All Results" is selected, defaulting to 10,000.
* **Query Time Limits:**
  * `glide.cmdb.query.batchtimelimitinsec`: Time limit (default 300 seconds) for processing each batch of 100 query results.
  * `glide.cmdb.query.querytimelimitinsec`: Total time limit (default 1800 seconds) to complete the entire query execution.
* **Table Exclusion:** Using `glide.cmdb.query.noncmdb.blacklistedtables`, administrators can specify non-CMDB tables to exclude from the Query Builder interface, with support for wildcards to filter multiple tables.
* **Batch Size Configuration:** The `glide.cmdb.query.batchsize` property controls the number of records processed per batch during saved query execution, with a default of 100.
* **Query Execution Engine Selection:**
  * `glide.cmdb.query.executionmode`: Defines the default query engine version (V1 legacy or V2 enhanced) for saved queries without a specified execution mode. The default is V2 for better performance and scalability.
  * `glide.cmdb.query.orexecutionmode`: Determines the engine used when queries include logical OR operators. This setting overrides the default execution mode and also affects the output format, defaulting to the V2 engine.

## Practical Application for ServiceNow Customers

By adjusting these properties, customers can:

* Control query performance and prevent long-running queries from impacting system resources.
* Limit the volume of results returned to manageable sizes for analysis and reporting.
* Exclude irrelevant or unsupported tables from query options to simplify user experience.
* Choose the most suitable query engine version, balancing legacy compatibility and improved scalability.

These configurations require the **sncmdbadmin** or **admin** role and can be managed through the System Properties \[sysproperties\] table by searching for `sysproperties.list`.  
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=brazil&pubname=brazil-platform-administration&ft:locale=en-US) table. * Learn more: [Batch size for CMDB Query Builder queries](https://www.servicenow.com/docs/5m_4BKoCzYbe2E2B6eYNrA#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/~o1xo~mThlZr~5gbvmVqmQ "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/~o1xo~mThlZr~5gbvmVqmQ "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