Shell Programming and Scripting

Suppose there are log entries like

16 Jul 2012 11:46:45,628 [ERROR] SendToClientService [ACTIVE] ExecuteThread: '256' for queue: 'weblogic.kernel.Default (self-tuning)': Received an unknown fault.

16 Jul 2012 11:47:45,650 [ERROR] SendToClientService [ACTIVE] ExecuteThread: '256' for queue: 'weblogic.kernel.Default (self-tuning)': CL1ESB0030S9010 [1] Error while Checking file Formats.

How to search these entries between two given timestamp?

Thanks in Advance.

Code:

sed -n '/16 Jul 2012 11:46:45,628/,/16 Jul 2012 11:47:45,650/p' file

I have tried this in below logs,

13 Jul 2012 12:00:18,566 [INFO ] SendToClientService [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)': Incoming Incoming file

13 Jul 2012 12:00:28,181 [INFO ] SendToClientService [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)': Incoming Incoming file

13 Jul 2012 12:00:30,943 [INFO ] SendToClientService [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)': Incoming Incoming file:

13 Jul 2012 12:00:43,423 [INFO ] SendToClientService [ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)': Incoming file

I gave there

sed -n '/13 Jul 2012 12:00:28,000/,/13 Jul 2012 12:00:45,650/p' file

it shows nothing. By this command its only mactthing pattern, but I need something which can search the from the starting time stamp which may not be present in the log, and same in the case of ending time stamp. so, we need to search entries between 13 Jul 2012 12:00:28,000 and 13 Jul 2012 12:00:45,650, it will display


13 Jul 2012 12:00:28,181 [INFO ] SendToClientService [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)': Incoming Incoming file

13 Jul 2012 12:00:30,943 [INFO ] SendToClientService [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)': Incoming Incoming file:

13 Jul 2012 12:00:43,423 [INFO ] SendToClientService [ACTIVE] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)': Incoming file

Hi

here is a fast and ugly but working solution in perl

Code:

 perl -ne 'BEGIN {$a="13 Jul 2012 12:00:28,000"; $b="13 Jul 2012 12:00:45,650"; $a=`date -d "$a" +%s`; $b=`date -d "$b" +%s`;} $r=`date -d "$1" +%s` if /^(.*?)\[/; print if ($r <= $b) && ($r >= $a);' file

Approximate String Matching:

Code:

sed -n '/13 Jul 2012 12:00:28/,/13 Jul 2012 12:00:45/p' file