18 Using Management Repository Views

CM_TARGET_GUID

The unique global identifier (GUID) for the target

CM_TARGET_TYPE

The type of target: j2ee_application

CM_TARGET_NAME

The name of the target in Enterprise Manager

LAST_COLLECTION_TIMESTAMP

The date and time when the metrics were collected

ECM_SNAPSHOT_ID

GUID of the snapshot

PATH

The fully resolved location of the application source files on the administration server

LOADORDER

A number value that indicates when the unit is deployed, relative to other DeployableUnits on a server, during startup

TYPE

Type of the module. The string value must match those defined by JSR 88: Java EE Application Deployment such as EAR or WAR.

CM_TARGET_GUID

The unique global identifier (GUID) for the target

CM_TARGET_TYPE

The type of target: j2ee_application

CM_TARGET_NAME

The name of the target in Enterprise Manager

LAST_COLLECTION_TIMESTAMP

The date and time when the metrics were collected

ECM_SNAPSHOT_ID

GUID of the snapshot

NAME

Name of the EJB component

DEPLOYMENTORDER

Priority that the server uses when it deploys an item. The priority is relative to the other deployable items of same type.

KEEPGENERATED

Indicates whether KeepGenerated is enabled and whether EJB source files will be kept. Values: true, false.

CM_TARGET_GUID

The unique global identifier (GUID) for the target

CM_TARGET_TYPE

The type of target: j2ee_application

CM_TARGET_NAME

The name of the target in Enterprise Manager

LAST_COLLECTION_TIMESTAMP

The date and time when the metrics were collected

ECM_SNAPSHOT_ID

GUID of the snapshot

SERVICENAME

Name of JRF web service

WEBMODULE

Name of web module that contains the JRF web service

JRFWEBSERVICEKEY

Key column computed as WebModuleName_WebServiceName where WebModuleName is the name of web module that contains the JRF web service and WebServiceName is the name of the JRF web service

DATABINDING

Data binding technology used by the web service port

EXPOSEWSDL

Specifies if the web service definition language (WSDL) is exposed for the service. Values: true, false.

METADATAEXCHANGE

Usage of WS-MetadataExchange for WSDL advertisement. Values: true, false

EXPOSETESTPAGE

Specifies whether the test page is exposed for the service. Values: true, false

CM_TARGET_GUID

The unique global identifier (GUID) for the target

CM_TARGET_TYPE

The type of target: j2ee_application

CM_TARGET_NAME

The name of the target in Enterprise Manager

LAST_COLLECTION_TIMESTAMP

The date and time when the metrics were collected

ECM_SNAPSHOT_ID

GUID of the snapshot

SERVICENAME

Name of the JRF web service

WEBMODULE

Name of the web module that contains the JRF web service

PORTNAME

Name of the JRF web service port

OPERATIONNAME

Name of the JRF web service port operation

SOAPACTION

SOAP action

ONEWAY

Indicates whether the operation is one-way. Values: true, false

INPUTENCODING

Operation input encoding

OUTPUTENCODING

Operation output encoding

CM_TARGET_GUID

The unique global identifier (GUID) for the target

CM_TARGET_TYPE

The type of target: j2ee_application

CM_TARGET_NAME

The name of the target in Enterprise Manager

LAST_COLLECTION_TIMESTAMP

The date and time when the metrics were collected

ECM_SNAPSHOT_ID

GUID of the snapshot

SERVICENAME

Name of the JRF web service

WEBMODULE

Name of the web module that contains the JRF web service

PORTNAME

Name of the JRF web service port

URI

Policy reference URI

CATEGORY

Category of the WS-Policy Reference. For example, security.

ENABLED

Specifies whether the policy references are enabled. Values: true, false.

CM_TARGET_GUID

The unique global identifier (GUID) for the target

CM_TARGET_TYPE

The type of target: j2ee_application

CM_TARGET_NAME

The name of the target in Enterprise Manager

LAST_COLLECTION_TIMESTAMP

The date and time when the metrics were collected

ECM_SNAPSHOT_ID

GUID of the snapshot

SERVICENAME

Name of the JRF web service

WEBMODULE

Name of web module that contains the JRF web service

PORTNAME

Name of the JRF web service port

AVAILABLE

Indicates if a port is available.

Possible Values:

• True

• False

RESTSUPPORTED

Indicates whether the port supports REST.

Possible Values:

• True

• False

LOGGINGLEVEL

The logging level for the web service port

MAXREQUESTSIZE

Largest size of message in bytes the port can accept

STYLE

SOAP binding style

SOAPVERSION

Version of the SOAP protocol the port supports

STATEFUL

Indicates if the port is stateful.

Possible Values:

• True

• False

IMPLEMENTORTYPE

Implementor type of this port, such as JAXWS or JAXRPC

TRANSPORTS

Transports from which the web service port is available

ENDPOINTADDRESSURI

The sub-context of the HTTP URL of the web service port exposing an EJB(2.1)

POLICYSUBJECTNAME

The name of the policy subject

POLICYSUBJECTRESOURCEPATTERN

The resource pattern of the policy subject

POLICYATTACHMENTSUPPORT

Determines the class of the supported policies

POLICYSUBJECTTYPE

The type of the policy subject

LEGACYCONFIG

Indicates whether the port has legacy management configuration.

Possible values:

• True

• False

IMPLEMENTORCLASS

The name of the user-provided class that implements the web service port

WSDLURI

The URI to the port WSDL definition

SCHEMAVALIDATEINPUT

Optional validation of input against WSDL schema.

Possible values:

• True

• False

ASYNC

Specifies if async is available.

Possible values:

• True

• False

ASYNCJNDIDESTRESPONSE

JMS queue name for saving responses

ASYNCJNDIDEST

JMS queue name for saving asynchronous requests

ASYNCCONNFACTRESPONSE

JMS connection factory name for saving responses

ASYNCCONNFACT

JMS connection factory name for saving asynchronous requests

CM_TARGET_GUID

The unique global identifier (GUID) for the target

CM_TARGET_TYPE

The type of target: j2ee_application

CM_TARGET_NAME

The name of the target in Enterprise Manager

LAST_COLLECTION_TIMESTAMP

The date and time when the metrics were collected

ECM_SNAPSHOT_ID

GUID of the snapshot

NAME

Name of the web module

DEPLOYMENTORDER

A priority that the server uses to determine when it deploys an item. The priority is relative to other deployable items of the same type

CONTEXTPATH

Context path

SESSIONTIMEOUTSECS

Session timeout in seconds

CM_TARGET_GUID

The unique global identifier (GUID) for the target

CM_TARGET_TYPE

The type of target: j2ee_application

CM_TARGET_NAME

The name of the target in Enterprise Manager

LAST_COLLECTION_TIMESTAMP

The date and time when the metrics were collected

ECM_SNAPSHOT_ID

GUID of the snapshot

SERVICENAME

Name of the web service

NAMEINWSDL

The "name" attribute of the "service" element in the WSDL that describes the Web service. It is specified at development time using the serviceName attribute of the @WebService JWS annotation

IMPLEMENTATIONTYPE

Implementation type of the service. The allowed values are: JAX-WS 2.0 JAX-RPC 1.1

URI

URI of this Web Service. The value corresponds to the final part of the endpoint address in the WSDL that describes the Web services

CM_TARGET_GUID

The unique global identifier (GUID) for the target

CM_TARGET_TYPE

The type of target: j2ee_application

CM_TARGET_NAME

The name of the target in Enterprise Manager

LAST_COLLECTION_TIMESTAMP

The date and time when the metrics were collected

ECM_SNAPSHOT_ID

GUID of the snapshot

SERVICENAME

The "name" attribute of the "service" element in the WSDL that describes the Web service. It is specified at development time using the serviceName attribute of the @WebService JWS annotation.

PORTNAME

Name of the web service port

TRANSPORTPROTOCOL

Transport protocol used to invoke this web service, such as HTTP, HTTPS, or JMS

BLACKOUT_NAME

The name of the blackout

CREATED_BY

The Enterprise Manager administrator who created the blackout

BLACKOUT_GUID

The unique global identifier (GUID) for the blackout

START_TIME

Start of the blackout period for the managed target

END_TIME

End of the blackout period for the managed target. If the target is currently in a blackout period, the END_ TIMESTAMP date will be NULL.

TARGET_NAME

Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.

TARGET_TYPE

Types of targets may include databases, hosts, web servers, applications, or Application Servers. The definer of the collection definition at the Management Agent defines the target type. The target type defines the set of metrics that are collected for a managed target within the Management Repository.

STATUS

Current status of the blackout

Status Values:

• 0: Scheduled

• 1: Start Processing

• 2: Start Partial

• 4: Started

• 5: Stop Pending

• 6: Stop Failed

• 7: Stop Partial

• 8: Edit Failed

• 9: Edit Partial

• 10: Stopped

• 11: Ended

• 12: Partial Blackout

• 13: Modify Pending

BLACKOUT_NAME

The name of the blackout

BLACKOUT_GUID

The unique global identifier (GUID) of the blackout

REASON

Purpose of the blackout. Reasons are chosen from a predefined list by the report owner

DESCRIPTION

Detailed information about the blackout

STATUS

Current status of the blackout

Status Values:

• 0: Scheduled

• 1: Start Processing

• 2: Start Partial

• 4: Started

• 5: Stop Pending

• 6: Stop Failed

• 7: Stop Partial

• 8: Edit Failed

• 9: Edit Partial

• 10: Stopped

• 11: Ended

• 12: Partial Blackout

• 13: Modify Pending

CREATED_BY

Administrator who created the blackout. CREATED_BY returns SYSTEM as the blackout owner if the blackout was created using the Enterprise Manager Command Line Interface.

LAST_START_TIME

Last time the blackout successfully started

LAST_END_TIME

Last time the blackout successfully ended

SCHEDULED_TIME

Possible values are:

• 0 - Immediate schedule

• 1 - Run once at specified time

• 2 - Run on interval

• 3 - Run daily

• 4 - Run on specified days of the week

• 5 - Run on specified days of the month

• 6 - Run on specified days of the year

SCHEDULE_START_TIME

Time the blackout is scheduled to start.

SCHEDULE_END_TIME

Time the blackout is scheduled to end

DURATION

Duration of the blackout in minutes

BLACKOUT_NAME

Name of the blackout

CREATED_BY

Creator of the blackout

BLACKOUT_GUID

Unique blackout ID

REPEATING_BLACKOUT

Specifies whether blackout is repeating. A value of 1 implies a repeating blackout

FREQUENCY_CODE

Specifies whether the blackout is repeating in minutes, days, months, or year.

Possible values:

• -1: ONE_TIME_FREQUENCY_CODE (Non-repeating blackout

• -2: INTERVAL_FREQUENCY_CODE (Frequency is defined in minutes or hours)

• -3: DAILY_FREQUENCY_CODE (Frequency is defined in days)

• -4: WEEK_FREQUENCY_CODE (Frequency is defined in weeks)

• -5: MONTH_FREQUENCY_CODE (Frequency is defined in months)

• -6: YEAR_FREQUENCY_CODE (Frequency is defined in years)

INTERVAL

Valid only for a repeating blackout. The value is set to -1 for a one-time blackout.

The interval depends on value of FREQUENCY_CODE, that is repeating by minutes, days, months, and so on.

Note that the interval must be used in tandem with FREQUENCY_CODE.

OCCURRENCE_NUMBER

Occurrence number of a blackout. By default, is set to 1. However, this value can vary from 1, 2, or 3 for a repeating blackout.

OCCURRENCE_START_TIME

Start time of the occurrence of the blackout.

Note that this value might be at most 2 minutes out with the BLACKOUT_START_TIME.

OCCURRENCE_END_TIME

End time of the occurrence of the blackout. A value of NULL implies an indefinite blackout.

BLACKOUT_START_TIME

Start time of the blackout as a whole. This is the same as OCCURRENCE_START_TIME for a one time blackout. For a repeating blackout, this is the start time of the whole blackout.

Example: For a blackout occurring every hour for 10 minutes starting at 10.00 AM and ending at 11:30 PM, the entries are similar to the following:

ocurrence   start_time   end_time  blackout_start_time
    1         10:00       10:10         10:00
    2         11:00       11:10         10:00
 

BLACKOUT_END_TIME

End time of the blackout as a whole. A value of NULL implies an indefinite blackout. This is the same as OCCURRENCE_END_TIME for a one time blackout. It may be off by at most 2 minutes with OCCURENCE_END_TIME. For a repeating blackout, this is the end time of the whole blackout.

Example: For a blackout occurring every hour for 10 minutes starting at 10.00 AM and ending at 11:30 PM, the entries are similar to the following:

ocurrence   start_time   end_time  blackout_start_time
    1         10:00       10:10         23:30
    2         11:00       11:10         23:30
 

TARGET_NAME

Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.

TARGET_TYPE

Types of targets may include databases, hosts, web servers, applications, or Application Servers. The definer of the collection definition at the Management Agent defines the target type. The target type defines the set of metrics that are collected for a managed target within the Management Repository.

TARGET_GUID

Unique identifier of the target

STATUS

Current status of the blackout

Status Values:

• 0: Scheduled

• 1: Start Processing

• 2: Start Partial

• 4: Started

• 5: Stop Pending

• 6: Stop Failed

• 7: Stop Partial

• 8: Edit Failed

• 9: Edit Partial

• 10: Stopped

• 11: Ended

• 12: Partial Blackout

• 13: Modify Pending

MONTHS

Months array to indicate the month for a blackout repeating yearly

DAYS

Days array indicating the days of the week, and month when a blackout is created. An entry of -1 indicates that it is the last day of the month, and is used to distinguish between February 28th and 29th.

Examples:

• For a blackout occurring on the 1st, 2nd and 11th day of each month, the days array value is (1, 2, 11)

• For a blackout occurring on the 1st and last day of the month, the days array value is (1,-1)

• For a blackout occurring on every Sunday, Monday and Saturday of a week, the days array value is (1,2,7). (Sunday corresponds to the entry 1)

• For a blackout occurring every year on the following days: January 3rd, January 5th, February 10th, February LAST, November 15th, and November 20th, the days array is (3, 5, 10, -1, 15, 20) and months array is (1, 1, 2, 2, 11, 11). Note that the months array is used only when the frequency is defined in years (see FREQUENCY_CODE).

REASON

Purpose of the blackout in English. Reasons are chosen from a predefined list by the report owner.

REASON_CODE

The NLSID of the reason for non-English users

RULE_NAME

Display name in English

DESCRIPTION

Description of the rule in English

TARGET_TYPE

Applicable target type of rule

REFERENCE_URL

Not used in this release

RATIONALE

Explains the importance of this rule, and the consequences of noncompliance

FIXTEXT

Explains the steps to bring the target into compliance with respect to this rule

WARNING

Cautionary or caveat note about this rule

RULE_TYPE

Type of rule.

Possible values:

• Repository

• Agent

• Monitoring

MESSAGE

Message recorded for new violation

CLEAR_MESSAGE

Message recorded for clear violation

SEVERITY

The severity of the rule

Possible values:

• Minor Warning

• Warning

• Critical

LIFECYCLE_STATE

Lifecycle status of the rule

Possible values:

• Development

• Production

• Draft

AUTHOR

Author of the rule

OWNER

Owner of the rule

IS_SYSTEM

Specifies whether the rule is system defined

Possible values

• False

• True

RULE_DNAME_NLSID

NLSID of the rule display name for non-English users

DESCRIPTION_NLSID

NLSID of the rule description for non-English users

RATIONALE_NLSID

NLSID of the rule impact for non-English users

FIXTEXT_NLSID

NLSID of the rule recommendation for non-English users

WARNING_NLSID

NLSID of the rule warning for non-English users

RULE_TYPE_CODE

Code to represent the type of compliance standard rule.

Possible values:

• 1: Repository

• 2: Agent

• 3: Monitoring

SEVERITY_CODE

Code to represent the severity of the compliance standard rule.

Possible values:

• 18: Minor Warning

• 20: Warning

• 25: Critical

LIFECYCLE_STATE_CODE

Code to represent the status of the lifecycle of the compliance standard rule.

Possible values:

• 1: Development

• 2: Production

• 3: Draft

IS_SYSTEM_CODE

Code to represent whether the compliance standard rule is system defined.

Possible values:

• 0: False

• 1: True

CS_NAME

Display name in English

TARGET_TYPE

Applicable target type of the compliance standard

AUTHOR

Author of the compliance standard

OWNER

Owner of the compliance standard

VERSION

Version of the compliance standard

KEYWORDS

Keywords associated with the compliance standard

LIFECYCLE_STATUS

Lifecycle status of the compliance standard

Possible values:

• Development

• Production

AUTO_ENABLE

Specifies whether the compliance standard should be associated with applicable target automatically

Possible values:

• False

• True

DESCRIPTION

Description of the compliance standard in English

REFERENCE_URL

Not used in this release

FRONT_MATTER

Introductory text of the compliance standard

REAR_MATTER

Concluding text of the compliance standard

NOTICE

Legal notice or copyright text about compliance standard

IS_SYSTEM

Specifies whether the compliance standard is system defined

Possible values:

• False

• True

CS_DNAME_NLSID

NLSID of the standard display name for non-English users

LIFECYCLE_STATE_CODE

Code representing the status of the compliance standard lifecycle.

Possible values:

• 1: Development

• 2: Production

AUTO_ENABLE_CODE

Code representing whether the compliance standard should be automatically associated with an applicable target.

Possible values:

• 0: False

• 1: True

DESCRIPTION_NLSID

NLSID of the compliance standard description for non-English users

NOTICE_NLSID

NLSID of the legal notice or copyright text about the compliance standard for non-English users

IS_SYSTEM_CODE

Code representing whether the compliance standard is system defined.

Possible values:

• 0: False

• 1: True

CS_TYPE

Type of compliance standard

CS_TYPE_CODE

Code representing the type of compliance standard.

Possible values:

• 1: Repository

• 2: WebLogic server signature

• 3: Real-time monitoring

CSG_NAME

The display name in English

AUTHOR

Author of the compliance standard group

OWNER

Owner of the compliance standard group

VERSION

The version of the compliance standard group

LIFECYCLE_STATUS

Lifecycle status of the compliance standard group

Possible values:

• Development

• Production

DESCRIPTION

Description of the compliance standard group in English

REFERENCE_URL

Not used in this release

FRONT_MATTER

Introductory text of the compliance standard group

REAR_MATTER

Concluding text of the compliance standard group

NOTICE

Legal notice or copyright text about the compliance standard group

IS_SYSTEM

Specifies whether the compliance standard group is system defined

Possible values:

• False

• True

CSG_DNAME_NLSID

NLSID of the compliance standard group display name for non-English users

LIFECYCLE_STATE_CODE

Code representing the status of the compliance standard group lifecycle.

Possible values:

• 1: Development

• 2: Production

DESCRIPTION_NLSID

NLSID of the compliance standard group description for non-English users

NOTICE_NLSID

NLSID of the legal notice or copyright text about the compliance standard group for non-English users

IS_SYSTEM_CODE

Coderepresenting whether the compliance standard group is system defined.

Possible values:

• 0: False

• 1: True

CS_GUID

Unique identifier of compliance standard

Note: You can obtain this value from the MGMT$COMPLIANCE_STANDARD view.

TARGET_GUID

Unique identifier of target

Note: You can obtain this value from the GC$TARGET view.

CS_NAME

Internal name of the compliance standard

CS_INAME

English display nameof the compliance standard

CS_AUTHOR

Author of the compliance standard

CS_VERSION

Version of the compliance standard

TARGET_NAME

Target name

TARGET_TYPE

Target type

COMPLIANT_RULES

Number of compliant rules in the compliance standard hierarchy for that target

CRITICAL_RULES

Number of critical rules in the compliance standard hierarchy for that target

WARN_RULES

Number of warning rules in the compliance standard hierarchy for that target

MWARN_RULES

Number of minor warning rules in the compliance standard hierarchy for that target

NON_COMPLIANT_RULES

Number of noncompliant rules in the compliance standard hierarchy for that target

ERROR_RULES

Number of error rules in the compliance standard hierarchy for that target

UNKNOWN_RULES

Number of unknown rules in the compliance standard hierarchy for that target

CRIT_VIOLATIONS

Total critical violations raised by compliance standard

WARN_VIOLATIONS

Total warning violations raised by compliance standard

MWARN_VIOLATIONS

Total minor warning violations raised by compliance standard

TOTAL_VIOLATIONS

Total violations raised by compliance standard

COMPLIANCE_SCORE_LEVEL

Specifies the compliance score level

Possible values:

• Compliant

• Critical

• Warning

LAST_EVALUATION_DATE

Last score evaluation date

COMPLIANCE_SCORE

Compliance score of standard

IS_SCORE_VALID

Specifies whether the compliance score is valid.

CS_TYPE

The type of compliance standard

Possible values:

• Repository

• WebLogic Server Signature

• Real-time Monitoring

CS_DNAME_NLSID

NLSID of the standard display name for non-English users

COMPLIANCE_SCORE_LEVEL_CODE

Represents compliance score level

Possible values:

• 0: Compliant

• 1: Critical

• 2: Warning

IS_SCORE_VALID_CODE

Represents whether the compliance score is valid

Possible values:

• 0: False

• 1: True

CS_TYPE_CODE

Represents the type of compliance standard

Possible values:

• 1: Repository

• 2: WebLogic Server Signature

• 3: Real-time monitoring

ROOT_CS_GUID

Unique identifier of the root compliance standard

Note: You can obtain this from the MGMT$COMPLIANCE_STANDARD view.

RQS_GUID

Unique identifier of compliance standard within root compliance standard context

CS_GUID

Unique identifier of compliance standard

Note: You can obtain this from the MGMT$COMPLIANCE_STANDARD view.

ROOT_TARGET_GUID

Unique identifier of root target

Note: You can obtain this from the GC$TARGET view.

TARGET_GUID

Unique identifier of target

Note: You can obtain this from the GC$TARGET view.

ROOT_CS_NAME

Internal name of root compliance standard

ROOT_CS_INAME

English display name of root compliance standard

ROOT_CS_AUTHOR

Author of root compliance standard

ROOT_CS_VERSION

Version of root compliance standard

CS_NAME

Internal name of compliance standard

CS_INAME

Display name in English

CS_AUTHOR

Author of standard

CS_VERSION

Version of standard

ROOT_TARGET_NAME

Root target name

ROOT_TARGET_TYPE

Root target type

TARGET_NAME

Target name

TARGET_TYPE

Target type

COMPLIANT_RULES

Number of compliant rules in the compliance standard hierarchy for that target or member target

CRITICAL_RULES

Number of critical rules in the compliance standard hierarchy for that target or member target

WARN_RULES

Number of warning rules in the compliance standard hierarchy for that target or member target

MWARN_RULES

Number of minor warning rules in the compliance standard hierarchy for that target or member target

NON_COMPLIANT_RULES

Number of noncompliant rules in the compliance standard hierarchy for that target or member target

ERROR_RULES

Number of error rules in the compliance standard hierarchy for that target or member target

UNKNOWN_RULES

Number of unknown rules in the compliance standard hierarchy for that target or member target

CRIT_VIOLATIONS

Total critical violations raised by compliance standard

WARN_VIOLATIONS

Total warning violations raised by compliance standard

MWARN_VIOLATIONS

Total minor warning violations raised by compliance standard

TOTAL_VIOLATIONS

Total violations raised by compliance standard

SUPPRESSED_CRIT

Number of suppressed critical violations

SUPPRESSED_WARN

Number of suppressed warning violations

SUPPRESSED_MWARN

Number of suppressed minor warning violations

COMPLIANCE_SCORE_LEVEL

Compliance score level

Possible values:

• Compliant

• Critical

• Warning

LAST_EVALUATION_DATE

Last evaluation date

COMPLIANCE_SCORE

Compliance score of standard

ROOT_CS_NAME_NLSID

NLSID of the name of the root compliance standard for non-English users

CS_NAME_NLSID

NLSID of the name of the compliance standard for non-English users

COMPLIANCE_SCORE_LEVEL_CODE

Code representing the compliance score level.

Possible values:

• 0: Compliant

• 1: Critical

• 2: Warning

IS_SCORE_VALID_CODE

Code representing whether the compliance score is valid.

Possible values:

• 0: False

• 1: True

ROOT_CS_GUID

Unique identifier of the root compliance standard

Note: You can obtain this from the MGMT$COMPLIANCE_STANDARD view.

RQS_GUID

Unique identifier of the rule within root compliance standard context

RULE_GUID

Unique identifier of the compliance rule

Note: You can obtain this from the MGMT$COMPLIANCE_STANDARD_RULE view.

ROOT_TARGET_GUID

Unique identifier of the root target

Note: You can obtain this from the GC$TARGET view.

TARGET_GUID

Unique identifier of the target

Note: You can obtain this from the GC$TARGET view.

ROOT_CS_NAME

Internal name of the root compliance standard

ROOT_CS_INAME

Display name of the root compliance standard in English

ROOT_CS_AUTHOR

Author of the root compliance standard

ROOT_CS_VERSION

Version of the root compliance standard

PARENT_CS_NAME

Internal name of the parent compliance standard

PARENT_CS_INAME

Display name of the parent compliance standard in English

PARENT_CS_AUTHOR

Author of the standard of parent compliance standard

PARENT_CS_VERSION

Version of the parent compliance standard

RULE_NAME

Display name of the rule in English

RULE_INAME

Internal name of the rule

ROOT_TARGET_NAME

Root target name

ROOT_TARGET_TYPE

Root target type

TARGET_NAME

Target name

TARGET_TYPE

Target type

TOTAL_VIOLATIONS

Total violations raised by the compliance rule within the compliance standard context

LAST_EVALUATION_DATE

Last evaluation date

COMPLIANCE_SCORE

Compliance score of the rule with respect to compliance standard context

IS_SCORE_VALID

Specifies whether the compliance score is valid

ROOT_CS_NAME_NLSID

NLSID of the name of the root compliance standard for non-English users

PARENT_CS_NAME_NLSID

NLSID of the name of the parent compliance standard for non-English users

IS_SCORE_VALID_CODE

Code representing whether the compliance score is valid.

Possible values:

• 0: False

• 1: True

CSG_GUID

Unique identifier of compliance standard group

Note: You can obtain this from the MGMT$COMPLIANCE_STANDARD_GROUP view.

CSG_NAME

Internal name of compliance standard group

CSG_INAME

Display name in English

CSG_VERSION

Version of compliance standard group

CRITICAL_EVALUATIONS

Number of critical evaluations

WARNING_EVALUATIONS

Number of warning evaluations

COMPLIANT_EVALUATIONS

Number of compliant evaluations

CRITICAL_VIOLATIONS

Total critical violations

WARN_VIOLATIONS

Total warning violations

MWARN_VIOLATIONS

Total minor warning violations

COMPLIANCE_SCORE

Compliance score of compliance standard group

CS_GUID

Unique identifier of compliance standard

Note: You can obtain this from the MGMT$COMPLIANCE_STANDARD view.

TARGET_GUID

Unique identifier of target

Note: You can obtain this from the GC$TARGET view.

CS_NAME

Internal name of compliance standard

CS_INAME

Display name in English

CS_AUTHOR

Author of the standard

CS_VERSION

Version of the standard

TARGET_NAME

Target name

TARGET_TYPE

Target type

CRIT_THRESHOLD

Critical threshold value

WARN_THRESHOLD

Warning threshold value

STATUS

Status of the association

Possible values:

• Enabled

• Disabled

CS_DNAME_NLSID

NLSID of the standard display name for non-English users

STATUS_CODE

Code representing the status of the association.

Possible values:

• 1: Enabled

• 2: Disabled

• 3: Pending Enable

• 4: Pending Disable

ROOT_CS_GUID

Unique GUID of the root compliance standard

RQS_GUID

Unique GUID of rule inclusion within the root compliance standard

RULE_GUID

Unique GUID of the rule

ROOT_TARGET_GUID

Unique GUID of the root target

TARGET_GUID

Unique GUID of the target

POLICY_GUID

Unique GUID of the policy (repository rule)

KEY_VALUE

The key value of the violation

COLLECTION_TIMESTAMP

The timestamp when the violation occurred

VIOLATION_GUID

Unique GUID identifying the violation

VIOLATION_LEVEL

Specifies the priority level of the violation

Possible values:

• 18: Minor warning

• 20: Warning

• 25: Critical

RULE_TYPE

Specifies the type of compliance rule being violated

Possible values:

• 1: Repository rule

• 2: Guardian rule

• 3: Compliance real-time rule

ANNOTATED_FLAG

Not used in this release

MESSAGE

Violation message of the rule

MESSAGE_NLSID

NLSID of the violation message of the rule

MESSAGE_PARAMS

Violation message parameters

ACTION_MESSAGE_NLSID

Not used in this release

ACTION_MESSAGE_PARAMS

Not used in this release

VIOLATION_GUID

Unique GUID identifying the violation

COLLECTION_TIMESTAMP

Timestamp at which the violation occurred

COLUMN_NAME

The name of the column of the violation context

COLUMN_TYPE

Type of the column name

Possible values:

• 1: Numeric

• 2: String

COLUMN_VALUE

Specifies the numeric value of the column

Note: Applies only when COLUMN_TYPE is set to 1

COLUMN_STR_VALUE

Specifies the string value of the column

Note: Applies only when COLUMN_TYPE is set to 2

RULE_GUID

Unique GUID of the compliance standard rule

COLUMN_INAME

Internal name of the column

COLUMN_DNAME

Display name of the column

COLUMN_DNAME_NLSID

The NLSID of the display name of the column

COLUMN_TYPE

Data type of the column.

Possible values:

• 1: Number

• 2: String

COLUMN_POSITION

Position of the column within the violation context definition

IS_KEY

Specifies whether the column is a key column (1=key column)

IS_HIDDEN

Specifies whether to show or hide the violation column when viewing the violation in the rule violations UI.

Possible values:

• 0: Show

• 1: Hide

LINK_TEMPLATE

Not used in the current release

LINK_ENCODE

Not used in the current release

IS_LINK_EM_PAGE

Not used in the current release

BUNDLE_ID

The bundle to which this observation belongs based on the rule bundle settings

TARGET

Target against which this observation was found

TARGET_TYPE

Type of the target

RULE_NAME

Name of the real-time Monitoring Compliance Standard Rule

ENTITY_TYPE

Entity type of the entity that had an action against it

USER_PERFORMING_ACTION

Name of the user that performed the action

BUNDLE_IN_VIOLATION

Boolean value if the bundle is in violation currently. This means at least one observation in the bundle is unauthorized. True means bundle is in violation

BUNDLE_START_TIME

Date of the first observation in this bundle

BUNDLE_CLOSE_TIME

Date when this bundle was closed

BUNDLE_CLOSE_REASON

Explanation of why this bundle was closed

DISTINCT_OBS_COUNT

Total number of observations in this bundle

AUTHORIZED_OBS_COUNT

Number of observations in this bundle that are currently authorized

UNAUTHORIZED_OBS_COUNT

Number of observations in this bundle that are currently unauthorized

UNAUTH_CLEARED_OBS_COUNT

Number of observations in this bundle that are currently cleared (at one point they were unauthorized)

UNAUDITED_OBS_COUNT

Number of observations in this bundle that are currently unaudited. They have not been evaluated manually or with Change Management integration to determine audit status

OBSERVATION_ID

Unique ID given to the observation when detected by the agent

BUNDLE_ID

Bundle this observation belongs to based on rule bundle settings

TARGET

Target this observation was found against

TARGET_TYPE

Type of the target

ENTITY_TYPE

Entity type of the entity that had an action against it

ACTION

Action that was observed

ACTION_TIME

Time the action occurred

USER_TYPE

Type of user that performed the action (that is, OS user versus DB user)

USER_PERFORMING_ACTION

Name of the user that performed the action

ORIGINAL_USER_NAME

Previous user name in the case of a SU/SUDO action (only applicable to some entity types)

AFFECTED_ENTITY_NAME

Name of the entity that was affected by this action (file name, and so on)

AFFECTED_ENTITY_PREVIOUS_NAME

Name of the entity prior to the action. For example, for file rename actions, this would be the old file name.

SOURCE_HOST_IP

Source IP of a connection when an action comes from another host (only applicable to some entity types)

ACTION_PROCESS_ID

Process ID of the process that performed the action (only applicable to some entity types)

ACTION_PROCESS_NAME

Name of the process that performed the action (only applicable to some entity types)

ACTION_PARENT_PROCESS_ID

Process ID of the parent process of the process that performed the action (only applicable to some entity types)

ACTION_PARENT_PROCESS_NAME

Name of the parent process of the process that performed the action (only applicable to some entity types)

ENTITY_PREVIOUS_VALUE

Previous value of the entity (only applicable to some entity types)

ENTITY_NEW_VALUE

New value of the entity (only applicable to some entity types)

FILE_ENTITY_PREVIOUS_MD5_HASH

Previous MD5 hash value of the entity (only applicable to some entity types)

FILE_ENTITY_NEW_MD5_HASH

New MD5 hash value of the entity (only applicable to some entity types)

AUDIT_STATUS

Current audit status of the observation (unaudited, authorized, unauthorized, and so on)

AUDIT_STATUS_SET_DATE

Date the most recent audit status was set

AUDIT_STATUS_SET_BY_USER

User who set the most recent audit status

RULE_TYPE

Type of rule

Possible values:

• Repository

• WebLogic Server Signature

• Real-time Monitoring

SEVERITY

Severity level of the rule

• Info

• Warning

• Critical

ENTITY_TYPE

Entity type of the observation bundle and all observations inside that bundle

TARGET_TYPE

Target type of the observation bundle and all observations inside that bundle

RULE_NAME

Name of the rule that this violation is against

COMPLIANCE_STANDARD_NAME

Name of the compliance standard that this violation is against.

TARGET

Name of the target that this violation is against.

BUNDLE_ID

Internal ID of the obervation bundle that is in violation. This observation bundle has one or more unauthorized observations in it

BUNDLE_START_TIME

Time that the observation bundle started

BUNDLE_CLOSE_TIME

Time that the observation bundle closed

USER_NAME

User name that performed the actions in this bundle

AUTHORIZED_OBS_COUNT

Number of authorized observations in the observation bundle involved in this violation

UNAUTHORIZED_OBS_COUNT

Number of unauthorized observations in the observation bundle involved in this violation.

UNAUTH_CLEARED_OBS_COUNT

Number of unauthorized-cleared observations in the observation bundle involved in this violation

ROOT_CS_ID

Root compliance standard ID. This is used for the internal representation of the violation context.

RQS_ID

Runtime compliance standard ID. This is used for the internal representation of the violation context

RULE_ID

Internal ID of the rule with the violation.

TARGET_ID

Internal ID of the target with the violation.

ROOT_TARGET_ID

Internal ID of the target hierarchy.

TARGET_NAME

Name of the target

TARGET_TYPE

Target type of the target

CRIT_EVALS

Number of critical-level evaluations

WARN_EVALS

Number of warning-level evaluations

COMPLIANT_EVALS

Number of compliant evaluations

CRIT_VIOLATIONS

Number of critical-level violations

WARN_VIOLATIONS

Number of warning-level violations

MWARN_VIOLATIONS

Number of minor warning-level violations

COMPLIANCE_SCORE

Current compliance score for the target

TARGET_ID

Internal representation of the target

TARTGET_TYPE_INAME

Internal representation of the target type

ELEMENT_TYPE

Type of element (compliance standard, compliance framework)

ELEMENT_NAME

Display name of the compliance standard or compliance framework

CRIT_EVALS

Number of critical-level evaluations

WARN_EVALS

Number of warning-level evaluations

COMPLIANT_EVALS

Number of compliant evaluations

CRIT_VIOLATIONS

Number of critical-level violations

WARN_VIOLATIONS

Number of warning-level violations

MWARN_VIOLATIONS

Number of minor warning-level violations

COMPLIANCE_SCORE

Current compliance score for the compliance standard or framework

NON_COMPLIANT_SCORE

Current non-compliant score for the compliance standard or framework

AUTHOR

Author of the compliance standard or framework

VERSION

Version of the compliance standard or framework

ELEMENT_ID

Internal ID of the compliance standard or compliance framework

FRAMEWORK_ID

Internal ID of the compliance framework

ELEMENT_INAME

Internal representation of the compliance standard or framework

ELEMENT_TYPE

Type of element (compliance standard, compliance framework)

ELEMENT_ID

Internal ID representation of the compliance standard or framework

ELEMENT_NAME

Display name of the compliance standard or compliance framework

FRAMEWORK_ID

Internal ID representation of the compliance framework

AVG_COMPLIANCE_SCORE

Average compliance score over the last 31 days

DAILY_AVG_VIOLATIONS

Average number of violations per day over the last 31 days

SNAPSHOT_TS

The snapshot time stamp

TOTAL_EVALS

Total evaluations over the last 31 days

ELEMENT_INAME

Internal representation of the compliance standard or framework

DISPLAY_TARGET_NAME

The display name of the client

CSACLIENT

The display name plus the custom keys, if they exist

COLLECTION_TIMESTAMP

The time at which the data was collected from the client

NET_IP

The actual IP address of the client

NET_EFFECTIVE_IP

The client IP address seen by the server

COLLECTION_MESSAGE

Error message generated while applet was running

OS_USER_NAME

The client's OS user name

HOSTNAME

The client's host name

DOMAIN

The client's domain

BOOT_DISK_VOLUME_SERIAL_NUM

The client's boot disk volume serial number

COMPLIANCE

The overall compliance score for the client (15=passed, 18=info, 20=warning, 25=critical)

APPID

The collection tag for this client configuration

NET_SUBNET

The client's subnet mask

NET_LATENCY_IN_MS

The client's HTTP response time with the server

NET_BANDWIDTH_IN_KBITPS

The client's download bandwidth from the server

BROWSER_TYPE

The name of the browser used to run CSA

BROWSER_VERSION

The version of the browser used to run CSA

BROWSER

A summary column that combines the browser name and version

BROWSER_JVM_VENDOR

The version of the JVM used to run the applet

BROWSER_JVM_VERSION

The version of the JVM used to run the applet

BROWSER_PROXY_SERVER

The proxy server used by the browser

BROWSER_PROXY_EXCEPTIONS

The client's browser proxy exceptions

BROWSER_CACHE_SIZE_IN_MB

The client browser's disk cache size

BROWSER_CACHE_UPATE_FRQ

The browser's cache update policy

BROWSER_HTTP1_1_SUPPORT

Whether or not the browser supports HTTP 1.1

REFERRING_URL_HEADER

The URL from which the user came to CSA, minus the query string

REFERRING_URL_PARAMS

The query string of the URL from which the user came to CSA

REFURL

The complete URL from which the user came to CSA

CSA_URL_HEADER

The URL from which the user ran CSA, minus the query string

CSA_URL_PARAMS

The query string of the URL from which the user ran CSA

CSAURL

The complete URL from which the user ran CSA

DESTINAION_URL_HEADER

The destination URL, minus the query string

DESTINATION_URL_PARAMS

The query string of the destination URL

DESTURL

The complete destination URL

CONNECTION_TYPE

The estimated connection type, based on the download bandwidth (1=LAN, 2=cable, 3=dialup)

IS_WINDOWS_ADMIN

Whether or not the os user is a Windows administrator

WINDOWS_DOMAIN

The Windows domain of the host

BROWSER_PROXY_ENABLED

Whether or not the proxy server is enabled in the browser

AUTO_CONFIG_URL

The URL of the proxy auto-configuration script used by the browser

NUMBER_OF_COOKIES

The number of cookies collected by CSA

NUMBER_OF_CUSTOM_VALUES

The number of custom properties collected by CSA

HARDWARE

A summary of the system configuration, machine architecture, memory, disk space, and CPU

HARDWARE_VENDOR_NAME

The name of the hardware vendor, such as Dell

SYSTEM_CONFIG

The client's system configuration

MACHINE_ARCHITECTURE

The client's machine architecture

BUS_FREQ_IN_MHZ

The frequency of the motherboard's Front Side Bus (FSB)

MEMORY_SIZE_IN_MB

The total amount of physical memory

AVAIL_MEMORY_SIZE_IN_MB

The amount of available physical memory when CSA was run

LOCAL_DISK_SPACE_IN_GB

The total amount of disk space

AVAIL_LOCAL_DISK_SPACE_IN_GB

The available disk space

CPU_COUNT

The number of CPUs

SYSTEM_SERIAL_NUMBER

The host's serial number

MIN_CPU_SPEED_IN_MHZ

The minimum possible CPU speed

MAX_CPU_SPEED_IN_MHZ

The maximum possible CPU speed

CPU

The CPU vendor, implementation, and frequency

CPU_BOARD_COUNT

The number of CPU boards

IOCARD_COUNT

The number of IO cards

NIC_COUNT

The number of NICs

FAN_COUNT

The number of fans

POWER_SUPPLY_COUNT

The number of power supplies

SYSTEM_BIOS

The system BIOS

OPERATINGSYSTEM

A summary of the OS name, version, update level, address length, and distributor version

OS_NAME

The OS name

OS_VENDOR_NAME

The OS vendor name

OS_BASE_VERSION

The OS base version

OS_UPDATE_LEVEL

The OS update level

OS_DISTRIBUTOR_VERSION

The OS distributor version

MAX_SWAP_SPACE_IN_MB

The maximum amount of swap space

OS_ADDRESS_LENGTH_IN_BITS

The OS address length in bits

MAX_PROCESS_VIRTUAL_MEMORY

The maximum amount of virtual memory that can be allocated to a process

TIMEZONE

The time zone as reported in the registry

TIMEZONE_REGION

The time zone region as reported by the JVM

TIMEZONE_DELTA

The offset in minutes from GMT

NUMBER_OF_OS_PROPERTIES

The number of OS properties found

NUMBER_OF_OS_PATCHES

The number of OS patches found

NUMBER_OF_OS_FILESYSTEMS

The number of file systems found

NUMBER_OF_OS_REGISTERED_SW

The number of OS-registered software products found

SNAPSHOT_ID

The GUID of this configuration

TARGET_ID

The GUID of the collector target

INTERNAL_TARGET_NAME

The internal name of the client configuration

INTERNAL_TARGET_TYPE

oracle_csa_client

COLLECTION_DURATION

The amount of time it took to run CSA

LOADED_TIMESTAMP

The time at which the data was loaded into the repository

APPLET_VERSION

The version of the applet

TARGET_ID_METHOD

not used

CUSTOM_CLASS

The name of the custom class (if any)

CUSTOM_CLASS_VERSION

not used

KEY1

Custom key 1(optional)

KEY2

Custom key 2 (optional)

KEY3

Custom key 3 (optional)

PROXY_TARGET_NAME

The name of the collector target

PROXY_TARGET_DISPLAY_NAME

The display name of the collector target

PROXY_TARGET_ID

The GUID of the collector target

RULES_COUNT

The total number of rules evaluated (including rules with status of NA)

RULES_NA_COUNT

The number of rules that were not applicable

RULES_PASSED_COUNT

The number of rules that passed

RULES_INFO_COUNT

The number of rules that failed with status info

RULES_WARNING_COUNT

The number of rules that failed with status warning

RULES_CRITICAL_COUNT

The number of rules that failed with status critical

ID

The GUID of this failed collection

TIMESTAMP

The time at which this failed collection occurred

TIMEZONE_DELTA

The offset in minutes from GMT

SAVED_TIMESTAMP

The time at which the data was loaded in the repository

EFFECTIVE_IP

The effective IP address of the client

APPID

The collection tag

REFERRING_URL_HEADER

The URL from which the user was referred to CSA, minus the query string

REFERRING_URL_PARAMS

The query string of the URL from which the user was referred to CSA

CSA_URL_HEADER

The URL from which the user ran CSA, minus the query string

CSA_URL_PARAMS

The query string of the URL from which the user tried to run CSA

DESTINATION_URL_HEADER

The destination URL minus the query string

DESTINATION_URL_PARAMS

The query string of the destination URL

BROWSER_TYPE

The type of browser used to run CSA

BROWSER_VERSION

The version of the browser used to run CSA

BROWSER_JVM_VENDOR

The vendor of the JVM used to run CSA

BROWSER_JVM_VERSION

The version of the JVM used to run CSA

OS_ARCH

The OS architecture of the client as reported in the ìos.archî Java system property

OS_NAME

The OS name of the client as reported in the ìos.nameî Java system property

HTTP_REQUEST_USER_AGENT

The HTTP user-Agent header sent by the client

ERROR_CODE

The error condition that caused the failed collection (0=OS not supported, 1=browser not supported, 2=applet certificate refused by user, 3=other error)

ERROR_TEXT

Text that is collected along with the error code, such as a stack trace

DISPLAY_TARGET_NAME

The display name of the client

TYPE

The type of the component

NAME

The name of the component

VERSION

The version of the component

DESCRIPTION

The description of the component

ISNTALLATION_DATE

The date the component was installed

SNAPSHOT_ID

The snapshot ID of the client configuration

TARGET_ID

The target GUID of the collector target

COLLECTION_TIMESTAMP

The time at which the client configuration was collected

DISPLAY_TARGET_NAME

The display name of the client

NAME

The name of the software

VENDOR_NAME

The name of the software vendor

VERSION

The version of the software

INSTALLATION_DATE

The date on which the software as installed

INSTALLED_LOCATION

The location in which the software is installed

DESCRIPTION

The description of the software

VENDOR_SW_SPECIFIC_INFO

Any additional information provided by the vendor

SNAPSHOT_ID

The snapshot ID of the client configuration

TARGET_ID

The ID of the collector target

COLLECTION_TIMESTAMP

The time at which the data was collected

DISPLAY_TARGET_NAME

The display name of the client

NAME

The name of the cookie

VALUE

The payload of the cookie

SNAPSHOT_ID

The snapshot ID of the client configuration

TARGET_ID

The ID of the collector target

COLLECTION_TIMESTAMP

The time at which the data was collected

DISPLAY_TARGET_NAME

The display name of the client

TYPE

The category of the custom property

NAME

The name of the custom property

TYPE_UI

The display category of the custom property

NAME_UI

The display name of the custom property

VALUE

The value of the custom property

DISPLAY_UI

Should this property be displayed in the UI? Y or N

HISTORY_TRACKING

Not used

SNAPSHOT_ID

The snapshot ID of the client configuration

TARGET_ID

The ID of the collector target

COLLECTION_TIMESTAMP

The time at which the data was collected

SNAPSHOT_ID

The snapshot ID of the client configuration

NAME

The name of the rule

DESCRIPTION

The description of the rule

STATUS

The status of the rule (-2=NA, 15=passed, 18=info, 20=warning, 25=critical)

MOREINFO

Any additional information for the rule

DISPLAY_TARGET_NAME

The display name of the client

VENDOR_NAME

The name of the CPU vendor

FREQ_IN_MHZ

The clock frequency of the CPU

ECACHE_IN_MB

The size of the extended cache

IMPL

The CPU implementation

REVISION

The CPU revision

MASK

The CPU mask

NUMBER_OF_CPUS

The number of CPUs

SNAPSHOT_ID

The snapshot ID of the client configuration

TARGET_ID

The ID of the collector target

COLLECTION_TIMESTAMP

The time at which the data was collected

DISPLAY_TARGET_NAME

The display name of the client

VENDOR_NAME

The name of the IO card vendor

NAME

The name of the IO card

FREQ_IN_MHZ

The frequency of the IO card bus

BUS

The bus type (PCI or AGP)

REVISION

The IO card revision

NUMBER_OF_IOCARDS

The number of cards

SNAPSHOT_ID

The snapshot ID of the client configuration

TARGET_ID

The ID of the collector target

COLLECTION_TIMESTAMP

The time at which the data was collected

DISPLAY_TARGET_NAME

The display name of the client

NAME

The name of the NIC

DESCRIPTION

The description of the NIC

FLAGS

Flags set on the NIC – not applicable for Windows

MAX_TRANSFER_UNIT

The maximum transfer unit of the NIC

INET_ADDRESS

The IP address of the NIC

MASK

The subnet mask of the NIC

BROADCAST_ADDRESS

The broadcast address of the NIC

MAC_ADDRESS

The MAC address of the NIC

HOSTNAME_ALIASES

Any aliases for the host name that are stored in the NIC

DEFAULT_GATEWAY

The default gateway for the NIC

DHCP_ENABLED

Whether or not DHCP is enabled

SNAPSHOT_ID

The snapshot ID of the client configuration

TARGET_ID

The ID of the collector target

COLLECTION_TIMESTAMP

The time at which the data was collected

DISPLAY_TARGET_NAME

The display name of the client

SOURCE

The source (e.g. the system environment) of the property

NAME

The name of the property

VALUE

The value of the property

SNAPSHOT_ID

The snapshot ID of the client configuration

TARGET_ID

The ID of the collector target

COLLECTION_TIMESTAMP

The time at which the data was collected

DISPLAY_TARGET_NAME

The display name of the client

RESOURCE_NAME

The name of the file system

MOUNT_LOCATION

The location from which it is mounted

TYPE

The file system type

DISK_SPACE_IN_GB

The total disk space

AVAIL_DISK_SPACE_IN_GB

The available disk space

LOCAL_DRIVE

The Windows drive letter on which it is mounted

MOUNT_OPTIONS

The mount options

SNAPSHOT_ID

The snapshot ID of the client configuration

TARGET_ID

The ID of the collector target

COLLECTION_TIMESTAMP

The time at which the data was collected

CM_TARGET_GUID

The unique ID for the target

CM_TARGET_TYPE

The type of the target

CM_TARGET_NAME

The name of the target

CM_SNAPSHOT_TYPE

Type of snapshot

CCS_UI_NAME

Display CCS name

CCS_DRAFT_NUMBER

Draft number of the CCS for draft CCSs. (It is 0 for non-draft CCS)

LAST_COLLECTION_TIMESTAMP

The timestamp of the collection specified in the target's time zone

ECM_SNAPSHOT_ID

The Enterprise Configuration Management (ECM) snapshot ID that can be used to join with other ECM views

DATA_SOURCE_NAME

Depending on the value for EXPR_TYPE, this is one of the following:

• File name (relative to the base path)

• OS command name

• Database SQL query name

CONTAINER

A slash (/) separated hierarchal container with additional identification information and order information. This column could be a single space but only if the attribute name and value are available and are at the top level of the hierarchy.

ATTR

Attribute name

ATTR_ORDER

The order of the attribute within its enclosing container

CONTAINER_ORDER

The order of the container in the data source contents

VALUE

Attribute value

CM_TARGET_GUID

The unique ID for the target

CM_TARGET_TYPE

The type of the target

CM_TARGET_NAME

The name of the target

CM_SNAPSHOT_TYPE

Type of snapshot

CCS_UI_NAME

Display CCS name

CCS_DRAFT_NUMBER

Draft number of the CCS for draft CCSs. (It is 0 for non-draft CCS)

LAST_COLLECTION_TIMESTAMP

The time stamp of the collection specified in the target's time zone

ECM_SNAPSHOT_ID

The Enterprise Configuration Management (ECM) snapshot ID that can be used to join with other ECM views

DATA_SOURCE_NAME

Depending on the value for EXPR_TYPE, this is one of the following:

• File name (relative to the base path)

• OS command name

• Database SQL query name

EXPR_TYPE

The type of expression

Possible values:

• F: Files

• O: OS commands

• D: Database queries

SOURCE_ORDER

Numeric order in which the source was obtained

EXPR_NAME

The name of the expression

• For files, this can be the wildcarded path expression from the custom configuration specification that caused the file to be collected

• For OS commands and database queries, this is a user-specified name for the expression

EXPR_VALUE

The value of the expression

• For files, this is the same as the value for EXPR_NAME

• For OS commands, this is the actual command

• For database queries, this is the actual database query

FULL_PATH

The full path

• For files, this is the full file path

• For OS commands, this is the base directory path

CONTENTS_SIZE

Byte size of contents

HASH

Hash value for collected data

CONTENTS

Character large object (CLOB) contents column with raw contents for this data source

COLLECTION_ERROR_MSG

Any relevant error message for this data source during the collection

PARSING_ERROR_MSG

Any relevant error messages generated during parsing of data contents

TARGET_GUID

The unique ID for the target

TARGET_NAME

Name of the target

TARGET_TYPE

Type of target

SNAPSHOT_TYPE

Snapshot type

CCS_UI_NAME

Display CCS name

CCS_DRAFT_NUMBER

Draft number of the CCS for draft CCSs. (It is 0 for non-draft CCS)

DISPLAY_TARGET_NAME

User-friendly display name of the target

DISPLAY_TARGET_TYPE

User-friendly display name of the target type

COLLECTION_TIMESTAMP

Time stamp of the collection specified in the time zone of the target

IS_CURRENT

Specifies whether the data is current or saved

Possible values:

• Y: Current data

• N: Saved data

DESCRIPTION

Snapshot description provided by the user

CREATOR

For saved snapshots, the creator is the Enterprise Manager user who saved the snapshot

SAVED_TIMESTAMP

Time stamp of when the snapshot was saved specified in the time zone of the database

LAST_UPLOAD_TIMESTAMP

Last time (specified in the time zone of the database) when a collection was processed for this snapshot type.

ECM_SNAPSHOT_ID

The Enterprise Configuration Management (ECM) snapshot ID that can be used to join with other ECM views

DATA_SOURCE_NAME

Depending on the value for EXPR_TYPE, this is one of the following:

• File name (relative to the base path)

• OS command name

• Database SQL query name

CONTAINER

A slash (/) separated hierarchal container with additional identification information and order information. This column could be a single space but only if the attribute name and value are available and are at the top level of the hierarchy.

ATTRIBUTE

Attribute name

VALUE

Attribute value

CONTAINER_ORDER

The order of the container in the data source contents

ATTRIBUTE_ORDER

The order of the attribute within its enclosing container

CM_TARGET_GUID

The unique ID for the target

CM_TARGET_TYPE

Type of the target

CM_TARGET_NAME

Name of the target

CM_SNAPSHOT_TYPE

Type of snapshot

CCS_UI_NAME

Display CCS name

CCS_DRAFT_NUMBER

Draft number of the CCS for draft CCSs. (It is 0 for non-draft CCS)

LAST_COLLECTION_TIMESTAMP

The time stamp of the collection specified in the target's time zone

ECM_SNAPSHOT_ID

The Enterprise Configuration Management (ECM) snapshot ID that can be used to join with other ECM views

DATA_SOURCE_NAME

Depending on the value for EXPR_TYPE, this is one of the following:

• File name (relative to the base path)

• OS command name

• Database SQL query name

CONTAINER

A slash (/) separated hierarchal container with additional identification information and order information. This column could be a single space but only if the attribute name and value are available and are at the top level of the hierarchy.

ATTR

Attribute name

ATTR_ORDER

The order of the attribute within its enclosing container

CONTAINER_ORDER

The order of the container in the data source contents

VALUE

Attribute value

HOST_NAME

Name of the target where the metrics will be collected

TARGET_NAME

Name of the database containing the data files

TARGET_TYPE

The type of target, for example, Oracle_ database

TARGET_GUID

The unique ID for the database target

COLLECTION_ TIMESTAMP

The date and time when the metrics were collected

TABLESPACE_NAME

Name of the tablespace

CONTENTS

Tablespace contents: PERMANENT or TEMPORARY

STATUS

Tablespace status: ONLINE, OFFLINE, or READ ONLY

EXTENT_MANAGEMENT

Extent management tracking: DICTIONARY or LOCAL

ALLOCATION_TYPE

Type of extent allocation in effect for this tablespace

LOGGING

Default logging attribute

TABLESPACE_SIZE

Current size of the tablespace in bytes

INITIAL_EXT_SIZE

Default initial extent size

NEXT_EXTENT

Next extent in the sequence

INCREMENT_BY

Default percent increase for extent size

MAX_EXTENTS

Default maximum number of extents

TABLESPACE_USED_SIZE

Amount of data (in bytes) contained in the tablespace

SEGMENT_SPACE_MANAGEMENT

Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO)

BLOCK_SIZE

Tablespace block size

MIN_EXTENTS

Default minimum number of extents

MIN_EXTLEN

Minimum extent size for this tablespace

BIGFILE

Indicates whether the tablespace is a bigfile tablespace (YES) or a smallfile tablespace (NO)

HOST_NAME

Name of the target where the metrics will be collected

TARGET_NAME

Name of the database containing the data files

TARGET_TYPE

The type of target, for example, Oracle_ database

TARGET_GUID

The unique ID for the database target

COLLECTION_ TIMESTAMP

The date and time when the metrics were collected

FILE_NAME

Name of the data file

TABLESPACE_NAME

Name of the tablespace containing the data file

STATUS

Data file status: ACTIVE or NOT ACTIVE

FILE_SIZE

Size of the data file

AUTOEXTENSIBLE

Autoextensible indicator

INCREMENT_BY

Autoextension increment

MAX_FILE_SIZE

Maximum file size in bytes

OS_STORAGE_ENTITY

OS level storage entity on which the file resides. For regular files it is the name of the file system on which the file resides. For character or raw files it is the name of the raw device

CREATE_BYTES

The initial size of the data file when it was created in bytes

HOST_NAME

Name of the target where the metrics will be collected

TARGET_NAME

Name of the database containing the data files

TARGET_TYPE

The type of target, for example, Oracle_ database

TARGET_GUID

The unique ID for the database target

COLLECTION_ TIMESTAMP

The date and time when the metrics were collected

FILE_NAME

Name of the database control file.

STATUS

The type of control file:

STANDBY - indicates database is in standby mode

LOGICAL - indicates the database is a logical standby database (not a physical standby)

CLONE - indicates a clone database

BACKUP | CREATED - indicates database is being recovered using a backup or created control file

CURRENT - the control file changes to this type following a standby database activate or database open after recovery

CREATION_DATE

Control file creation date

SEQUENCE_NUM

Control file sequence number incremented by control file transactions

CHANGE_NUM

Last change number in the backup control file. Value is NULL if the control file is not a backup

MOD_DATE

Last timestamp in the backup control file. NULL if the control file is not a backup

OS_STORAGE_ENTITY

OS level storage entity on which the file resides. For regular files it is the name of the file system on which the file resides. For character or raw files it is the name of the raw device

HOST_NAME

Name of the target host where the metrics will be collected

TARGET_NAME

Name of the database target from which the metrics are collected

TARGET_TYPE

The type of target, for example, Oracle_ database

TARGET_GUID

The unique ID for the database target

COLLECTION_ TIMESTAMP

The date and time when the metrics were collected

DATABASE_NAME

Name of the database

GLOBAL_NAME

Global name of the database

BANNER

Component name and version number

HOST

Name of the host system

INSTANCE_NAME

Name of the instance

STARTUP_TIME

Time when instance was started up

LOGINS

ALLOWED or RESTRICTED

LOG_MODE

The archive log mode, either ARCHIVELOG or NOARCHIVELOG

OPEN_MODE

Open mode information

DEFAULT_TEMP_TABLESPACE

Default temporary tablespace name

CHARACTERSET

NLS parameter value for NLS_CHARACTERSET

NATIONAL_CHARACTERSET

NLS parameter value for NLS_NCHAR_CHARACTERSET

HOST

Name of the host target where the database feature usage information is collected

DATABASE_NAME

Name of the database where the database feature usage information is collected

INSTANCE_NAME

Name of the instance where the database feature usage information is collected

TARGET_TYPE

Either Oracle_database or rac_database

DBID

A unique number that identifies a database instance

NAME

The feature name

CURRENTLY_USED

TRUE if the feature is currently in use, FALSE if the feature is not in use

DETECTED_USAGES

The number of times the feature has been used by the database

FIRST_USAGE_DATE

The date that the first usage of the feature occurred

LAST_USAGE_DATE

The date of the most recent usage of the feature

VERSION

The version number of the database

LAST_SAMPLE_DATE

The date that the database was last evaluated for feature usage

LAST_SAMPLE_PERIOD

The interval between the LAST_ SAMPLE_DATE date and the database feature usage evaluation before that (by default, seven days)

SAMPLE_INTERVAL

The number of seconds between the LAST_SAMPLE_DATE date and the next database feature usage evaluation

TOTAL_SAMPLES

The total number of database feature usage evaluation samples that have been collected

AUX_COUNT

For Oracle internal use only

DESCRIPTION

The description of the feature

HOST_NAME

Name of the target where the metrics will be collected

TARGET_NAME

Name of the database target from which the metrics are collected

TARGET_TYPE

The type of target, such as Oracle_ database

TARGET_GUID

The unique ID for the database target

COLLECTION_ TIMESTAMP

The date and time when the metrics were collected

NAME

Name of the initialization parameter

ISDEFAULT

Indicates whether the parameter value is the default

VALUE

The parameter value

DATATYPE

The data type that the value string can be mapped to, for example, NUMBER, DATE, or TEXT

HOST_NAME

The name of the host on which the database is running

TARGET_NAME

Name of the database containing the tablespace

TARGET_TYPE

The type of target, for example, Oracle_ database

TARGET_GUID

The unique ID for the database target

COLLECTION_ TIMESTAMP

The date and time when the metrics were collected

SESSIONS_MAX

The maximum number of sessions allowed for the database

SESSIONS_WARNING

The number of sessions which will generate a warning for the database

SESSIONS_CURRENT

The current number of sessions for the database

SESSIONS_HIGHWATER

The highest water mark of sessions for the database

USERS_MAX

The maximum number of users for the database

HOST_NAME

Name of the target where the metrics will be collected

TARGET_NAME

Name of the database target from which the metrics are collected

TARGET_TYPE

The type of target, for example, Oracle_ database

TARGET_GUID

The unique ID for the database target

COLLECTION_ TIMESTAMP

The date and time when the metrics were collected

GROUP_NUM

Redo log group identifier number

STATUS

Log status:

UNUSED - The online redo log has never been written to. This is the state of a redo log that was just added, or just after a RESETLOGS, when it is not the current redo log.

CURRENT - This is the current redo log. This implies that the redo log is active. The redo log could be open or closed.

ACTIVE - The log is active but is not the current log. It is needed for crash recovery. It may be in use for block recovery. It might or might not be archived.

CLEARING - The log is being re-created as an empty log after an ALTER DATABASE CLEAR LOGFILE statement. After the log is cleared, the status changes to UNUSED.

CLEARING_CURRENT - The current log is being cleared of a closed thread. The log can stay in this status if there is some failure in the switch such as an I/O error writing the new log header.

INACTIVE - The log is no longer needed for instance recovery. It may be in use for media recovery. It might or might not be archived.

MEMBERS

Number of members in the log group

FILE_NAME

Redo log file (member) name

ARCHIVED

Archive status either YES or NO

LOGSIZE

Size of the log file in bytes

SEQUENCE_NUM

Log sequence number

FIRST_CHANGE_SCN

Lowest SCN in the log

OS_STORAGE_ENTITY

OS level storage entity on which the file resides. For regular files it is the name of the file system on which the file resides. For character or raw files it is the name of the raw device.

THREAD_NUM

Log thread number

HOST_NAME

Name of the target where the metrics will be collected

TARGET_NAME

Name of the database containing the data files

TARGET_TYPE

The type of target, for example, Oracle_ database

TARGET_GUID

The unique ID for the database target

COLLECTION_ TIMESTAMP

The date and time when the metrics were collected

ROLLNAME

Name of the rollback segment

STATUS

Rollback segment status

TABLESPACE_NAME

Name of the tablespace containing the rollback segment

EXTENTS

Number of extents in rollback segment

ROLLSIZE

Size in bytes of rollback segment. This values differs by the number of bytes in one database block from the value of the BYTES column of the ALL/DBA/USER_ SEGMENTS views.

INITIAL_SIZE

Initial extent size in bytes

NEXT_SIZE

Secondary extent size in bytes

MAXIMUM_EXTENTS

Maximum number of extents

MINIMUM_EXTENTS

Minimum number of extents

PCT_INCREASE

Percent increase for extent size

OPTSIZE

Optimal size for rollback segments

AVEACTIVE

Current size of active extents averaged over time

WRAPS

Number of times rollback segment is wrapped

SHRINKS

Number of times the size of a rollback segment decreases

AVESHRINK

Average shrink size

HWMSIZE

High water mark of rollback segment size

HOST_NAME

Name of the target where the metrics will be collected

TARGET_NAME

Name of the database containing the datafiles

TARGET_TYPE

The type of target, for example, Oracle_ database

TARGET_GUID

The unique ID for the database target

COLLECTION_ TIMESTAMP

The date and time when the metrics were collected

SGANAME

SGA component name

SGASIZE

SGA component size in kilobytes or megabytes

HOST_NAME

Name of the target where the metrics will be collected

TARGET_NAME

The type of target, for example, Oracle_ database

TARGET_GUID

The unique ID for the database target

COLLECTION_ TIMESTAMP

The date and time when the metrics were collected

TABLESPACE_NAME

Name of the tablespace

CONTENTS

Tablespace contents: PERMANENT or TEMPORARY

STATUS

Tablespace status: ONLINE, OFFLINE, or READ ONLY

EXTENT_MANAGEMENT

Extent management tracking: DICTIONARY or LOCAL

ALLOCATION_TYPE

Type of extent allocation in effect for this tablespace

LOGGING

Default logging attribute

TABLESPACE_SIZE

Current size of the tablespace in bytes

INITIAL_EXT_SIZE

Default initial extent size

INCREMENT_BY

Default percent increase for extent size

MAX_EXTENTS

Default maximum number of extents

HOST_NAME

Name of the target where the metrics will be collected

TARGET_NAME

Name of the database containing the data files

TARGET_TYPE

The type of target, for example, Oracle_ database

TARGET_GUID

The unique ID for the database target

COLLECTION_ TIMESTAMP

The date and time when the metrics were collected

NAME

Name of the database option

SELECTED

If the option is currently LOADED and ACTIVE (TRUE), or either the option does not exist or is NOT LOADED or INACTIVE (FALSE)

INCIDENT_ID

The unique RAW ID of an incident

INCIDENT_NUM

The end-user visible ID of the incident

SUMMARY_MSG

Summary message of the incident

SEVERITY

The severity of the incident

IS_ESCALATED

Specifies whether the issue is escalated.

Possible values:

• 1: Yes

• 0: No

ESCALATION_LEVEL

If the incident is escalated, then this value specifies the escalation level. This value can be between level 1 and level 5.

PRIORITY

The priority level of the incident.

Possible values:

• None

• Urgent

• Very High

• High

• Medium

• Low

RESOLUTION_STATE

The resolution state of the issue.

OWNER

The owner of the issue. If there is no owner, then this value is "-".

IS_ACKNOWLEDGED

Specifies whether the incident is acknowledged.

Possible values:

• 1: Yes

• 0: No

IS_SUPPRESSED

Specifies whether the incident is suppressed.

Possible values:

• 1: Yes

• 0: No

LAST_ANNOTATION_SEQ

The sequence ID of the last annotation entered for this issue

CREATION_DATE

The date the incident was created

LAST_UPDATED_DATE

The date when this incident was updated last

EVENT_COUNT

The number of events associated with this incident

OPEN_STATUS

Specifies the status of the incident.

Possible values:

• 1: Open incidents

• 0: Closed incidents

CLOSED_DATE

The date when the incident is closed (if it is closed)

SRC_COUNT

The number of unique target or source object combinations to which events in this incident belong

TARGET_GUID

The unique ID of a target associated with the incident This value is set only when all the events in the incident belong to the same target or source object combination. It is set to null when the events belong to multiple sources.

SOURCE_OBJ_TYPE

The source object or entity type to which all events in the incident belong (if they all belong to the same target or source object combination). Set to null when the events belong to multiple sources.

ADR_RELATED

Indicates if the incident is a Oracle diagnostic incident.

Possible values:

• 0: No

• 1: Yes

TICKET_ID

Ticket associated with this incident (can be null)

TICKET_STATUS

Status of the ticket associated with this incident (can be null)

SR_ID

ID of the service request associated with this problem (if any)

PROBLEM_ID

The unique RAW ID of the related problem (if any)

PROBLEM_NUM

The end-user visible ID of the related problem (if any)

INCIDENT_ID

The unique RAW ID of an incident

CATEGORY_NAME

Name of the category

OPEN_STATUS

Specifies the status of the incident.

Possible values:

• 1: Open incidents

• 0: Closed incidents

CLOSED_DATE

The date when the incident is closed

INCIDENT_ID

The unique RAW ID of an incident

TARGET_GUID

The unique ID of a target (can be null)

OPEN_STATUS

Specifies the status of the incident.

Possible values:

• 1: Open incidents

• 0: Closed incidents

CLOSED_DATE

The date when the incident is closed

INCIDENT_ID

The unique RAW ID of an incident

ANNOTATION_SEQ

The order ID in which the annotation is added

ANNOTATION_MSG

The annotation message

ANNOTATION_DATE

The time stamp when the annotation is made

ANNOTATION_TYPE

The type of the annotation, that is, whether it is user or system generated.

Possible values:

• USER

• SYSTEM

ANNOTATION_USER

The user that added the annotation. If the annotation is system-generated, then this value is set to "-" .

OPEN_STATUS

Specifies the status of the incident.

Possible values:

• 1: Open incidents

• 0: Closed incidents

CLOSED_DATE

The date when the incident is closed

EVENT_SEQ_ID

The unique RAW ID of an event sequence

EVENT_ID

The unique RAW ID of the latest event in the sequence

EVENT_CLASS

The event class to which this event belongs

SEVERITY

The severity of the event

LAST_ANNOTATION_SEQ

The sequence ID of the last annotation entered for this sequence

MSG

The event message

EVENT_NAME

The internal event name describing the nature of the events

INCIDENT_ID

The incident ID to which this event belongs (if any)

INCIDENT_NUM

The end-user readable number or ID for the incident

TARGET_GUID

The target GUID to which the events of the sequence belong. If the sequence is not related to any target, then this value is set to NULL.

SOURCE_OBJ_TYPE

The source object or entity type to which the events of the sequence belong. Default value is NULL

SOURCE_OBJ_ID

The source object or entity GUID to which the events of the sequence belong. Default value is NULL

OPEN_STATUS

The status of the event sequence. The event sequence is considered open if the severity of the last event is a non-clear severity.

Possible values:

• 1: Open

• 0: Closed

CLOSED_DATE

The date when the event is marked as closed, that is, when the event sequence is cleared

CREATION_DATE

The date the event sequence was created

LAST_UPDATED_DATE

The date when this event sequence was last updated

EVENT_SEQ_ID

The unique RAW ID of the event sequence

EVENT_ID

The unique RAW ID of the event

SIGNATURE_ID

The ID of the unique signature of raw events that is used to correlate all raw events to a sequence

EVENT_CLASS

The event class to which this event belongs

SEVERITY

The severity of the raw event

LAST_ANNOTATION_SEQ

The sequence ID of the last annotation entered for this sequence

MSG

The event message

EVENT_NAME

The internal event name describing the nature of the events

INCIDENT_ID

The incident ID to which this event belongs (if applicable)

INCIDENT_NUM

The end-user readable number or ID for the incident

TARGET_GUID

The target GUID to which the event belongs. If the sequence is not related to any target, then this value is set to NULL.

SOURCE_OBJ_TYPE

The source object or entity type to which the event belongs. Default value is NULL

SOURCE_OBJ_ID

The source object or entity GUID to which the event belongs. Default value is NULL

OPEN_STATUS

The status of the event sequence. The event sequence is considered open if the severity of the last event is a non-clear severity.

Possible values:

• 1: Open

• 0: Closed

CLOSED_DATE

The date when the event is marked as closed, that is, when the event sequence is cleared

REPORTED_DATE

The date when the event was reported

EVENT_SEQ_ID

The unique RAW ID of an event sequence

EVENT_INSTANCE_ID

The unique RAW ID of an event instance

ANNOTATION_SEQ_NUM

The order ID in which the annotations is added

ANNOTATION_DATE

The time stamp when the annotation is made

ANNOTATION_TYPE

The type of the annotation, that is, whether it is user or system generated.

Possible values:

• USER

• SYSTEM

ANNOTATION_USER

The user which added the annotation

ANNOTATION_MSG

The annotation message

OPEN_STATUS

The status of the event sequence. The event sequence is considered open if the severity of the last event is a non-clear severity.

Possible values:

• 1: Open

• 0: Closed

CLOSED_DATE

The date when the event is marked as closed, that is, when the event sequence is cleared

PROBLEM_ID

The unique RAW ID of the problem

PROBLEM_NUM

The end-user visible ID of the problem

SUMMARY_MSG

Summary message of the problem

SEVERITY

The severity of the problem

IS_ESCALATED

Specifies whether the issue is escalated.

Possible values:

• 1: Yes

• 0: No

ESCALATION_LEVEL

If the problem is escalated, then this value specifies the escalation level. This value can be between level 1 and level 5.

PRIORITY

The priority level of the incident.

Possible values:

• None

• Urgent

• Very High

• High

• Medium

• Low

RESOLUTION_STATE

The resolution state of the issue

OWNER

The owner of the issue. If there is no owner, then this value is "-".

IS_ACKNOWLEDGED

Specifies whether the problem is acknowledged.

Possible values:

• 1: Yes

• 0: No

IS_SUPPRESSED

Specifies whether the problem is suppressed.

Possible values:

• 1: Yes

• 0: No

LAST_ANNOTATION_SEQ

The sequence ID of the last annotation entered for this issue

CREATION_DATE

The date the problem was created

LAST_UPDATED_DATE

The date when this problem was updated last

INC_COUNT

The number of incidents associated with this problem

OPEN_STATUS

Specifies the status of the problem.

Possible values:

• 1: Open

• 0: Closed

CLOSED_DATE

The date when the problem is closed (if it is closed)

TARGET_GUID

The unique ID of a target (can be null). This value is set only when all the incidents in the problem belong to the same target or source object combination.

It is set to null when the incidents belong to multiple sources.

Note: For this release, problems can be associated with a single target only

PROBLEM_KEY

Unique signature of this problem

SR_ID

ID of the service request associated with this problem, if any

BUG_ID

ID of the bug associated with this problem, if any

PROBLEM_ID

The unique RAW ID of a problem

ANNOTATION_SEQ

The order ID in which the annotations is added

ANNOTATION_MSG

The annotation message

ANNOTATION_DATE

The time stamp when the annotation is made

ANNOTATION_TYPE

The type of the annotation, either user or system generated. Valid values are 'USER' or 'SYSTEM'

ANNOTATION_USER

The user which added the annotation

OPEN_STATUS

Specifies the status of the problem.

Possible values:

• 1: Open

• 0: Closed

CLOSED_DATE

The date when the problem is closed

TARGET_TYPE

Type of target for this metric

TARGET_NAME

The name of the target

VENDOR_NAME

The name of the hardware vendor

FREQUENCY_IN_MHZ

The frequency measured in MHz

ECACHE_IN_MB

The size of the ecache measured in MB

IMPL

The details of the implementation

REVISION

The revision details

MASK

The mask details

INSTANCE_COUNT

This is a count of the CPU devices

NUM_CORES

The number of cores per physical CPU

IS_HYPERTHREAD_ENABLED

Defines whether hyperthreading is enabled for this physical CPU (set to 0 or 1)

SIBLINGS

Total number of logical processors for this physical CPU

SNAPSHOT_GUID

The globally unique identifier of the snapshot

TARGET_GUID

The globally unique identifier of the target

LAST_COLLECTION_TIMESTAMP

The date-time of the last collection

TARGET_TYPE

Type of target for this metric

TARGET_NAME

The name of the target

HOST_NAME

The name of the host

NAME

The NIC name

INET_ADDRESS

The NIC address

MAX_TRANSFER_UNIT

The NIC maximum transfer unit

BROADCAST_ADDRESS

The NIC broadcast address

FLAGS

The NIC flags

MASK

The NIC masks

MAC_ADDRESS

The NIC MAC address

MAC_ADDRESS_STD

The STD NIC MAC address

DHCP_ENABLED

Defines whether DHCP is enabled (set to Y or N)

HOST_ALIASES

The NIC host aliases

INET6_ADDRESSES

The Ipv6 addresses of the host

SNAPSHOT_GUID

The globally unique identifier of the snapshot

TARGET_GUID

The globally unique identifier of the target

LAST_COLLECTION_TIMESTAMP

The date-time of the last collection

IS_PHYSICAL

Defines whether the NIC is physical or not (set to 0 or 1)

TARGET_TYPE

Type of target for this metric

TARGET_NAME

The name of the target

BOND_NAME

The name of the bond

PRIMARY_SLAVE

The primary slave of the bond

SECONDARY_SLAVES

The secondary slaves of the bond

BOND_MODE

The mode of the bond, for example, Balanced

OPTIONS

The options used when the bond is created

SNAPSHOT_GUID

The globally unique identifier of the snapshot

TARGET_GUID

The globally unique identifier of the target

LAST_COLLECTION_TIMESTAMP

The date-time of the last collection

TARGET_TYPE

Type of target for this metric

TARGET_NAME

The name of the target

VENDOR_NAME

The vendor name

NAME

The name of the IO device

FREQ_IN_MHZ

The frequency in MHz

BUS

The bus type

REVISION

The revision of the IO device

INSTANCE_COUNT

This is a count of the IO devices that have the same vendor name, name, and so on

SNAPSHOT_GUID

The globally unique identifier of the snapshot

TARGET_GUID

The globally unique identifier of the target

LAST_COLLECTION_TIMESTAMP

The date-time of the last collection

TARGET_NAME

Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.

TARGET_TYPE

The type of the target. Types of targets may include databases, hosts, web servers, applications, or Application Servers. The definer of the collection definition at the Management Agent defines the target type. The target type defines the set of metrics that are collected for a managed target within the Management Repository.

TARGET_GUID

The unique global identifier for the target.

TYPE_VERSION

The target type meta version of the metadata set. Metadata versions may be updated when applying patches or upon new releases of Enterprise Manager Grid Control.

TYPE_QUALIFIER1-5

Up to five qualifiers can be used to distinguish different metric definitions based on different system configurations. Example qualifier entries may include operating system version, database version, or RAC configuration.

EMD_URL

The URL address of the Management Agent that is managing the target

TIMEZONE_REGION

The time zone region in which the target operates

DISPLAY_NAME

User-friendly name for the target

HOST_NAME

Name of the host where the target is running. For composite targets or targets that span a host, this column will be NULL.

LAST_METRIC_LOAD_TIME

Timestamp when information for this target was last loaded into the Management Repository. If metrics have not been loaded into the Management Repository for the target, this column will be NULL.

TYPE_DISPLAY_NAME

User-friendly name of the target type

TARGET_NAME

Name of the target where the metric was collected. The target name uniquely identifies a managed target within the Management Repository. The target name typically contains the name of the managed entity that was provided by the system or database administrator.

TARGET_TYPE

The target type defines the set of metrics that are applicable for the target

TARGET_GUID

The unique global identifier for the target

TYPE_VERSION

The target type meta version of the metadata set. Metadata versions may be updated when applying patches or upon new releases of Enterprise Manager Grid Control.

TYPE_QUALIFIER1-5

Up to five qualifiers can be used to distinguish different metric definitions based on different system configurations. Example qualifier entries may include operating system version, database version, or RAC configuration.

METRIC_NAME

The name of the metric that is being defined

METRIC_COLUMN

For table metrics, the metric column contains the name of the column in the table that is being defined. If the metric that is being defined is not a table metric, the value in this column is a single space.

For example, if a table describing the MGMT$TARGET_TYPE view is to be defined as a table metric, Column Name, Data Type, and Description would be metric columns.

KEY_COLUMN

For table metrics, the key column contains the name of the column in the table that represents the primary key. Values in this column must uniquely identify rows in the table. If the metric that is being defined is not a table metric, the value in this column is a single space;

For example, the Column Name would be the key column if this table describing the MGMT$TARGET_TYPE view was being defined as a table metric.

METRIC_TYPE

A DECODE of the internal numeric type of the metric that is being defined. This column will contain one of the following values:

• Number

• String

• Table

• Raw

• External

• Repository Metric

METRIC_LABEL

A intuitive display name for the metric that is being defined

COLUMN_LABEL

For table metrics, the column label contains a user understandable display name for the metric column

DESCRIPTION

A description of the metric that is being defined

DESCRIPTION_NLSID

The NLSid of the description of the metric

UNIT

The unit of the metric that is being defined

UNIT_NLSID

The NLSid of the unit of the metric being defined

SHORT_NAME

This is a shortened version of the metric display name for the "dense" UI concept

SHORT_NAME_NLSID

The NLSid of the short name of the metric being defined

TARGET_TYPE

The target type defines the set of metrics that are applicable for the target

TYPE_DISPLAY_NAME

User-friendly name of the target type

TARGET_TYPE_GUID

The unique global identifier (GUID) of the target type

MAX_TYPE_META_VER

The maximum version of the target type stored in the Management Repository