Setting Classification for Query Sessions - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 24.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
24.04
Published
April 2024
Language
English (United States)
Last Update
2024-04-29
dita:mapPath
xwb1711972215358.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
xvu1467243446040
Product Category
Analytical Ecosystem
Add classification settings to existing query sessions or when creating a query session. Classification determines which sessions are associated with the query session.

Enabling the Dictionary data collector in the Monitored Systems portlet makes sure the lists of usernames in the Classification tab is current. If the collector is not enabled, you can enter usernames manually by entering a match string and clicking Include.

  1. Edit or create a ruleset.
  2. From the ruleset toolbar, click Sessions.
  3. Click the Query Sessions tab.
  4. Select a query session or create one.
  5. Click the Classification tab.
  6. Click Add Criteria.
  7. From the Source Type list, select one of the following:
    Option Description
    Username Teradata system username
    Account Name Teradata system account name
    Account String Teradata system account identification string
    Profile Teradata system profile name
    Application Application on the network client
    Client IP Address
    [SQLE 17.20.00.00 and Higher] Select the Use actual client IP address check-box to use the actual client IP address instead of the network address.
    IP address of the network client
    Client ID Login name on the network client
  8. Do at least one of the following:
    • Enter a match string and use the Include and Exclude buttons to add the match string. A match string can contain ? to match exactly one character or * to match zero or more characters.
    • Select items from the list and use the Include and Exclude buttons to create your classification criteria. If there are more than 500 items, use the filter box to locate the items you want to select.
  9. Click OK.
  10. [Optional] To add additional classification criteria:
    1. Click Add Criteria.
    2. Select the Source Type.
    3. Select the items you want to include.
    4. Click OK.
    If you set both Username and Profile as request sources, you can choose AND or OR logic. If you set any other request source type combination, the additional criteria are evaluated using AND logic.