SHOW PROBLEM

Purpose

Show problem information for the current ADR home.

Syntax and Description

show problem [-p "predicate_string"] [-last num | -all]
    [-orderby field1, field2, ... [ASC|DSC]]

Table 17-19 describes the flags for SHOW PROBLEM.

Table 17-19 Flags for SHOW PROBLEM command

Flag Description

Flag	Description
`-p` "`predicate_string`"	Use a SQL-like predicate string to show only the incidents for which the predicate is true. The predicate string must be enclosed in double quotation marks. Table 17-20 lists the fields that can be used in the predicate string.
`-last` `num` `\|` `-all`	Shows the last `num` problems, or lists all the problems. By default, `SHOW` `PROBLEM` lists the most recent 50 problems.
`-orderby` `field1,` `field2,` `...` `[ASC\|DSC]`	Show results sorted by field in the given order (`field1`, `field2`, ...), as well as in ascending (`ASC`) and descending order (`DSC`). By default, results are shown in ascending order.

-p "predicate_string"

Use a SQL-like predicate string to show only the incidents for which the predicate is true. The predicate string must be enclosed in double quotation marks.

Table 17-20 lists the fields that can be used in the predicate string.

-last num | -all

Shows the last num problems, or lists all the problems. By default, SHOW PROBLEM lists the most recent 50 problems.

-orderby field1, field2, ... [ASC|DSC]

Show results sorted by field in the given order (field1, field2, ...), as well as in ascending (ASC) and descending order (DSC). By default, results are shown in ascending order.

Table 17-20 Problem Fields for SHOW PROBLEM

Field	Type	Description
`PROBLEM_ID`	`number`	ID of the problem
`PROBLEM_KEY`	`text(550)`	Problem key for the problem
`FIRST_INCIDENT`	`number`	Incident ID of the first incident for the problem
`FIRSTINC_TIME`	`timestamp`	Creation time of the first incident for the problem
`LAST_INCIDENT`	`number`	Incident ID of the last incident for the problem
`LASTINC_TIME`	`timestamp`	Creation time of the last incident for the problem
`IMPACT1`	`number`	Encodes an impact of this problem
`IMPACT2`	`number`	Encodes an impact of this problem
`IMPACT3`	`number`	Encodes an impact of this problem
`IMPACT4`	`number`	Encodes an impact of this problem
`SERVICE_REQUEST`	`text(64)`	Service request for the problem (entered through Support Workbench)
`BUG_NUMBER`	`text(64)`	Bug number for the problem (entered through Support Workbench)

Example

This example lists all the problems in the current ADR home:

show problem -all

This example shows the problem with ID 4:

show problem -p "problem_id=4"