Properties for CMDB Query Builder

Use the CMDB Query Builder properties to configure query processing.

These properties are available for CMDB Query Builder. To view and edit these properties, the admin role is required.

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 click 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 that shouldn’t appear in the CMDB Query Builder when creating a CMDB 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.