Property settings for CMDB Query Builder

  • リリースバージョン: Australia
  • 更新日 2026年03月12日
  • 所要時間：5分

    • Set property values to configure query processing.

    Access and Role required

    The sn_cmdb_admin or the admin role is required to view and edit Query Builder properties.
    注:
    To open the System Properties [sys_properties] table, enter sys_properties.list in the navigation filter.
    表 : 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 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.
    • Default value: V2
    • Location: System Properties [sys_properties] table.
    • Learn more:
    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.
    • Default value: V2
    • Location: System Properties [sys_properties] table.
    • Learn more: