Example: Customizing Email Alerts - 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
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 Database 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, click Delivery Settings.
    2. From the Delivery Types list, click 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. Click Test to verify that 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, click Alert Presets.
    2. From the Preset Options list, click Action Sets.
    3. Click 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 , click TEST1.
    2. From the Setup list, click Data Collectors.
    3. From the Data Collectors list, click 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, click TEST1.
    2. From the Setup list, click Alerts.
    3. From the Alert Types list, click Database Space.
    4. Click 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. Click , select the All databases except the selected databases below option and include all databases, and click 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 above for the databaseName. See Teradata Database 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)