You can create an alert rule to monitor events in the CommCell environment.
Before You Begin
-
To see the Alert Rule button in the Alerts dialog box, users must have a security association that includes the Administrative Management permission at the CommServe level. For information on security associations, see Security Association Overview.
-
Obtain or write the query to use in the alert rule:
Note: Only SQL databases located on the CommServe computer can be queried.
-
Write your own query.
-
Use CommCell Views as the basis for the query. For information see CommCell Views.
-
Install an alert rule using the Commvault Store. For information see Installing Alert Rules from Commvault Store.
-
Use one of the predefined alert rules provided in the Alert Rules dialog box. For information see Custom Rules.
-
Procedure
-
From the CommCell Console ribbon, click the Home tab and then click Alert.
-
In the Alerts dialog box, click Alert Rule.
-
In the Alert Rules dialog box, click Add.
The Create New Alert Rule dialog box appears.
-
On the General Information page in the Alert Rule Name box, type a name for the alert rule.
This is the name used when this alert rule appears in the add alert wizard.
-
In the Severity list, select Critical, Warning, or Information.
This is the default severity used when this alert rule appears in the add alert wizard.
-
In the Description box, type the purpose of the rule.
-
Click Next.
-
On the Please Specify SQL File Location or Enter SQL Query page in the SQL Query box, do one of the following:
-
Type the SQL query.
-
Click Import from File to import a script or text file containing the query.
If you select Query returns formatted HTML check box, then the alert notification template will only display <QUERY GENERATED HTML> token.
-
-
Optional: Use the Manage Inputs button to add a user input field. See Managing Inputs.
-
Optional: Use the Insert Variable button to add a variable to the query:
-
Click in the SQL Query box to place the cursor where you want to insert the variable.
-
Click Insert Variable.
System variables, such as userName, and any inputs created using the Manage Inputs button are available in the Insert Variable dialog box.
-
Select the variable and click OK.
The variable is inserted prefixed with an at sign (@), for example, @userName.
-
-
Click Next.
-
On the Please Specify Output Columns page, click Refresh to populate the output column table automatically.
-
Optional: Customize or add query output columns to change what users see when they use the alert rule to create an alert. See Customizing Output Columns.
-
Click Next.
-
On the How Often to Run This Query page, select the options for the schedule and click Next.
-
On the Monitor CommCells page, do one of the following:
-
Select the CommCells to monitor.
-
Select Allow CommCell association at alert level to allow users to select the CommCells associated with the alert when the alert rule is used in the Alert Wizard.
-
-
Click Next.
-
On the Security Details page, select Add to select which users can use the custom alert rule to create an alert in the Alert Wizard.
-
Click Finish to create the rule.
You can now create an alert based on this rule.