Filtering the yesterdays date from log files via script.


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Filtering the yesterdays date from log files via script.
# 1  
Old 01-21-2010
Filtering the yesterdays date from log files via script.

hi All,

I have this sample text file - access.log:

Jan 18 21:34:29 root 209.151.232.70
Jan 18 21:34:40 root 209.151.232.70
Jan 18 21:34:43 root 209.151.232.70
Jan 18 21:34:56 root 209.151.232.70
Jan 18 21:35:10 root 209.151.232.70
Jan 18 21:35:23 root 209.151.232.70
Jan 18 21:36:04 root 209.151.232.70
Jan 18 21:36:57 root 209.151.232.70
Jan 18 21:37:07 root 209.151.232.70
Jan 19 03:57:54 root 61.76.46.135
Jan 19 03:57:57 root 61.76.46.135
Jan 19 03:58:00 root 61.76.46.135
Jan 19 03:58:05 root 61.76.46.135
Jan 19 03:58:08 root 61.76.46.135
Jan 19 03:58:11 joy 61.71.46.13
Jan 19 04:15:16 joy 61.71.46.13
Jan 19 04:15:19 joy 61.71.46.13
Jan 20 04:46:58 vcp 213.248.55.159
Jan 20 04:47:27 vcp 213.248.55.159
Jan 20 04:47:43 vcp 213.248.55.159
Jan 20 04:47:57 vcp 213.248.55.159
Jan 20 04:48:27 vcp 213.248.55.159
Jan 20 04:48:57 vcp 213.248.55.159
Jan 20 04:49:27 vcp 213.248.55.159
Jan 20 04:49:56 vcp 213.248.55.159

can you give me the script to filter the records only for yesterdays date ?

Appreciate much your help.
# 2  
Old 01-21-2010
What's the result of ?
Code:
date -d '1 day ago' '+%b %d %T'

If it works, you can grep that with the appropriate format in your file.
Code:
grep $(date -d '1 day ago' '+%b %d %T') access.log

# 3  
Old 01-21-2010
Code:
$ grep "^$(date -d 'yesterday' '+%b %d')" urfile
Jan 20 04:46:58 vcp 213.248.55.159
Jan 20 04:47:27 vcp 213.248.55.159
Jan 20 04:47:43 vcp 213.248.55.159
Jan 20 04:47:57 vcp 213.248.55.159
Jan 20 04:48:27 vcp 213.248.55.159
Jan 20 04:48:57 vcp 213.248.55.159
Jan 20 04:49:27 vcp 213.248.55.159
Jan 20 04:49:56 vcp 213.248.55.159

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get yesterdays Date for Input Date

Hi, I have been trying to get the yesterdays date for the Input date I pass. I know how to do for the current timestamp but how to do for the input date. Is there any way I can convert to epoch time and do manipulations and back to human readable date? Please help Thanks ... (1 Reply)
Discussion started by: abhi1988sri
1 Replies

2. Shell Programming and Scripting

Delete log files content older than 30 days and append the lastest date log file date

To delete log files content older than 30 days and append the lastest date log file date in the respective logs I want to write a shell script that deletes all log files content older than 30 days and append the lastest log file date in the respective logs This is my script cd... (2 Replies)
Discussion started by: sreekumarhari
2 Replies

3. Shell Programming and Scripting

how to get the yesterdays date?

Hi All, Can anybody help me to get the yesterdays date in perl script. My script is as below #!/bin/perl -w $yes=system("TZ=IST+24 date +%d-%m-%Y"); print "$yes\n"; script is writting the date but with 0 pls see the output below #!/bin/perl -w $yes=system("TZ=IST+24 date... (2 Replies)
Discussion started by: jam_prasanna
2 Replies

4. UNIX for Dummies Questions & Answers

Need to pull Yesterdays Date...

I tried this and it works for the most part, but if the date is 20090301, it displays 20090300. YESTERDAY=$((`date +%Y%m%d` -1)) (2 Replies)
Discussion started by: cards0622
2 Replies

5. UNIX for Dummies Questions & Answers

How to get yesterdays julian date

Hi, Was using date +%Y%j to get current julian date. Can anyone let me know how can I get y'day's julin date. Thx Did check FAQ but couldn't find anything. Thanks. (3 Replies)
Discussion started by: er_ashu
3 Replies

6. Shell Programming and Scripting

Script to copy log files with today's date

I am a newbie to scripting. I need a korn shell script to copy log files of current day to archive folder and rename with current days date stamp. I would really appreciate your help. File structure is as follows. Everyday files get overwritten, so I need copy to a archive directory and... (3 Replies)
Discussion started by: mdncan
3 Replies

7. Shell Programming and Scripting

yesterdays date

To get yesterays date, execute the command : TZ=aaa24 date +%Y%m%d Output format will be yyyymmdd (2 Replies)
Discussion started by: sujju1985
2 Replies

8. Shell Programming and Scripting

Korn Shell Script - Getting yesterdays date

I need to get yesterdays date in the format yyyymmdd I can get today's date simply enough - 20031112 Is there any way to substract 1 from this easily enough in korn shell script? It has to be korn shell and not perl (20 Replies)
Discussion started by: frustrated1
20 Replies

9. UNIX for Dummies Questions & Answers

Get yesterdays date given todays date

Hi Guys. I am very new to UNIX. I need to get yesterdays and tommorows date given todays date. Which command and syntax do i use in basic UNIX shell. Thanks. (2 Replies)
Discussion started by: magikminox
2 Replies

10. UNIX for Dummies Questions & Answers

yesterdays files

I am new to UNIX and I am trying to write a shell script. I want to be able to list all files that were created with yesterdays dates (APR 29 as an example) that are not 0 file size.Then in those files I want to look for the string 'Process Complete' and list all files that DONT have that string.... (8 Replies)
Discussion started by: tonydsam
8 Replies
Login or Register to Ask a Question