Siebel System Monitoring and Diagnostics Guide > Querying System Log Files >

Filtering Log File Analyzer Queries


Use the show command to further refine the output of saved queries. See Creating and Saving Log File Analyzer Queries for information on querying log files and creating saved queries.

For information on displaying a saved query or multiple saved queries, see Displaying Saved Query Output.

To filter saved query information

  • Enter:

    show query_name where_clause

    where:

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

    where_clause = Where clause used to filter display results using key words.

For a list of key words available for use with the Log File Analyzer (LFA), see Listing Query Command Key Words. The syntax of where clauses used with the show command are similar to those used with the query commands. Review Creating and Saving Log File Analyzer Queries for further information.

Use multiple where clause conditions and the logical operators AND and OR to further filter an individual or multiple saved queries. See Examples of Filtered Saved Queries for examples of these types of commands.

To save filtered output from the show command, save the results to a text file. See Saving Log File Analyzer Output to Text Files for description of this task. Filtered output from the show command cannot be saved in memory.

Examples of Filtered Saved Queries

The following examples display the type of filtering available on saved queries using the show command.

  • show aquery where user = asmith

    This command filters the saved query aquery for information specific to user asmith.

  • show aquery where user = asmith and literal = Parameter time from "2003-08-05 15:20:20" to "2003-08-05 15:30:00" > out.dat

    This command filters the saved query aquery for information on user asmith and the literal value parameter between the time of 3:20 and 3:30 PM on August 05, 2003. The command also stores the results of the filtered query to a text file named out.dat.

  • show aquery, bquery where user = asmith and literal = Parameter time from "2003-08-05 15:20:20" to "2003-08-05 15:30:00" > out.dat

    This command filters the saved queries aquery and bquery based on the same conditions in the previous bullet.

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