Use the searchLookup command to retrieve contents from a lookup table. By default all fields and contents are returned.

If you use the UI to run the searchLookup command, then ensure that the time range includes the time when the lookup was created. It is recommended that you create a Saved Search for using the searchLookup command.


searchLookup  table=<lookupTable>


The following table lists the parameters used in this command, along with their description.

Parameter Description

Name of the lookup table.

For examples of using this command in typical scenarios, see:

The following example shows how to search for log records that contain the severity with value info in the table

searchlookup table = OraErrorCodes | search severity = info

The following example shows how to search for the fields in the table.

searchlookup table = OraErrorCodes | fields -*, errid, msg