Table OV_MS_Message
In HPOM for Windows, all active and acknowledged messages are stored in one table, OV_MS_Message, for faster acknowledge and unacknowledge operations.
|
Column Name |
Con- |
Column Type |
Description |
|
Id |
nvarchar(36) |
Key field to identify the message. |
|
|
OriginalId |
|
nvarchar(36) |
Contains the original message ID when the field "Id" was changed (for example, by the message stream interface). |
|
ConditionId |
nvarchar(36) |
Field to identify the condition matching the message. |
|
|
State |
I |
int(4) |
The current state of
the message.
Possible values:
1 : Unknown
2 : Not owned by
anyone
3 : Owned
4 : Acknowledged
5 : Node deleted
|
|
TimeOfStateChange |
|
int(4) |
Time when the last
state change occurred.
Format: in seconds
since 00:00 GMT on 1 Jan 1970
|
|
TimeOfStateChangeTimeStamp |
|
datetime(8) |
Can be used for queries
instead of TimeOfStateChange.
Format: YYYY-MM-DD
HH:MM:SS.ttt
|
|
UserOfStateChange |
|
nvarchar(36) |
String of the user that was responsible for the last state change. |
|
Nodename |
nvarchar(36) |
UUID of the nodename from which the message was sent. |
|
|
AgentId |
|
nvarchar(36) |
Contains the ID of the agent. |
|
TimeCreated |
|
int(4) |
Time at which the
message was created on the agent.
Format: in seconds
since 00:00 GMT on 1 Jan 1970
|
|
TimeCreatedTimeStamp |
|
datetime(8) |
Can be used for queries
instead of TimeCreated.
Format: YYYY-MM-DD
HH:MM:SS.ttt
|
|
AgentTimeZoneOffset |
|
int(4) |
Contains the time offset of the agent time zone to GMT. |
|
TimeReceived |
I |
int(4) |
Time at which the message was created on the server. If duplicate detection is enabled and there are duplicates, this field contains the time at which the last duplicate arrived on the server. |
|
SequenceNbr |
I |
largeint(8) |
Used internally to improve the performance of large queries. |
|
TimeReceivedTimeStamp |
|
datetime(8) |
Can be used for queries
instead of TimeReceived.
Format: YYYY-MM-DD
HH:MM:SS.ttt
|
|
TimeFirstReceived |
|
int(4) |
If duplicate detection is enabled, the field contains the time at which the message was received the first time. If it is disabled, TimeReceived and TimeFirstReceived contain the same data. |
|
TimeFirstReceivedTimeStamp |
|
datetime(8) |
Can be used for queries
instead of TimeFirstReceived.
Format: YYYY-MM-DD
HH:MM:SS.ttt
|
|
NumberOfDuplicates |
N |
int(4) |
If duplicate detection is enabled, it contains the number of duplicates of the current message. Otherwise, it is 0. |
|
NumberOfStoredDuplicates |
N |
int(4) |
Number of duplicate annotations stored with the message. |
|
MessageGroup |
N |
nvarchar(32) |
MessageGroup attribute of the message. |
|
Object |
N |
nvarchar(254) |
Object attribute of the message. |
|
Application |
N |
nvarchar(254) |
Application attribute of the message. |
|
Type |
N |
nvarchar(254) |
Defines the type of a message. This attribute is used to define filters for the message stream interface. |
|
ServiceId |
N |
nText(16) |
String that defines the service in the service tree that is affected by the message. In the Service ID, the parameters (for example, <$MSG_NODE_ID) are already replaced with the values. |
|
OriginalServiceId |
N |
nText(16) |
Contains the Service ID without parameter replacement. |
|
Severity |
|
smallint(2) |
Severity attribute of
the message.
Possible values:
1 : Unknown
2 : Normal
4
: Warning
8 : Minor
16 : Major
32 : Critical
|
|
LogOnly |
|
tinyint(1) |
Message was sent as
log-only to the management server. It is stored immediately as a
history message with message state=4.
Possible values:
0 : No
1 : Yes
|
|
IsProxied |
N |
tinyint(1) |
Flag is 1 if the agent node is different from the node on which the problem occurred. |
|
Unmatched |
|
tinyint(1) |
Message does not match
any condition.
Possible values:
0 : No
1 : Yes
|
|
AutoActionState |
|
smallint(2) |
Status of the automatic
action.
Possible values:
2 : Failed
8 : Started
9 : Finished
11 : Defined
12 : No action
|
|
AutoActionCreateAnnotation |
|
tinyint(1) |
Automatic action
generates annotation.
Possible values:
0 : No
1 : Yes
|
|
AutoActionDoAcknowledge |
|
tinyint(1) |
Automatic action
acknowledges message.
Possible values:
0 : No
1 : Yes
|
|
OperatorActionState |
|
smallint(2) |
Status of the
operator-initiated action.
Possible values:
2 : Failed
8 : Started
9 : Finished
11 : Defined
12: No action
|
|
OperatorActionCreateAnnotation |
|
tinyint(1) |
Operator-initiated
action generates annotation.
Possible values:
0 : No
1 : Yes
|
|
OperatorActionDoAcknowledge |
|
tinyint(1) |
Operator-initiated
action acknowledges message.
Possible values:
0 : No
1 : Yes
|
|
CreateTroubleTicket |
|
tinyint(1) |
Generate trouble ticket
for the message.
Possible values:
0 : No
1 : Yes
|
|
AcknowledgeAfterTroubleTicket |
|
tinyint(1) |
Acknowledge message
after generation of the trouble ticket.
Possible values:
0 : No
1 : Yes
|
|
DoNotification |
|
tinyint(1) |
Trigger notification
for the message.
Possible values:
0 : No
1 : Yes
|
|
InstructionType |
|
smallint(2) |
Type of
instruction
Possible values:
0 : No instruction
1 : Instruction text
|
|
InstructionId |
F |
nvarchar(36) |
Foreign key field to identify the instruction text. |
|
Source |
N |
nvarchar(128) |
Contains the name and version of the policy that created the message. |
|
SourceType |
|
int(4) |
Message source
type.
Possible values:
0
: Unknown
1
: Console
2
: Opcmsg
4
: Logfile
8
: Monitor
16
: SNMP
32
: Event correlation /
Server Message Stream
Interface
64
: Agent Message Stream
Interface
128 : External Agent Interface
256 : Scheduled
action
4096 : Internal message
8192 : Sub-Product message
|
|
NumberOfAnnotations |
N |
int(4) |
Number of annotations attached to the message. |
|
AutoActionNodeName |
|
nText(16) |
Identifies the node where the automatic action runs. |
|
AutoActionCall |
N |
nText(16) |
Program call for automatic action. |
|
OperatorActionNodeName |
|
nText(16) |
Identifies the node on which the operator-initiated action runs. |
|
OperatorActionCall |
N |
nText(16) |
Program call for operator-initiated action. |
|
InstructionParameters |
N |
nText(16) |
Instructions parameters passed to the instruction text interface. |
|
Text |
N |
nText(16) |
Message text attribute of the message. |
|
OriginalText |
N |
nText(16) |
Text that was intercepted from the agent (for example, the exact line of a log file). |
|
MessageKey |
N |
nText(16) |
Message key to identify a certain type of message. |
|
Relation |
N |
nText(16) |
Messages with message keys that are stored here are acknowledged by this message. |
|
ServiceIdHash |
N |
nvarchar(112) |
Hash value calculated from ServiceId. |
|
PrimaryNodeName |
N |
nvarchar(254) |
Clear text version of the primary node name. |
|
isExternalNode |
|
tinyint(1) |
Determines whether the
message came from an external node.
Possible values:
0 : No
1 : Yes
|
|
Sender |
N |
nvarchar(254) |
Last sender management server of a forwarded message. |
|
Origin |
N |
nvarchar(254) |
The first management server that received the forwarded message from the agent. |
|
HasCMAs |
|
tinyint(1) |
Determines whether the
message has CMAs in the OV_MS_MessageCMAs table.
Possible values:
0 : No
1 : Yes
|
P :Primary Key
I :Index
N :NULL values possible
F :Foreign Key