4.3 Creating Views in the Operations Center console

You can create your own views in the Operations Center console that select data from a single table. This view only extracts data only one level deep (the element and the child immediately beneath it) in the Operations Center hierarchy.

The Operations Center console contains functionality for viewing and editing existing views, as well as creating, copying, editing, and deleting views.

The iSQL Viewer in the MOSDB utility only allows you to view the data in SQL Views. This utility is not intended for use with SQL Views.

The following sections cover creating and maintaining views:

4.3.1 Editing a View

  1. In the Operations Center console, expand Enterprise > Administration > SQL Views.

  2. Right-click the desired view, select Properties, then select View in the Properties dialog box.

    The View properties for an SQL view

  3. Edit the view as required.

4.3.2 Creating a New View

To create a new view, you have two options:

  • Copy an existing view and modify it.

  • Create a new view from scratch.

You cannot rename or modify system views, such as views that are named SYSTEM_. However, you can copy a system view and rename the copy.

Copying a View and Renaming It

  1. Right-click a view, then select Copy.

    The view is copied to the Clipboard.

  2. Right-click the SQL Views element, then select Paste.

    A copy of the view name is appended with _COPY and placed under the SQL Views element.

  3. Right-click the view, then select Rename to open the Rename dialog box.

  4. Specify the new name, then click OK.

    The renamed view displays in the Explorer pane.

Creating a New View from Scratch

  1. In the Explorer pane, right-click SQL Views, then select Create View:

  2. Fill in the fields:

    Table: Select the database table to query.

    Element: (Required) Click Browse to open the Browse for Element dialog box, then select the element (and its children) where the view applies.

    Constraints: Select the Enabled check box next to data that should determine data relevance. For example, a specific alarm type (Alarms, Breaches) or time category can affect data query selection. The list of constraints depends on the selected table. For more information, see Section 4.1, Using Tables.

  3. Click Create.

    A message displays in the Status box stating that the view was successfully created. The new view displays under SQL Views in the Operations Center hierarchy.

4.3.3 Deleting Views

You can only delete views that you create. You cannot delete system views, whose names begin with SYSTEM_; these views ship with Operations Center. If you delete a view that is referenced by a report, then the report no longer works.

Deleting a View

  1. Right-click a view, then select Delete View to display a confirmation dialog box.

  2. Click Yes to delete the view.

Deleting Multiple Views

  1. Right-click the SQL Views element, then select Manage Views to open the Manage Views dialog box.

  2. Use Shift+click or Ctrl+click to select multiple views.

  3. Click Delete to delete the views.

    A message displays in the Status dialog box saying that the views were successfully deleted.