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
query_name where time from "YYYY-MM-DD HH:MM:SS" to "YYYY-MM-DD HH:MM:SS"
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
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
This command is useful in combination with other parameters to filter results. See Querying Log Files Using Multiple Conditions for further information.