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. 
- 
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.