Query Settings

Access the Query Settings Page

About This Task

From the Query Settings page, you can set the query timeouts, purge the saved exports, or modify the filtering options in result grid. To access the Query Settings page, complete the following steps:

Procedure

In the Applications menu, navigate to ADMIN > Operations Manager > Query Settings.
The Query Settings page appears.

About Query Timeouts

Using Query Timeouts, you can specify the query time-out limit. The query time-out limit is the amount of time in seconds that the APM system will allow a new or modified query to attempt to return results before timing out.

This setting allows you to control the performance of the queries in your system by enforcing a requirement that they meet a specific performance goal. This setting is used in the query design when a Security User whose query privilege setting is Restricted By Timeout Limit tries to save a new or modified query.

Before a Security User whose query privilege is Restricted By Timeout Limit can save a new or modified query, they will have to run the query so that the APM system can determine if it runs within the time-out limit. Otherwise, the save options will remain disabled. If a query time-out limit has been specified in that database, when the query runs, the APM system will allow the query to run until the specified query time-out limit has been met. After the time-out limit is reached:
  • If the query has not returned results, a message will appear, indicating that the query cannot be saved, and the save options will remain disabled.
  • If the query has returned results, the save options will be enabled, and the Security User can save the query.

Specify the Limit for Query Timeout

About This Task

The following instructions provide details on specifying the query time-out limit for Security Users who are restricted by query time-outs. These instructions do not provide a recommendation on choosing the time-out value itself. The value that you choose should match the amount of time that your organization has defined as a reasonable amount of time for a query to run before returning results. The value you enter must be a whole number (i.e., not a decimal value).

Procedure

  1. Access the Query Timeout Limits page.
  2. In the Query Timeout Limit (in minutes) for Restricted Users box, enter the number that represents amount of time to which you want to limit query runs.
  3. Select .
    A confirmation message appears, indicating that the query timeout is created.

About Purging Saved Exports

There is a scheduled job to purge old background exported queries. You can configure the day this job runs and for how many days to keep the query exports on the Query Settings page.

Set Purge Export Frequency

Procedure

  1. In the Applications menu, navigate to ADMIN > Operations Manager > Query Settings.
    The Query Settings page appears.
  2. In the Day of week to run export purge box, enter the day you want to run the scheduled job. It can be set to any day of the week and runs at midnight UTC on that day. By default, it is set to Sunday.
  3. In the Number of days to keep query exports box, enter the number of days that you want to keep the query exports. Keeping this number low uses less database disk space and keep the scheduled job from consuming too many resources. By default, it is set to 90 days.

About Case Insensitive Filtering

Filtering in result grid is case sensitive. Case-insensitive filtering can be enabled using the Filter Result Grid Case Insensitive setting. This feature only affects the filtering in result grid.

Set Case Insensitive Filtering

Procedure

  1. In the Applications menu, navigate to ADMIN > Operations Manager > Query Settings.
    The Query Settings page appears.
  2. Select the Filter Result Grid Case Insensitive check box.