Alerts and Notifications - Customizing Output Columns
Use the Please Specify Output Columns page to customize or 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 selection for the output column, the following are examples of what can appear in the alert criteria Filters section of the add alert wizard:
|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.|
Before You Begin
Create an alert rule. See Creating Alert Rules.
- In the alert rule wizard on the Please Specify Output Columns page, click Refresh to populate the output column table automatically.
- 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 checkbox.
- In the Primary Key column, select the checkbox.
- In the Column included in Alert column, select the checkbox.
See the preceding table for information on how these options affect the add alert wizard.
- 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.