Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Grepping log file

Login to Discuss or Reply to this Discussion in Our Community

 
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:

Code:
<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=10.60.4.2)(PORT=34898)) * establish * fgs * 0
 </txt>
</msg>


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:

Code:
sed -ne "s/.*time=.\([^']*\)'.*/\1/p" -e "s/.*HOST=\([^)]*\)).*/\1/p" infile| awk '$1=$1' RS=
2009-10-14T05:46:42.580+00:00 10.60.4.2

# 3  
Old 10-20-2009
Hi,

Thanks for the feedback!

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

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

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

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 ----------

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

Just IP

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

# 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