Property settings for CMDB Query Builder

  • Release version: Zurich
  • Updated July 31, 2025
  • 1 minute to read

    • Set property values to configure query processing.

    Access and Role required

    The admin role is required to view and edit Query Builder properties.
    Note:
    To open the System Properties [sys_properties] table, enter sys_properties.list in the navigation filter.
    Table 1. Properties for CMDB Query Builder
    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: Configuration > CMDB Properties > Query Builder Properties
    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: Configuration > CMDB Properties > Query Builder Properties
    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: Configuration > CMDB Properties > Query Builder Properties
    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: Configuration > CMDB Properties > Query Builder Properties
    glide.cmdb.query.batch_size

    Batch size allocated globally when saved queries run.
    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 the glide.cmdb.query.or_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.
    • Default value: v2
    • Location: System Properties [sys_properties] table.
    • Learn more: Set execution mode for running a query
    glide.cmdb.query.or_execution_mode

    Default execution engine to use, applying only to queries that contain at least one logical OR condition. Used in combination of 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.
    • Default value: v2
    • Location: System Properties [sys_properties] table.
    • Learn more: Set execution mode for running a query