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
PropertyDescription
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.