SQL Editor

The event group filter free-form SQL Editor allows an administrator to create a custom constraint using SQL syntax.

Perform the following steps to use the SQL Editor:

  1. In the Event Console Configuration view, expand Event Groups.
  2. Right-click the event group for which you are creating a filter using the SQL Editor and select Create Filter. The Add Event Group Filter dialog box is displayed. You may optionally select and edit an existing filter using the SQL Editor.
  3. From the Add Event Group Filter dialog box, click the Add SQL button. The Add SQL dialog box is displayed.
  4. Type the applicable SQL commands and click OK to return to the Add Event Group Filter dialog box.
  5. Click the Test SQL button to test the correctness of your SQL. A message is displayed indicating success or failure of the SQL commands.
  6. Click OK to close the message dialog box and return to the Add Event Group Filter dialog box.
  7. Click OK to save your changes.
Note:  You may show or hide SQL details by clicking the arrow key in the bottom pane of the dialog box.

See Also