filtering the logs


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting filtering the logs
# 1  
Old 04-08-2008
filtering the logs

Hi,

We are using rsync for syncing remote directories. It is working great along with detailed logs. As the script cron'd and most of the times there're no files to sync we are getting lot of unnecessary log entries and we need to filter them to show only the log entries for the files transferred.

Actual Log: (part of)

2008/04/08 21:43:17 [19631] .d..t.... 09/
2008/04/08 21:43:17 [19631] sent 51 bytes received 26 bytes 1.86 bytes/sec
2008/04/08 21:43:17 [19631] total size is 0 speedup is 0.00
2008/04/08 21:44:49 [5672] building file list
2008/04/08 21:44:49 [5672] done
2008/04/08 21:44:49 [5672] .d..t.... 09/
2008/04/08 21:44:49 [5672] sent 51 bytes received 26 bytes 1.86 bytes/sec
2008/04/08 21:44:49 [5672] total size is 0 speedup is 0.00
2008/04/08 21:46:49 [31047] building file list
2008/04/08 21:46:49 [31047] done
2008/04/08 21:46:49 [31047] .d..t.... 09/
2008/04/08 21:46:49 [31047] <f+++++++ 09/file1.pdf
2008/04/08 21:46:49 [31047] sent 110 bytes received 48 bytes 3.81 bytes/sec
2008/04/08 21:46:49 [31047] total size is 0 speedup is 0.00
2008/04/08 21:48:49 [25274] building file list
2008/04/08 21:48:49 [25274] done
2008/04/08 21:48:49 [25274] .d..t.... 09/
2008/04/08 21:48:49 [25274] sent 71 bytes received 26 bytes 2.40 bytes/sec
2008/04/08 21:48:49 [25274] total size is 0 speedup is 0.00
2008/04/08 21:50:49 [18829] building file list
2008/04/08 21:50:49 [18829] done
2008/04/08 21:50:49 [18829] .d..t.... 09/
2008/04/08 21:50:49 [18829] sent 71 bytes received 26 bytes 2.34 bytes/sec


I achieved the below by using grep:

2008/04/08 21:43:17
2008/04/08 21:43:17 09/
2008/04/08 21:44:49
2008/04/08 21:44:49 09/
2008/04/08 21:46:49
2008/04/08 21:46:49 09/
2008/04/08 21:46:49 09/file1.pdf
2008/04/08 21:48:49
2008/04/08 21:48:49 09/
2008/04/08 21:50:49
2008/04/08 21:50:49 09/
2008/04/08 21:52:49

I need to get only the entries that have a filename (that was actually transferred) as below:

2008/04/08 21:46:49 09/file1.pdf


Thanks
Prvn
# 2  
Old 04-08-2008
This may work for you if all the filenames being rsynced have the normal three character extension like in your example (file1.pdf):

grep -e '\.[A-Za-z0-9]\{3\}' log

This will allow grep to match anything with a '.' followed by a three character file extension.

Hope this helps.
# 3  
Old 04-08-2008
Code:
awk '$3 =~ /\/./'

Might as well run that on the original log, in which case the field would seem to be $5

Last edited by era; 04-08-2008 at 04:12 PM.. Reason: $5 observation
# 4  
Old 04-08-2008
Thank you for your replies.

files may or may not contain extensions. i found solution for this (sorry if did not provide you enough info.) and it is

date1="09"
grep "$date1/" 1.txt |grep -v "$date1/"$


Era - i am getting this below error with your solution.

-sh-3.1# cat 1.txt |awk '$3 =~ /\/./'
awk: $3 =~ /\/./
awk: ^ syntax error
-sh-3.1# cat 1.txt |gawk '$3 =~ /\/./'
gawk: $3 =~ /\/./
gawk: ^ syntax error


Thanks
Prvn
# 5  
Old 04-08-2008
Sorry, mixed in some Perl syntax there. Take out the =, it should be just ~ (and take out the Useless Use of Cat too -- google that).
# 6  
Old 04-08-2008
Code:
awk '
/09\/$/, /done/ {
  for ( i=1;i<=NF;i++ ) {
   if ( $i ~ /<f+++++++/ ) {
      sub("09/","",$(i+1)) 
      print $(i+1)
   }
  }
}' file

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

If I ran perl script again,old logs should move with today date and new logs should generate.

Appreciate help for the below issue. Im using below code.....I dont want to attach the logs when I ran the perl twice...I just want to take backup with today date and generate new logs...What I need to do for the below scirpt.............. 1)if logs exist it should move the logs with extention... (1 Reply)
Discussion started by: Sanjeev G
1 Replies

2. Red Hat

Rsyslogd 7.6.7 logs filtering .

Have setup various filters like below Snip from rsyslog.conf $template mytestFile,"/var/log/testlog/%$YEAR%-%$MONTH%-%$DAY%/%HOSTNAME%.log" # if ($fromhost contains 'mytest') then { $FileCreateMode 0644 *.* ?mytestFile } # if ($fromhost contains 'nettools') then ... (0 Replies)
Discussion started by: Shirishlnx
0 Replies

3. Shell Programming and Scripting

Need help on filtering

Hi experts, I have a file image.csv as below: COMPUTERNAME,23/07/2013,22/07/2013,21/07/2013,20/07/2013,19/07/2013,18/07/2013,17/07/2013 AED03852180,3,3,3,3,3,3,3 AED03852181,3,3,3,3,3,3,1 AED09020382,3,0,3,0,3,3,3 AED09020383,1,3,3,3,2,1,3 AED09020386,3,3,0,3,3,0,3 ... (4 Replies)
Discussion started by: zaq1xsw2
4 Replies

4. Shell Programming and Scripting

text filtering

INPUT FILE: Date: 10-JUN-12 12:00:00 B 0: 00 00 00 00 10 00 16 28 B 120: 00 00 00 39 53 32 86 29 Date: 10-JUN-12 12:00:10 B 0: 00 00 00 00 10 01 11 22 B 120: 00 00 00 29 23 32 16 29 Date: 10-JUN-12 12:00:20 B 0: 00 00 00 00 10 02 17 29 B 120: 00 00 35 51 42 66 14 Date: 10-JUN-12... (5 Replies)
Discussion started by: thibodc
5 Replies

5. Shell Programming and Scripting

Filtering

Hi I am interested in DNS resolving a set of sites and each time the output is different- $ host www.yahoo.com www.yahoo.com is an alias for fd-fp3.wg1.b.yahoo.com. fd-fp3.wg1.b.yahoo.com is an alias for ds-fp3.wg1.b.yahoo.com. ds-fp3.wg1.b.yahoo.com is an alias for... (1 Reply)
Discussion started by: jamie_123
1 Replies

6. Shell Programming and Scripting

Filtering files

Hi guys, I need your help. I have a big file with names and numbers in columns like this: Albumin1A713G 1 1 3 3 1 3 1 3 1 Albumin1TC1894 1 1 1 1 1 1 1 1 1 Albumin5G186T 1 1 1 1 1 1 1 1 1 AY388580_a 0 0 1 ... (21 Replies)
Discussion started by: alecapo
21 Replies

7. AIX

Need help with filtering

Hi!! I have a bit of a task here and filtering/scripting not my strongest. I have to collect info of approx 1100 hdiskpower.so i have appended all the hdisk into a text file and i need it to run the command lscfg -vl to confirm if the drive is symmetrix. here's what i have so far at... (3 Replies)
Discussion started by: vpundit
3 Replies

8. Shell Programming and Scripting

Please help me to do some filtering

I have to grep a pattern. scenario is like :- Suppose "/etc/sec/one" is a string, i need to check if this string contains "one" using any utility something like if /etc/sec/one | grep ; then Thanks in advance Renjesh Raju (3 Replies)
Discussion started by: Renjesh
3 Replies

9. Shell Programming and Scripting

Grep yesterday logs from weblogic logs

Hi, I am trying to write a script which would go search and get the info from the logs based on yesterday timestamp and write yesterday logs in new file. The log file format is as follows: """"""""""""""""""""""""""... (3 Replies)
Discussion started by: harish.parker
3 Replies

10. AIX

AIX and cron logs filtering ?: /etc/cronlog.conf, /var/adm/cron/log

Hi, I can use 'crontabs –e' and do all the scheduling I like. However I would like to auto send myself just the cronjobs logs that fail. That is to say the PIDs that fail and the related lines with those PID’s only. (Not the full set of logs) Has anyone done this work? Or does an AIX 5.3 tool... (0 Replies)
Discussion started by: Keith Johnson
0 Replies
Login or Register to Ask a Question