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.