Siebel System Monitoring and Diagnostics Guide > Querying System Log Files > Creating and Saving Log File Analyzer Queries >

Querying Log Files of a Particular Severity


Use the following procedure to search log files for events of a specific severity. See Creating and Saving Log File Analyzer Queries for other options of the Log File Analyzer (LFA) query command.

Events are categorized from 0 to 5, 0 being the most severe or critical. For further information on event severity and event logging, see Siebel System Administration Guide.

This command includes events of the indicated severity as well as events of a greater severity. For example, if you query for a severity of 2, events of severity 0 and 1 are also included in the output.

To query for events associated with a particular severity

  • Enter:

    query query_name where loglevel = severity_value

    where:

    query_name = Query command output stored in memory under this name.

    severity_value = Severity value of interest (integer value from 0 to 5).

An example of this query command is as follows:

query svtqry where loglevel = 1

This command queries log files for events associated with a severity of 0 and 1 and saves the output to memory under the name svtqry.

Siebel System Monitoring and Diagnostics Guide Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.