Alerts and Notifications - Creating an Alert Rule

Before You Begin

  • To see the Alert Rule button, users must have Administrative Management capabilities at the CommCell level. For information on assigning capabilities to a user, see Assigning Capabilities to a User Group.
  • Obtain or write the query to use in the alert rule:

    Only SQL databases located on the CommServe computer can be queried.


  1. From the CommCell Console ribbon, click the Home tab and then click Alert.
  2. In the Alerts dialog box, click Alert Rule.
  3. In the Alert Rules dialog box, click Add.

    The Create New Alert Rule dialog box appears.

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

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

  6. In the Description box, type the purpose of the rule.
  7. Click Next.
  8. 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.
  9. Optional: Use the Manage Inputs button to add a user input field. See Managing Inputs.
  10. Optional: Use the Insert Variable button to add a variable to the query:
    1. Click in the SQL Query box to place the cursor where you want to insert the variable.
    2. 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.

    3. Select the variable and click OK.

      The variable is inserted prefixed with an at sign (@), for example, @userName.

  11. Click Next.
  12. On the Please Specify Output Columns page, click Refresh to populate the output column table automatically.
  13. 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.
  14. Click Next.
  15. On the How Often to Run This Query page, select the options for the schedule and click Next.
  16. On the Security Details page, select Private to make the alert rule only visible to you, or select Public to select user groups who can view the alert rule.

    The Private setting does not affect the add new alert wizard. Once the custom alert rule is created, users can see it in the add new alert wizard.

  17. Click Finish to create the rule.

    You can now create an alert based on this rule.

Related Tasks

Creating Alerts Using Alert Rules

Editing an Alert Rule

Related Topics

Sample Alert Rules