Creating a Query Group - Teradata Workload Management - 16.20

Teradata® Viewpoint User Guide

prodname
Teradata Viewpoint
Teradata Workload Management
vrm_release
16.20
category
User Guide
featnum
B035-2206-107K
Create a query group in the Query Group Setup portlet to allow users to view their most relevant queries in the Query Groups. You create a query group to filter the queries that are displayed and limit the users that have access to the group.

Enabling the Dictionary data collector in the Monitored Systems portlet makes sure the lists of usernames in the Access tab is current.

  1. Select a system from the Systems list. A system cannot be changed after you create a query group.
  2. Click the Add Group button.
  3. Enter a Query group name, up to 30 characters.
  4. [Optional] Enter a Description, up to 256 characters.
  5. For the This group contains queries with attributes that match at least one value in field on the Criteria tab, do one of the following:
    • Select Every criteria below to match at least one value in each defined sub-tab. Criteria on each sub-tab are joined by AND.
    • Select Any criteria below to match at least one value in one or more of the defined sub-tabs. Criteria on each sub-tab are joined by OR.


  6. Select a criterion from the Add Criteria list.
  7. Select values for whichever criteria you chose:
    Criteria Select values by doing any of the following:

    Account String

    Username

    Workload Name

    • In the Match string box, enter a value to reduce the number of available values.
    • Select a value from the Available box and click to move it to the Selected box.
    • In the Match string box, enter a value to create custom criteria, and click to move it to the Selected box. The value can contain ? to match exactly one character in the position it occupies, * to match zero or more characters, or = at the beginning of the string to match alpha and numeric characters literally.
    Query Band
    • Select a Query band name from the list and a value from the Available Values box, and click to move them to the Selected box.
    • Enter a Custom Query band name and value pair, and then click to move them to the Selected box.
  8. In the Access tab, designate the users who can view the group by doing any of the following:
    • In the User List Filter box, enter a value to reduce the list of available users. The value can contain ? to match exactly one character in the position it occupies, * to match zero or more characters, or = at the beginning of the string to match alpha and numeric characters literally.
    • In the Available Users box, select one or more Viewpoint users and click to move them to the Selected Users box.
    • In the Available Roles box, select one or more Viewpoint roles and click to move them to the Selected Roles box.
  9. [Optional] Click Reset to clear the query group name, description, and the selections on the Criteria and Access tabs.
  10. Click Apply.