Property settings for CMDB Query Builder

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. Type: integer Default value: 100 Location: Add to System Properties [sys_properties] table.