Use the Query Builder

The Query Builder lets you select a single reporting view and allows you to choose the columns to be included in the query for a single view. You can also define filters to include only the rows you want in the results.

  1. On the Object tab of the Query Data block, click the Query Builder button.

  1. Select a view (from the SysTrack SQL database Available Views list.
  2. Check the columns you want to include in the query and the number of rows to return.

NOTE: It is recommended that you avoid large queries and limit the maximum number of rows to be returned. Clearing the number of rows to be set results in a limit of 10,000 being applied by the system.

  1. Click the Next button. The Add Filters pane displays.

Defining Filters

To restrict the data to include only the rows you want in the results, use the Add Filters pane. For example,you may want to get only the records in which the%TotalCPU is greater than or equal to 50.

  1. To define a filter, click the Add Test button.
  2. Select a data column from the left drop-down menu.
  3. Select a condition from the middle drop-down menu.
  4. Select either fixed value, or variable named from the right drop-down menu. If you selected variable named, enter a variable in the <enter variable> field. If you selected a fixed value,enter a comparison value.
  5. Click the See Sample Results button to see the results.

NOTE: The sample results are limited by the system to the top 100 rows.

  1. You can add additional Tests or Groups (using the Add Group button) to further refine your filter.
  1. If you wish to delete a test or group, select the appropriate test or group, and click the Delete Selected button.
  1. Click Done when complete. The SQL query is placed in the Query field. The Query Builder creates a SELECT statement, while using filters will create a WHERE clause. The Query defined by Query Builder option is checked, and the query text is not editable.
  2. If you wish to edit this query and filters, click the Query Builder button again.
  3. To change the query manually (outside of the Query Builder), deselect the Query defined by Query Builder option.

NOTE: If you deselect the "Query defined by Query Builder" option you will no longer be able to make changes to that query using the Query Builder.