searchlookup
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.
Syntax
searchLookup table=<lookupTable>
Parameters
The following table lists the parameters used in this command, along with their description.
Parameter | Description |
---|---|
lookupTable |
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