Customize Email Alerts Example | Teradata Viewpoint - Example: Customizing Email Alerts - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide - 23.04

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Viewpoint
Teradata Workload Management
Release Number
23.04
Published
April 2023
Language
English (United States)
Last Update
2023-05-05
dita:mapPath
cxb1678987903668.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
Product Category
Analytical Ecosystem
Suppose you want to send an email message to dba@example.com with medium severity if the current perm space that is used in any database on Teradata system TEST1 exceeds 80%. On the system TEST1, finance is one of the databases you want to monitor.
  1. In the Alert Setup portlet, configure delivery settings.
    1. From the Setup Options list, select Delivery Settings.
    2. From the Delivery Types list, select Email.
    3. In the SMTP Host box, type smtp.example.com as the SMTP host address of the outgoing (SMTP) email server.
    4. Select the Enable email check box.
    5. From the Port list, select Use default port to use the default port 25.
    6. In the Server Timeout box, type a default of 30 seconds.
    7. Keep the default Anonymous login.
    8. In the Reply-To box, type doNotReply@example.com.
    9. Leave the Advanced Options box blank.
    10. In the Test Recipient box, type dba@example.com.
    11. Select Test to verify the SMTP server delivers the email.
    12. Click Apply.
  2. In the Alert Setup portlet, create an Action Set.
    1. From the Setup Options list, select Alert Presets.
    2. From the Preset Options list, select Action Sets.
    3. Select "" next to Action Sets.
    4. In the Action Set Name box, type CustomEmailAlert.
    5. Under Actions, make sure the Include in Alert Viewer check box is selected.
      This option is selected by default so you can view alerts for this action set in the Alert Viewer portlet.
    6. From the Actions list, select Email recipients.
    7. Select the Email recipients check box, click Bcc or To , and in the Email box, type dba@example.com.
    8. Click Apply.
  3. In the Monitored Systems portlet for Teradata Viewpoint monitoring, configure TEST1.
    1. Next to Systems, select "", then select Add Teradata System.
    2. In the System Nickname box, type TEST1.
    3. Select the Enable system check box to activate the TEST1 system for monitoring.
    4. In the TDPID box, type the TDPID of the TEST1 system.
    5. Enter a login name and password.
    6. Click Apply.
  4. In the Monitored Systems portlet, configure the data collectors.
    1. From the Systems list , select TEST1.
    2. From the Setup list, select Data Collectors.
    3. From the Data Collectors list, select Database Space.
    4. Select the Enable Database Space Collector check box and keep the default settings.
    5. Click Apply.
  5. In the Monitored Systems portlet, define alert rules.
    1. From the Systems list, select TEST1.
    2. From the Setup list, select Alerts.
    3. From the Alert Types list, select Database Space.
    4. Select "" next to Alerts.
    5. In the Alert Name box, type PermExceeds80.
    6. Select the Enable alert check box.
    7. In the Severity list, select Medium.
    8. From the Threshold list, select Current Perm.
    9. In the box to the right of the greater-than symbol (>), type 80.
    10. Select "", select the All databases except the selected databases below option and include all databases, and select OK.
    11. From the Action list, select CustomEmailAlert.
    12. Leave the value unchanged in the Do not run twice in ... minutes box.
    13. In the Message box, enter: The database ${databaseName} is more than 80% full.
    14. Click Apply.
    You can include alert properties in the Message box by enclosing the property name in curly brackets ({}) and preceding the expression with a dollar sign ($) as shown previously for the databaseName. See Teradata Alert Metrics and Properties for a description of the alert properties that are available for Teradata Viewpoint alerts.
  6. In the email inbox for the account dba@example.com, check for messages from doNotReply@example.com.

Example Email Message

The email message contains the following formatted information when it arrives in the inbox.

From: doNotReply@example.com
Sent: Tuesday, August 7, 2012 2:20 PM
To: dba@example.com
Subject: [Alert] permExceeds80 (System: TEST1, Database: finance)

The database finance is more than 80% full.

Event Timestamp: 2012-08-07T14:20:27.016-07:00

Database Name=finance
Space Used Percentage=85.0
Max Space Used Percentage=85.28

Description: (Space Used Percentage > 80.0)