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

Querying Log Files After a Particular Time

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

To query events logged after a certain time

• Enter:

  query query_name where time from "YYYY-MM-DD HH:MM:SS"

  where:

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

  "YYYY-MM-DD HH:MM:SS" = Date and time of interest.

  NOTE:  The exact time portion of the date and time parameter, HH:MM:SS, can be omitted. In this case, the date's base time defaults to 00:00:00.

An example of this query command is as follows:

query timeqry where time from "2003-10-01 16:30:00"

This command queries log files created after October 1, 2003 at 4:30 PM, and saves the output to memory under the name timeqry.

This command is useful in combination with other parameters to filter results. See Querying Log Files Using Multiple Conditions for further information.