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:
In the Explorer pane of the Operations Center console, expand Administration > SQL Views.
To edit the properties of an existing view, right-click the name of the view, then select Properties.
On the Properties page, select View.