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

Querying Log Files Within a Time Interval

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

To query events logged within a certain time interval

• Enter:

  query query_name where time from "YYYY-MM-DD HH:MM:SS" to "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 from-time defaults to 00:00:00 and the to-time defaults to 23:59:59.

An example of this query command is as follows:

query timeintqry where time from "2003-10-01 16:30:00" to "2003-10-05"

This command queries log files created between October 1, 2003 at 4:30 PM and October 5, 2003 at 11:59 PM, and saves the output to memory under the name timeintqry.

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