9.7.3.2 DESCRIBE ALERTHISTORY

Purpose

The DESCRIBE ALERTHISTORY command displays a list of attributes for the ALERTHISTORY object type.

Syntax

DESCRIBE ALERTHISTORY

Usage Notes

The following table lists the attributes for the DESCRIBE ALERTHISTORY command.

Table 9-3 DESCRIBE ALERTHISTORY Attributes

Attribute Description

alertAction

Recommended action to perform for this alert.

alertMessage

Brief explanation of the alert.

alertSequenceID

Unique sequence ID for the alert. When an alert changes its state, such as warning to critical or critical to clear, another occurrence of the alert is created with the same sequence number and a time stamp of the transition.

alertShortName

Abbreviated name for the alert. If the alert is based on a metric, then the short name is the same as the corresponding metric name attribute.

alertType

Type of the alert. Values are stateful or stateless.

  • Stateful alerts are automatically cleared on transition to normal.

  • Stateless alerts are never cleared. You can change the alert by setting the examinedBy attribute.

beginTime

Time stamp when an alert changes its state.

endTime

Time stamp for the end of the period when an alert changes its state.

examinedBy

Administrator who reviewed the alert.

failedMail

Intended e-mail recipient when a notification failed.

failedSNMP

Intended SNMP subscriber when a notification failed.

metricObjectName

Object, such as database server disk for which a metric threshold has caused an alert.

metricValue

Value of the metric that caused the alert.

name

Unique identifier for the alert.

notificationState

Number indicating progress in notifying subscribers to alert messages:

  • 0: never tried

  • 1: sent successfully

  • 2: retrying, up to 5 times

  • 3: 5 failed retries

sequenceBeginTime

Time stamp when an alert sequence ID is first created.

severity

Severity level. Values are clear, info, warning, or critical.

Examples

Example 9-39 shows the DESCRIBE command with the ALERTHISTORY object.

Example 9-39 Describing the ALERTHISTORY Object

DBMCLI> DESCRIBE ALERTHISTORY

         name
         alertAction
         alertMessage
         alertSequenceID
         alertShortName
         alertType
         beginTime
         endTime
         examinedBy              modifiable
         failedMail
         failedSNMP
         metricObjectName
         metricValue
         notificationState
         sequenceBeginTime
         severity

Related Topics

Parent topic: DESCRIBE