MSG Record definition table. Also called MSGREC, or MR. This table defines which events (messages) need to be captured by Event Manager and acted upon using the associated MSG Actions. Each row is uniquely identified by its token# (opra_msg_tkn) which is incremented in the opra_ctl table for each new MR entry.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| opra_msg_tkn | integer | not null | Unique id for MR (from opra_ctl). |
| opra_msg_id | varchar(512) | not null | Message id to be matched (wildcards) |
| opra_msg_type | varchar(4) | not null | Type: MSG or CMD |
| opra_msg_enode | varchar(64) | not null | Node where the MR is applicable (list, wildcards) |
| opra_msg_calendar | varchar(12) | not null | Calendar to be used with MR. If calendar returns non-valid, MR is skipped. |
| opra_msg_wc_many | char(1) | not null | Wildcard char for many ('*' by default). |
| opra_msg_wc_sngl | char(1) | not null | Wildcard char for single char ('?' by default) |
| opra_msg_cr_id | varchar(32) | not null | User id that created MR |
| opra_msg_cr_dt | integer | not null | Date when MR was created (tmsdate) |
| opra_msg_cr_tm | integer | not null | Time when MR was created (tmsdate) |
| opra_msg_up_id | varchar(32) | not null | User id that updated MR last |
| opra_msg_up_dt | integer | not null | Date when MR was updated (tmsdate) |
| opra_msg_up_tm | integer | not null | Time when MR was updated (tmsdate) |
| opra_msg_actn_cnt | smallint | not null | Not in use |
| opra_msg_desc | varchar(256) | not null | MR description |
| opra_msg_node | varchar(64) | not null | Node where event was generated -- matched against Event node. |
| opra_msg_user | varchar(32) | not null | User id that generated event -- matched against Event user id. |
| opra_msg_scan | varchar(512) | not null | String to scan in incoming Event text (wild cards, or RE). |
| opra_msg_scan_from | integer | not null | First char in event to scan |
| opra_msg_scan_to | integer | not null | Last char to scan in Event text. |
| opra_msg_freq_cnt | integer | not null | Number of events that need to match this MR within opr_msg_freq_int seconds for the event to to be matched and trigger the actions. |
| opra_msg_freq_int | integer | not null | Interval in seconds for opra_msg_freq_cnt. |
| opra_msg_crit_prof | varchar(256) | not null | Criteria for matching (case-sensitive or regular expressions). |
| opra_msg_cont_scan | char(1) | not null | Indicator to continue to match MRs after the first match (No by default) |
| opra_msg_active | char(1) | not null | MR active: Y by default. |
| opra_msg_device | varchar(128) | not null | Device to match in incoming event |
| opra_msg_jobset | varchar(64) | not null | Jobset to match in incoming event (if generated from a JMO/Workload job). |
| opra_msg_jobname | varchar(64) | not null | Jobname to match in incoming event (if generated from a JMO/Workload job). |
| opra_msg_jobno | varchar(16) | not null | Jobno to match in incoming event (if generated from a JMO/Workload job). |
| opra_msg_jobqual | varchar(16) | not null | Jobqual to match in incoming event (if generated from a JMO/Workload job). |
| opra_msg_workstn | varchar(64) | not null | Work station to match in incoming event (if generated from a JMO/Workload job). |
| opra_msg_program | varchar(128) | not null | Program name that generated event |
| opra_msg_udata | varchar(128) | not null | User data to match against in incoming event (value of CA_USERDATA env. when th event was generated) |
| opra_msg_category | varchar(64) | not null | Category to match against in incoming event. |
| opra_msg_late | char(1) | not null | Not in use |
| opra_msg_msgnum | integer | not null | Msg number to match against in incoming event. |
| opra_msg_severity | varchar(4) | not null | Severity to match against in incoming event. |
| opra_msg_source | varchar(128) | not null | Source to match against in incoming event. |
| opra_msg_tag | varchar(256) | not null | Tag to match against in incoming event. Usually the platform such as: WNT, Solaris. |
| opra_msg_group | varchar(256) | not null | Grouping of event. Currently not in use. |
Product Name: Unicenter Network and System Management/EnterpriseManagement
Table Type: Table
Relationships:
| Primary Key | Related Table | Related Column |
| opra_act |