System Monitoring and Diagnostics Guide for Siebel eBusiness Applications > Querying System Log Files > Creating and Saving LFA Queries >

Querying Log Files Using Multiple Conditions

See the following examples of combination query commands using multiple conditions. See Creating and Saving LFA Queries for a list of individual query command conditions and their use.

The logical AND and OR operators are also applicable to the Log File Analyzer (LFA) query command. To add clarity to multiple condition commands, group condition sets in parentheses.

• query litasqry where (literal = Parameter) or (user = asmith)

  This command queries log files for the literal Parameter or the user asmith. It saves the output to memory under the name litasqry.

• query aqry where literal = Parameter and literal = SBL-GEN

  This command queries log files for the literal Parameter and the literal SBL-GEN. It saves the output to memory under the name aqry.

• query asaugqry where user = asmith time from 2003-08-05

  This command queries log files for the user asmith after August 05, 2003. It saves the output to memory under the name asaugqry.

• query asaugqry where user = asmith time from "2003-08-05 15:20:00" to "2003-08-05 15:30:00"

  This command queries log files for the user asmith during the ten minute time period between 3:20 PM and 3:30 PM on August 05, 2003. It saves the output to memory under the name asaugqry.