Grepping log file

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Grepping log file
# 1  
Old 10-20-2009
Grepping log file

Dear All,

I have a log file that is dislpayed as:

<msg time='2009-10-14T05:46:42.580+00:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='mtdb_a'
 host_addr='UNKNOWN' version='1'>
 <txt>14-OCT-2009 05:46:42 * (CONNECT_DATA=(SID=fgs)(CID=(PROGRAM=sqlplus@mtdb)(HOST=mtdb_a)(USER=root))) * (ADDRESS=(PROTOCOL=tcp)(HOST= * establish * fgs * 0

How can i grab in the <txt> the

1- Date
2- Time
3- Host
4 - All together seperated by a space

regards all
# 2  
Old 10-20-2009
Not sure if these are the Time/Date/Host values you mentioned:

sed -ne "s/.*time=.\([^']*\)'.*/\1/p" -e "s/.*HOST=\([^)]*\)).*/\1/p" infile| awk '$1=$1' RS=

# 3  
Old 10-20-2009

Thanks for the feedback!

Hmmm, its the time below, and how can i apply this command to a file in unix shell ?

# 4  
Old 10-20-2009
Ok, here with the other date/time:

sed -ne "s/.*txt.\([^ ]* *[^ ]* \)\*.*HOST=\([^)]*\)).*/\1\2/p" infile
14-OCT-2009 05:46:42

You can apply this on a file for sure - the one I used up there I called "infile".
# 5  
Old 10-20-2009
Wow, this is super...Thanks!

What if i would like to capture just the ip, this syntax is complex!?
# 6  
Old 10-20-2009

---------- Post updated at 01:07 AM ---------- Previous update was at 01:06 AM ----------

awk -F '[ >=)]' '/<txt>/{print $3,$4,$24}'
14-OCT-2009 05:46:42

Just IP

awk -F '[=)]' '/<txt>/{print $17}'

# 7  
Old 10-20-2009
Could you please give me some advice on how i could get do a reporting procedure on the time and ip.....for example....count the ip number per hour...or change granularity to day or whatever, what do you think ?
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ksh Script, Reading A File, Grepping A File Contents In Another File

So I'm stumped. First... APOLOGIES... my work is offline in an office that has zero internet connectivity, as required by our client. If need be, I could print out my script attempts and retype them here. But on the off chance... here goes. I have a text file (file_source) of terms, each line... (3 Replies)
Discussion started by: Brusimm
3 Replies

2. Shell Programming and Scripting

Grepping only dates from a log file

Hi All, I have a log file where every line contains a date and some other data, i want to grep only the date from every line to a different file. Please help how to get this. Thanks in advance !! (25 Replies)
Discussion started by: nanz143
25 Replies

3. Shell Programming and Scripting

Grepping file and returning passed variable if the value does not exist in file at all.

I have a list of fields that I want to check a file for, returning that field if it not found at all in the file. Is there a way to do a grep -lc and return the passed variable too rather then just the count? I am doing some crappy work-around now but I was not sure how to regrep this for :0 so... (3 Replies)
Discussion started by: personalt
3 Replies

4. UNIX for Dummies Questions & Answers

grepping log files

I have a log file and I have two unique strings which represent the start and end of the text I want to obtain. How can I get all the text inbetween this start string and the end string? Thanks (2 Replies)
Discussion started by: chrisjones
2 Replies

5. Shell Programming and Scripting

Grepping string from out file

Guys .. Need to pull this highlighted strings irrespective of line numbers & should be echoed . But these strings are from Outfile from different dir. In which way this can be grepped ?? Need an idea http-timeout 120 seconds persistent-timeout 180 seconds host-rewriting on ... (7 Replies)
Discussion started by: raghunsi
7 Replies

6. Shell Programming and Scripting

Grepping the last 30 minutes of a log file...

I need to know if anyone can assist me on how to grab the last (we'll just say "x" minutes) of a log file. How do you tell the grep command without specifying an exact window of time? (So relative instead of absolute.) Thanks, Jon (2 Replies)
Discussion started by: jtelep
2 Replies

7. Shell Programming and Scripting

Grepping Errors in a file

Hey All, I have to grep for an error from a file and get the results of errror in a different file...... But there should be no duplicate entries. Can anyone help me in giving a shell script for this This is file which contains pattern error which I am supposed to grep and put this in a... (4 Replies)
Discussion started by: achararun
4 Replies

8. Shell Programming and Scripting

Loop and grepping into a file

I wrote this script for: 1. Get the Web log for today 2. Give me a list of all the IP addresses that have accessed the web server today 3. Remove a list of known IPs listed in a file (line by line) 4. Mail the final file to selected recipients. I am unable to do part 3. In the script... (3 Replies)
Discussion started by: skotapal
3 Replies

9. UNIX for Dummies Questions & Answers

grepping the first 3 characters from a file

give this a try and let me know if it works grep '^' filename rachael (2 Replies)
Discussion started by: rachael
2 Replies

10. UNIX for Dummies Questions & Answers

grepping the first 3 characters from a file

Hi I was wondering if it's possible to use a command to get the first 3 characters of a line in a text file, I tried grep but it returns the whole line but I am only interested in the first 3 characters. Is this possible with grep or I need any other command? Also is it possible deleting from... (2 Replies)
Discussion started by: g-e-n-o
2 Replies
Login or Register to Ask a Question