Hello

I have logfiles like below.
I want the get the date of the oldest log in this directory and compare it with current date.
Time of the each log can be seen before ".Z" prefix.


I have written the following piece of code. However, it is not working for the following case:

LOGDAY=20101129
TODAY= 20101201

Difference is 72, which is not correct, since these are dates.

How can I fix this?





ls /archive_store

akprd_uwprod_0000015702_1_201011121305.Z
akprd_srprod_0000099047_1_201011121305.Z
...
...
...



#!/bin/sh


DIR=/archive_store
TODAY=`date '+%Y%m%d'`

cd ${DIR}

file=$(ls -1t ${DIR}/ak* | tail -1)
LOGDAY=`echo "$file" | perl -ne 's/.*_(\d{8})[^_]*\.Z$/\1/; print;'`

if [[ `expr $TODAY - $LOGDAY` -lt 4 ]]; then
echo "Please check logs..."
fi

Maybe you should use 'stat -c %Y <file>' to obtain the last modified time of the file in 'seconds since Epoch' rather than going by the name of the file, then you can use subtraction.

Try modify you script like:

Hi

Thanks for your help.However your sugesstions didint help maybe because the os is hp unix.

mac.tieu:

$ TODAY=`date --date="4 days ago" '+%Y%m%d'`
date: illegal option -- -
Usage: date [-u] [+format]
date [-u] [mmddhhmm[[cc]yy]]
date [-a [-]sss.fff]



kbp:

stat -c %Y akprd_uwprod_0000015702_1_201011121305.Z
sh: stat: not found.

Sorry, didn't realise there was no stat cmd on HPUX. You can get the same info via perl if you like ... http://h21007.www2.hp.com/portal/sit...10275d6e10RCRD

cheers

Hi kbp,

Many thanks for your assistance.
Just for the expriement,I tried to subtract two dates however, I am still getting syntax error.



touch foo

a1=`perl -e 'print (scalar localtime((stat($ARGV[0]))[9]),"\n");' foo`
a2=`date`

echo $a1
Thu Nov 18 08:42:43 2010

echo $a2
Thu Nov 18 08:49:54 NZDT 2010


echo `expr $a2 - $a1`

expr: Syntax error

This will give you the age of a file (the amount of time since it was most recently modified) in seconds:
This will give you the same datum, but in days, not seconds:

Logically, one could split he dates as yyy mm dd, treating each as a "digit" and subtract lower to higher digits using render/borrow. The problem would be to figure out whether to borrow 31, 30, 29 or 28 as the case may be.

TODAY= 2010 12 01
LOGDAY=2010 11 29

Since 11 is less than 29,borrow a month (30 days in November). This becomes


TODAY= 2010 11 31
LOGDAY=2010 11 29

ie 2 days.

The problem is how to generalise it and test all the border cases.

Thanks wje_lq and Anantha

So, how just to modify my code to suit my needs?

#!/bin/sh

DIR=/archive_store

cd ${DIR}

file=$(ls -1t ${DIR}/ak* | tail -1)
LOGDAY=`echo "$file" | perl -e 'print((-M $ARGV[0]),"\n");'`

if [[ $LOGDAY -lt 4 ]]; then
echo "Please check logs..."
fi



Somehow, below statement doesnt return any value.

LOGDAY=`echo "$file" | perl -e 'print((-M $ARGV[0]),"\n");'`

There are two remaining things to do. The first is that the Perl stuff I suggested took the filename as a "command line" parameter, not on standard input. So you'd have to change this:
to something like this:
And since bash arithmetic works best with integers, you'd want to throw away the fractional part of the value, so do something like this:
Play with it and see what you get.

1 members found this post helpful.

Yay, it worked !!

Many thanks for you assitance wje_lq