H
Repository Views Addendum

This appendix documents the repository views that were documented incorrectly or not included in the Oracle Enterprise Manager Administrator's Guide.

Operational System Metrics

SMP_VIEW_RUNNING_OMS_MACHINES

Shows all Management Servers currently connected to a repository. All Management Servers in this region must be up and running in order to be displayed in this view.

Columns	Descriptions
OMS_MACHINE	Name of the machine, as it is known in the network. This name is the canonical name of the Management Server machine, as it was resolved by the network protocols.
REGION	Name of the region.
LAST_CHECKED	Timestamp of the last heartbeat of this Management Server, using the timezone of the Management Server machine.

SMP_VIEW_REGIONS

Lists all regions along with pertinent information for each region such as attached Management Servers and Intelligent Agents.

Columns	Descriptions
REGION_NAME	Name of the region.
OMS_MACHINE	Name of the machine
NODE_NAME	Name of the agent.
UPDOWN	Current status of the agent.
LAST_CHECKED	Timestamp of the last heartbeat of this Management Server using the timezone of the machine on which it runs.

Job Definition Views

SMP_VIEW_JOB_NOTIFICATIONS

List of all administrators who will get notified when particular jobs are executed.

Columns	Descriptions
JOB_ID	The JOB_ID is an unique identifier for this job. Since a job can be submitted at different times, and because the same job can be created more than once, the job_name is not enough to uniquely identify an job in the repository. Therefore, all queries used to obtain job information must use the JOB_ID identifier.
JOB_NAME	Name of this job. JOB_NAME contains the name of the job as entered by the administrator.
ADMINISTRATOR_NAME	Name of the administrator who will get notified
TARGET_NAME	Name of the service that caused the job to trigger
TARGET_TYPE	Type of target this job is meant for.

Event Definition Views

SMP_VIEW_EVENT_NOTIFICATIONS

List of all administrators who will get notified for specific events.

Columns	Descriptions
EVENT_ID	Unique identifier for an event. Since an event can be registered and de-registered at different times, and because the same event can be registered against more than one target, the EVENT_NAME is not enough to uniquely identify an event in the repository. Therefore, all queries used to obtain event information must use the EVENT_ID identifier.
EVENT_NAME	Name of this event
ADMINISTRATOR_NAME	Name of the administrator who will get notified
TARGET_NAME	Name of the service that caused the event to trigger
TARGET_TYPE	Type of target this event is meant for