18 Target Views

This chapter provides a description of each target view and its columns. It contains the following sections:

For examples of how to use views, see Chapter 20, "Examples".

18.1 MGMT$AGENTS_MONITORING_TARGETS

The MGMT$AGENTS_MONITORING_TARGETS view shows the available Management Agents for targets.

Table 18-1 MGMT$AGENTS_MONITORING_TARGETS

Column Description

TARGET_NAME

Name of the target

TARGET_TYPE

Type of the target

TARGET_GUID

Unique ID of the target

AGENT_NAME

Name of the Management Agent monitoring the target

AGENT_TYPE

Type of Management Agent

AGENT_GUID

Unique ID of the Management Agent

AGENT_IS_MASTER

Specifies whether the Management Agent is a master or slave.

Possible values:

  • 1: Master

  • 0: Slave

EMD_URL

URL of the emd monitoring the target

HOST_NAME

Host on which the target or Management Agent resides

MONITORING

Indicates how the target is monitored.

Possible values:

  • MGMT_GLOBAL.G_MON_MODE_DEFAULT: Single Management Agent, vanilla monitoring mode

  • MGMT_GLOBAL.G_MON_MODE_AGENT_MEDIATED: Multi Management Agent, agent-mediated monitoring

18.2 MGMT$EM_ECM_MOS_PROPERTIES

The MGMT$EM_ECM_MOS_PROPERTIES view exposes target information useful for My Oracle Support and Patching. It returns values from the EM_ECM_MOS_PROPERTIES table.

Table 18-2 MGMT$EM_ECM_MOS_PROPERTIES

Column Description

TARGET_GUID

The GUID of the target

HOST_TARGET_GUID

The GUID of the host that is hosting this target. The value is NULL for host targets.

ORACLE_HOME_TARGET_GUID

The GUID of the Oracle home target where this target is installed

PLATFORM_ID

The platform ID of the host that is hosting this target

PLATFORM_VERSION_ID

The platform version ID of the host that is hosting this target

18.3 MGMT$EM_ECM_TARGET_FRESHNESS

The MGMT$EM_ECM_TARGET_FRESHNESS view exposes the newest and oldest configuration snapshot information on a per target basis. It returns the collection timestamp and snapshot GUID for the most recently collected (newest) and least recently (oldest) collected snapshot for the target. If the target is a system, then the values will be valid across all snapshots of all member targets of the system.

Table 18-3 MGMT$EM_ECM_TARGET_FRESHNESS

Column Description

TARGET_GUID

The GUID of the target

NEWEST_SNAPSHOT_GUID

The snapshot GUID of the most recent collection

NEWEST_SNAPSHOT_TIMESTAMP

The date and time of the most recent collection

OLDEST_SNAPSHOT_GUID

The snapshot GUID of the oldest collection

OLDEST_SNAPSHOT_TIMESTAMP

The date and time of the oldest collection

18.4 MGMT$MANAGEABLE_ENTITIES

The MGMT$MANAGEABLE_ENTITIES view contains a list of all the Manageable Entities in Enterprise Manager.

Table 18-4 MGMT$MANAGEABLE_ENTITIES

Column Description

ENTITY_GUID

Unique ID corresponding to the Manageable Entity.

  • For systems, services, groups, and so on, this ID contains the TARGET_GUID

  • For target components, this ID contains the COMPONENT_GUID

ENTITY_TYPE

Type of the Manageable Entity.

  • For systems, services, groups, and so on, this column contains the target type

  • For target components, this column contains the component type

ENTITY_NAME

Name of the Manageable Entity.

  • For systems, services, groups, and so on, this column contains the entity name

  • For target components, this column contains the component name

PARENT_ME_GUID

Parent entity containing the target component. For non-target components, this column is equal to ENTITY_GUID.

PARENT_ME_TYPE

Type of the parent target. (Valid for target components only)

PARENT_ME_NAME

Name of the parent target. (Valid for target components only)

MANAGE_STATUS

Manage status of the entity.

Possible values:

  • 0: Ignored

  • 1: Not managed yet

  • 2: Managed

  • 3: Managed target component

PROMOTE_STATUS

Promote status of the target

  • 0: Cannot promote (existence only entity)

  • 1: Eligible for promotion

  • 2: Promotion in progress

  • 3: Promoted

DYNAMIC_PROPERTY_STATUS

Status of the dynamic properties

Possible values:

  • 0: Dynamic properties have not been uploaded by the Management Agent

  • 1: Dynamic properties are uploaded by the Management Agent

TYPE_META_VER

Metadata version number

CATEGORY_PROP_N

Up to five category properties can be used to distinguish different metric definitions based on different configurations.

For example, OS version, database version, Oracle RAC configuration, and so on.

TIMEZONE_REGION

Name of the time zone region that the target operates in.

Note: Component will be in same time zone as the target

DISPLAY_NAME

User-friendly name for the Manageable Entity

OWNER

Enterprise Manager administrator that owns the target

HOST_NAME

Host on which the target resides

EMD_URL

The URL for the EMD where the target is being collected

BROKEN_REASON

Code representing a reason why a target is broken

Possible values:

  • 0: Not broken

  • 1: Missing required properties

  • 2: Metadata not found

  • 4: Error computing dynamic properties

  • 8: Dynamic property missing in the result

  • 16: Target name not specified

  • 32: Target could not be saved

  • 64: Errors in target test metrics

BROKEN_STR

String associated with the broken reason

MONITORING_MODE

Indicates how the target is monitored.

Possible values:

  • G_MON_MODE_DEFAULT(0): Single Management Agent, vanilla monitoring mode

  • G_MON_MODE_OMS_MEDIATED(1): Multi Management Agent, OMS mediated monitoring

  • G_MON_MODE_AGENT_MEDIATED(2): Multi Management Agent, agent mediated monitoring

IS_PROPAGATING

Specifies whether the Manageable Entity is privilege propagating

DISCOVERED_NAME

Name with which the Manageable Entity was discovered

ORG_ID

Organization ID used by the Oracle Configuration Manager (OCM) Harvseter. This ID is used to uniquely identify customers.

Note: A large customer might have multiple organization IDs to represent different lines of business within the company.

ORACLE_HOME

Oracle home of the target

ORACLE_CONFIG_HOME

This value is used by the OCM collector and CCR to indicate targets that might share a single Oracle home but have their configuration state kept in separate directories

LOAD_TIMESTAMP

The date and time when the Manageable Entity record was first loaded (in the time zone of the Management Repository)