Loading...

Alerts and Notifications - Customizing Output Columns

Use the Please Specify Output Columns page to customize or to add query output columns for an alert rule. The options on the Please Specify Output Columns page affect what users see when they use the alert rule to create an alert:

Output Column Option

Effect on the Add Alert Wizard

Data Type

If Filter Support is selected, the value selected for the Data Type column changes the filter values available to users in the alert criteria Filters section of the add alert wizard. Users select filters to limit the alert criteria to specific entities or conditions.

If a CommServe data type is selected, a hierarchical list of entities is available to users in the alert criteria Filters section of the add alert wizard. Because the relationship between the CommServe data types is hierarchical, selecting a lower level data type, such as Subclient, requires including the data types above it. For example, if Application Type is selected as the data type of a column, Client must be selected as the data type of another column.

CommServe data types: Client Group, Client, Application Type, Instance, Backup Set, and Subclient.

Based on the output column data type, the following are examples of what can appear in the alert criteria Filters section of the add alert wizard:

  • If an output column is marked as "Boolean," the filter value is equals to.
  • If an output column is marked as "String," the filter values are contains, does not contain, equals to, and does not equal to.
  • If an output column is marked as "Client Group" (a CommServe data type), the filter values include a list of the client groups available in the CommCell Console.

Filter Support

Select to use the column as a filtering option in the alert criteria Filters section of the add alert wizard. If Filter Support is selected, the value in the Data Type column affects what users see in the alert criteria Filters section of the add alert wizard.

Primary Key

Select to use the column to uniquely identify a database row. A primary key column is needed if the alert rule monitors when a condition happens or when a condition clears. For example, the Backup Exceeds X GB alert rule uses the jobID column as the primary key.

Column included in Alert

Select to include the column in the alert notification, for example, to include the column in the body of an email alert or in the alert details of a console alert.

Alert Recipient

Select to define the email address for the alert notification. If the alert notification recipient is defined in the alert rule, you cannot select additional users on the Notification Type(s) Selection page.

Before You Begin

Create an alert rule. See Creating Alert Rules.

Procedure

  1. In the alert rule wizard on the Please Specify Output Columns page, click Refresh to populate the output column table automatically.
  2. Optional: For each row in the table, do one or more of the following:
    • In the Data Type column, select a data type from the list.
    • In the Filter Support column, select the check box.
    • In the Primary Key column, select the check box.
    • In the Column included in Alert column, select the check box.
    • In the Alert Recipient column, select the check box.

    See the preceding table for information on how these options affect the add alert wizard.

  3. Do one of the following:
    • To move to the next page in the wizard, click Next.
    • To move to save your changes and leave the wizard, click Finish.

Related Tasks

Creating an Alert Rule

Editing an Alert Rule

Last modified: 2/27/2018 9:47:01 PM