Visit Our UNIX and Linux User Community


Pick the last one hour lines from log matching this pattern.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Pick the last one hour lines from log matching this pattern.
# 15  
Old 08-13-2013
With this input file:

Code:
****************Start Display Current Environment **********
Host OPerating Syatem is linux, version
Java version
[8/6/13 15:10:30:000 EDT] log message
[8/8/13 15:32:47:000 EDT] log message
[8/10/13 15:55:38:000 EDT] log message
[8/12/13 16:23:59:000 EDT] log message
[8/12/13 17:12:48:000 EDT] log message
[8/12/13 18:03:39:000 EDT] log message
[8/12/13 18:08:42:000 EDT] log message
[8/12/13 18:27:04:000 EDT] log message
[8/12/13 19:16:21:000 EDT] log message
[8/12/13 19:58:21:000 EDT] log message
[8/12/13 20:38:28:000 EDT] log message
[8/12/13 21:30:13:000 EDT] log message
[8/12/13 21:55:32:000 EDT] log message
[8/12/13 22:47:38:000 EDT] log message
[8/12/13 22:53:42:000 EDT] log message
[8/12/13 23:07:12:000 EDT] log message

I get this:

Code:
[8/12/13 22:47:38:000 EDT] log message
[8/12/13 22:53:42:000 EDT] log message
[8/12/13 23:07:12:000 EDT] log message

Please try you code against this file.
This User Gave Thanks to Chubler_XL For This Post:
# 16  
Old 08-13-2013
OK can you explain the code in clear that you used. So that i will try with the original log file i have.

Thanks for the help.
# 17  
Old 08-13-2013
Code:
v=$(date --date "-1 hour" +"-vY=%-y -vT=%-m -vD=%-d -vH=%-H -vM=%-M")

This builds a string with current time - 1 hour eg:
Code:
-vY=13 -vT=8 -vD=12 -vH=23 -vM=4

This is used as a command line options to awk to set the value of 5 variables Y,T,D,H and M for Year, monTh, Day, Hour, Minute.

-F '[[ /:]' set field seperator to one of [ / space and :

Now input lines are split up into fields so from [8/12/13 23:07:12:000 EDT] log message
we get $1= $2=8 $3=12 $4=13 $5=23 $6=07 $7=12

Below will set variable v if date/time is less than 1 hour ago (i.e. year is greater than current year OR year is current year and month is greater than current month OR etc)
Code:
  $4+0>Y ||
  $4+0==Y&&$2+0>T ||
  $4+0==Y&&$2+0==T&&$3+0>D ||
  $4+0==Y&&$2+0==T&&$3+0==D&&$5+0>H ||
  $4+0==Y&&$2+0==T&&$3+0==D&&$5+0==H&&$6+0>M {v=1}


And finally print line if line starts with [ and variable v is set:
/^[[]/&&v
This User Gave Thanks to Chubler_XL For This Post:

Previous Thread | Next Thread
Test Your Knowledge in Computers #355
Difficulty: Medium
BWK awk, also known as nawk, refers to the awk version by Ken Thompson.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Grep -v lines starting with pattern 1 and not matching pattern 2

Hi all! Thanks for taking the time to view this! I want to grep out all lines of a file that starts with pattern 1 but also does not match with the second pattern. Example: Drink a soda Eat a banana Eat multiple bananas Drink an apple juice Eat an apple Eat multiple apples I... (8 Replies)
Discussion started by: demmel
8 Replies

2. Shell Programming and Scripting

Sed: printing lines AFTER pattern matching EXCLUDING the line containing the pattern

'Hi I'm using the following code to extract the lines(and redirect them to a txt file) after the pattern match. But the output is inclusive of the line with pattern match. Which option is to be used to exclude the line containing the pattern? sed -n '/Conn.*User/,$p' > consumers.txt (11 Replies)
Discussion started by: essem
11 Replies

3. Shell Programming and Scripting

Pattern from a log within last hour

I want to extract a pattern from a log file within last hour. I am doing grep "pattern" filename | tail -1 It gives the last latest pattern but not within last hour. and if the pattern found in last hour, output success or else failure. (3 Replies)
Discussion started by: santosh2626
3 Replies

4. Shell Programming and Scripting

Pattern matching...of almost same lines

Hi all I am trying to process some data sample input is like this VARIABLE : T axis TDAY TIME : 02-FEB-2004 17:54 19755. VARIABLE : quality flag FILENAME : 1900054_prof.nc Z : 41 ... (3 Replies)
Discussion started by: Akshay Hegde
3 Replies

5. Shell Programming and Scripting

How to pick only the files which are generated in one hour?

Hello Masters, I need one help. I want to copy the files which are continuously generating on one server. But this would be on hourly basis. e.g. -rw-rw-r-- 1 akore akore 0 Feb 12 03:20 test1.log -rw-rw-r-- 1 akore akore 0 Feb 12 03:42 test2.log -rw-rw-r-- 1 akore akore 0 Feb 12 04:22... (2 Replies)
Discussion started by: akore83
2 Replies

6. Shell Programming and Scripting

Finding lines matching the Pattern and their previous lines in a file

Hi, I am trying to locate the occurences of certain pattern like 'Possible network disconnect' in a text file. I can get the actual lines matching the pttern using: grep -w 'Possible network disconnect' file_name. But I am more interested in getting the timing of these events which are... (7 Replies)
Discussion started by: sagarparadkar
7 Replies

7. Shell Programming and Scripting

pattern matching lines using the date, and then joining the lines

Hi Guys, Was trying to attempt the below using awk and sed, have no luck so far, so any help would be appreciated. Current Text File: The first line has got an "\n", and the second line has got spaces/tabs then the word and "\n" TIME SERVER/CLIENT TEXT... (6 Replies)
Discussion started by: eo29
6 Replies

8. Shell Programming and Scripting

counting the lines matching a pattern, in between two pattern, and generate a tab

Hi all, I'm looking for some help. I have a file (very long) that is organized like below: >Cluster 0 0 283nt, >01_FRYJ6ZM12HMXZS... at +/99% 1 279nt, >01_FRYJ6ZM12HN12A... at +/99% 2 281nt, >01_FRYJ6ZM12HM4TS... at +/99% 3 283nt, >01_FRYJ6ZM12HM946... at +/99% 4 279nt,... (4 Replies)
Discussion started by: d.chauliac
4 Replies

9. Shell Programming and Scripting

Pattern Matching and lines after that

I have a huge file and every paragraph has a date. But I want to retrieve the paras for the last two days only. So I can grep and findout the linenum for the first line since yesterday. Now I want to display everything after that line. And I am trying to do this inside a script so the linenum is a... (4 Replies)
Discussion started by: kaushys
4 Replies

10. Shell Programming and Scripting

pattern matching over more lines

hi, i have a text file wich contains following informations: 1 Record 90 in base GUJA_2008 (Created: 2008-01-14 19:00:38, Modified: 2008-01-15 18:54:33) 1 YADM_20080101_A91645666_A91645666 4 2008/01/15/ADM.ADM/20080101.ADM.ADM.A91645666G001.jff 1 Record 91 in base GUJA_2008 (Created:... (3 Replies)
Discussion started by: trek
3 Replies

Featured Tech Videos