4.2 Using System Views

SQL Views ships with some predefined views, called system views. System views extract data only one level deep (the element and the child immediately beneath it) in the Operations Center hierarchy.

These views can not be modified, but they can be used to create new views. Each view has the following components:

  • Table: The database table accessed by the view.

  • Element: The element (and its children) where the view applies.

  • Constraints: The data in the table that determines data relevance. For example, a specific alarm type (Alarms, Breaches) or time category constraint can affect data query selection. The list of constraints depends on the selected table.

All system views start with SYSTEM_. The default values for each system view are listed in Table 4-16.

Table 4-16 System Views

View Name

Element

Table

Constraint Name

Constraint Value

ELEMENTS_ALARMS

Alarms

Alarms

Alarm Type Report Time Period

Alarms

None

ELEMENTS_ELEMENTS

Elements

Elements

Depth

1

ELEMENTS_PROPERTIES

Elements

Properties

Depth

1

ELEMENTS_RELATIONSHIPS

Elements

Relationships

Depth

1

ENTERPRISE_ELEMENTS

Enterprise

Elements

Depth

1

ENTERPRISE_PROPERTIES

Enterprise

Properties

Depth

1

ENTERPRISE_RELATIONSHIPS

Enterprise

Relationships

Depth

1

SERVICEMODELS_ALARMS

Service Models

Alarms

Alarm Type

Report Time Period

Alarms None

SERVICEMODELS_ELEMENTS

Service Models

Elements

Depth

1

SERVICEMODELS_PROPERTIES

Service Models

Properties

Depth

1

SERVICEMODELS_RELATIONSHIPS

Service Models

Relationships

Depth

1

SERVICEMODELS_SLAS

Service Models

Agreement

Depth

1

To manage these views:

  1. In the Explorer pane of the Operations Center console, expand Administration > SQL Views.

  2. To edit the properties of an existing view, right-click the name of the view, then select Properties.

  3. On the Properties page, select View.