Sponsored Content
Top Forums Shell Programming and Scripting To check timestamp in logfile and display lines upto 3 hours before current timestamp Post 302911298 by srkmish on Thursday 31st of July 2014 03:40:28 AM
Old 07-31-2014
To check timestamp in logfile and display lines upto 3 hours before current timestamp

Hi Friends,

I have the following logfile. Currently time in india is 07/31/2014 12:33:34 and i have the following content in logfile. I want to display only those entries which contain string 'Exception' within last 3 hours. In this case, it would be the last line only

Code:
[7/30/14 4:59:30 Exception Found
[7/30/14 5:18:55 Result is OK
[7/30/14 8:45:22 Exception found
[7/30/14 9:22:26 Exception found
[7/31/14 11:55:66 Exception found


I can get the timestamp in logfile as
Code:
awk '/Exception/ {print $1,$2}' trial.txt | sed 's/^.//' which gives below results

7/30/14 4:59:30
7/30/14 8:45:22
7/30/14 9:22:26
7/31/14 11:55:66

And i can get current timestamp as
Code:
date +"%m/%d/%Y %T"
07/31/2014 12:33:34

So, how can i compare current timestamp with timestamp in log file and display 'Exception' entries until last 3 hours.

---------- Post updated at 02:40 AM ---------- Previous update was at 02:07 AM ----------

I am trying this command. But it is throwing exception saying syntax error. What am i doing wrong?

Code:
awk '/Exception/ if ($1,$2 > $(date +"%m/%d/%Y %T" -d  "3 hour ago")) print $1,$2 ' trial.txt  | sed 's/^.//'


Last edited by Don Cragun; 07-31-2014 at 05:45 AM.. Reason: Add missing CODE tags.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Compare current time to timestamp on a file

I'm trying to compare 2 dates between current time and the timestamp on a file. The date format is mmdd Both return Apr 1 but when using if statement line 11: Apr 1: command not found error is returned #!/bin/sh log="DateLog" Current_Date=`date +%b%e` Filepmdate=`ls -l /file.txt |... (1 Reply)
Discussion started by: cillmor
1 Replies

2. AIX

Change specific (not current) date to timestamp

Hello to all. I work at AIX system without perl installed and I am restricted user, so I am limited to bash. In script that I am writing, I have to read line from file and transform date that I found inside to Unix timestamp. Line in file look something like this: Tue Mar 29 06:59:00... (5 Replies)
Discussion started by: Hyperborejac
5 Replies

3. Shell Programming and Scripting

How to retrieve the current timestamp?

I am doing this in my script .. currenttimestamp=`db2 "select current timestamp from SYSIBM.SYSDUMMY1 with ur"` echo s $currenttimestamp but this is how its shows s 1 -------------------------- 2011-04-18-12.43.25.345071 1 record(s) selected. How can I just get the timestamp... (6 Replies)
Discussion started by: mitr
6 Replies

4. UNIX for Dummies Questions & Answers

How to compare a file by its timestamp and store in a different location whenever timestamp changes?

Hi All, I am new to unix programming. I am trying for a requirement and the requirement goes like this..... I have a test folder. Which tracks log files. After certain time, the log file is getting overwritten by another file (randomly as the time interval is not periodic). I need to preserve... (2 Replies)
Discussion started by: mailsara
2 Replies

5. Shell Programming and Scripting

Check if a date field has date or timestamp or date&timestamp

Hi, In a field, I should receive the date with time stamp in a particular field. But sometimes the vendor sends just the date or the timestamp or correctl the date&timestamp. I have to figure out the the data is a date or time stamp or date&timestamp. If it is date then append "<space>00:00:00"... (1 Reply)
Discussion started by: machomaddy
1 Replies

6. Shell Programming and Scripting

Check/Parse log file's lines using time difference/timestamp

I was looking at this script which outputs the two lines which differs less than one sec. #!/usr/bin/perl -w use strict; use warnings; use Time::Local; use constant SEC_MILIC => 1000; my $file='infile'; ## Open for reading argument file. open my $fh, "<", $file or die "Cannot... (1 Reply)
Discussion started by: cele_82
1 Replies

7. HP-UX

Comparing the timestamp of the file to current time

I have a file like this -rwxr-xr-x 1 rewq other 168 Jan 13 07:05 check_files.sh I want to compare (check_files.sh time) with the current time to see if its is older than 2 hours or not if it is not older than 2 hrs then do something.can someone help me on this?.I dont... (7 Replies)
Discussion started by: haadiya
7 Replies

8. Shell Programming and Scripting

AIX : Need to convert UNIX Timestamp to normal timestamp

Hello , I am working on AIX. I have to convert Unix timestamp to normal timestamp. Below is the file. The Unix timestamp will always be preceded by EFFECTIVE_TIME as first field as shown and there could be multiple EFFECTIVE_TIME in the file : 3.txt Contents of... (6 Replies)
Discussion started by: rahul2662
6 Replies

9. Shell Programming and Scripting

Display lines between timestamp

Hi Gurus, I have a software which logs event in the log file and it has become to big to search into it. I want to display all the lines from the log files between <Jul 21, 2016 3:30:37 PM BST> to <Jul 21, 2016 3:45:37 PM BST> that is 15 min data . Please help Use code tags, thanks. (10 Replies)
Discussion started by: guddu_12
10 Replies

10. Shell Programming and Scripting

Grep lines between last hour timestamp and current timestamp

So basically I have a log file and each line in this log file starts with a timestamp: MON DD HH:MM:SS SEP 15 07:30:01 I need to grep all the lines between last hour timestamp and current timestamp. Then these lines will be moved to a tmp file from which I will grep for particular strings. ... (1 Reply)
Discussion started by: nms
1 Replies
Mojo::Exception(3pm)					User Contributed Perl Documentation				      Mojo::Exception(3pm)

NAME
Mojo::Exception - Exceptions with context SYNOPSIS
use Mojo::Exception; my $e = Mojo::Exception->new; DESCRIPTION
Mojo::Exception is a container for exceptions with context information. ATTRIBUTES
Mojo::Exception implements the following attributes. "frames" my $frames = $e->frames; $e = $e->frames($frames); Stacktrace. "line" my $line = $e->line; $e = $e->line([3, 'foo']); The line where the exception occured. "lines_after" my $lines = $e->lines_after; $e = $e->lines_after([[1, 'bar'], [2, 'baz']]); Lines after the line where the exception occured. "lines_before" my $lines = $e->lines_before; $e = $e->lines_before([[4, 'bar'], [5, 'baz']]); Lines before the line where the exception occured. "message" my $message = $e->message; $e = $e->message('Oops!'); Exception message. "raw_message" my $message = $e->raw_message; $e = $e->raw_message('Oops!'); Raw unprocessed exception message. "verbose" my $verbose = $e->verbose; $e = $e->verbose(1); Activate verbose rendering, defaults to the value of "MOJO_EXCEPTION_VERBOSE" or 0. METHODS
Mojo::Exception inherits all methods from Mojo::Base and implements the following new ones. "new" my $e = Mojo::Exception->new('Oops!'); my $e = Mojo::Exception->new('Oops!', $files, $name); Construct a new Mojo::Exception object. "throw" Mojo::Exception->throw('Oops!'); Mojo::Exception->throw('Oops!', $files, $name); Throw exception with stacktrace. "to_string" my $string = $e->to_string; my $string = "$e"; Render exception with context. "trace" $e = $e->trace; $e = $e->trace(2); Store stacktrace. SEE ALSO
Mojolicious, Mojolicious::Guides, <http://mojolicio.us>. perl v5.14.2 2012-09-05 Mojo::Exception(3pm)
All times are GMT -4. The time now is 06:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy