webMethods and Intelligent Business Operations 10.2 | Administering Mediator | Mediator Configurations | Key Performance Indicator Metrics and Run-Time Event Notifications to EDA | Monitoring Events Table
 
Monitoring Events Table
Table name: MED_EVENT_MON
Column
Data Type
Description
EVENT_PK
NUMBER
Sequential primary key. Constraint required.
SESSION_ID
VARCHAR2(128)
Session token. This is the IS session token or a GUID if the token is missing from the message context. If this is a near real-time event, the session ID for the service invocation is included in the event, however, if this is an aggregated event produced at the end of a policy's interval, no single service invocation is associated with the event, so no session is included.
SERVICE_NAME
VARCHAR2(256)
Virtual service name. Constraint required.
SERVICE_VERSION
VARCHAR2(256)
Version of a virtual service or an API. By default, for every version of a virtual service a system version number is generated. At the same time, user can also provide a version number which is set as a user version.
Note: If the version specified by a user is available for the virtual service then this column contains the user version else this column contains the system version.
OPERATION_NAME
VARCHAR2(256)
Virtual service operation hosting the invocation. If this is a near real-time event, the virtual service operation name for the service invocation is included in the event, however, if this is an aggregated event produced at the end of a policy's interval, no specific operation name is associated with the event. Constraint required.
NATIVE_ENDPOINT
VARCHAR2(4000)
Native service endpoint to which the request has been routed.
BINDING_NAME
VARCHAR2(256)
This column is currently not used. It appears as NULL or as an empty string.
TARGET_NAME
VARCHAR2(64)
The target name specified in the Integration Server Administrator's Solutions > Mediator > Administration > CentraSite Communication page.
CONSUMER_NAME
VARCHAR2(128)
Comma-separated consumer names identified based on the policy that triggered the event.
CONSUMER_IP
VARCHAR2(64)
Consumer IP.
CONSUMER_ID
VARCHAR2(256)
The system generated consumer application ID.
EVENT_CREATE_TS
TIMESTAMP(6)
Timestamp when the event was created by the virtual service runtime. This is not the time the database performed its insert (for example, this is calculated by the Mediator policy engine and is not a database function).
EVENT_SOURCE
VARCHAR2(80)
This column is not currently used.
ALERT_SOURCE
VARCHAR2(256)
The name of the policy that contains the Monitor Service Performance or Monitor Service Level Agreement action that produced the event.
ALERT_TYPE
VARCHAR2(128)
The value Monitor means the event was produced by the Monitor Service Performance action. The value Sla means the event was produced by the Monitor Service Level Agreement action or the Throttling Traffic Optimization action.
ALERT_DESC
VARCHAR2(256)
The alert message defined in the run-time policy action.
MONITOR_ATTR
VARCHAR2(256)
The expression rule that was breached in the run-time policy. If multiple conditions are specified for the policy, only the first expression is included here.
EVENT_USERNAME
VARCHAR2(80)
The Integration Server user that executed the service. If the user cannot be determined for the service request, Integration Server uses a default unprivileged user. So this field must never be NULL for near real-time events. However, if this is an aggregated event produced at the end of a policy's interval, no specific user name is associated with the event.

Copyright © 2015- 2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release