Events extension table (EVENTS_EXT)
The Events Extension (EVENTS_EXT) database table is used when an event triggers one or more Data Visibility Group (DVG) rules. For each DVG rule an event triggers, a supplemental entry, or row, is inserted into the EVENTS_EXT table and the EVENT_ID value is used to join the information in the two tables.
The following table describes the data fields available from the EVENTS_EXT table for IBM® Sterling Control Center Monitor reports.
| Element | Type | Description |
|---|---|---|
| ACTION_ID | varchar | Name of an action called by a rule. |
| ACTIONS_COMPLETED | bigint | Indicates if the IBM Sterling Control Center
Monitor actions
are completed. The values are: Null=Actions not completed Timestamp=Actions completed This element is used for restarts. |
| ALERT | char | Indicates if an alert was triggered. The values
are: Null=No alert 0-3=Alert severity |
| ALERT_DELETED | char | Indicates if the alert was deleted. The values
are: Null=Alert not deleted Y=Alert deleted |
| ALERT_DELETED_BY | varchar | IBM Sterling Control Center Monitor user name of the person who removed the alert. If the alert was deleted by a rule, this field will contain “unknown.” |
| ALERT_UPD_TIME | bigint | Time that the alert was updated, in Java epoch timestamp format (that is, the number of milliseconds that have elapsed since January 1, 1970). |
| DATE_TIME | varchar | Date and time that the event was generated. Format yyyy/mm/dd hh:mm:ss.msmsms. |
| DVG | varchar | Data visibility group for this event. |
| EMAIL_FLAG | bigint | This field is used by IBM Sterling Control Center
Monitor for recovery
purposes. When a rule matches an event, the associated action is executed.
If the action includes sending an e-mail, this flag updates after
the e-mail is sent. Reporting on this field is not recommended. The
values are: 0=No e-mail sent >0=E-mail sent The value is set to zero if nothing was done, but is set to the Timestamp if something was done. |
| EVENT_ID | bigint | ID number assigned by the system to each event. The EVENT_ID value can be used to find additional information associated with this event in the Events database table. |
| PART_KEY | date | The date the event was generated. The format is yyyy-mm-dd. |
| RULE_ID | varchar | Name of the rule triggered by the event. |
| RULE_INSTANCE_ID | bigint | Unique identifier for rule matching instances |
| TRAP_FLAG | bigint | Internally used by IBM Sterling Control Center
Monitor for recovery
purposes. When a rule matches an event, the associated action is executed.
If the action includes sending an SNMP trap, this flag updates after
the SNMP trap is sent. Reporting on this field is not recommended.
The values are: 0=No trap generated >0=Trap generated The value is set to zero if nothing was done, but is set to the Timestamp if something was done. |
| USER_OP_FLAG | bigint | Internally used by IBM Sterling Control Center
Monitor for recovery
purposes. When a rule matches an event, the associated action is executed.
If the action includes invoking an OS command script, this flag is
updated after invoking the OS command script. Reporting on this field
is not recommended. The values are: 0=No OS command invoked >0=OS command invoked The value is set to zero if nothing was done, but is set to the Timestamp if something was done. |