Parsing a Log file


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Parsing a Log file
# 1  
Old 06-19-2006
Question Parsing a Log file

Hi All,

I'm deffently not a Unix specialist so be Gentel.
I need to parse a Log file that looks like that:

2006-06-12 01:00:00,463 ERROR [shared.logger.LoggerCleaner] {cleanLoggersFiles} General Error
comverse.compas.shared.exceptions.SystemParametersException: Error in reading parameter FileLocation
at comverse.compas.shared.paramhandler.SystemParametersDelegate.getStringValue(SystemParametersDelegate .java:186)
at comverse.compas.shared.logger.LoggerCleaner.cleanLoggersFiles(LoggerCleaner.java:110)
at comverse.compas.shared.logger.LoggerCleaner.run(LoggerCleaner.java:66)

My request is to Count the number of 'Error' occurences in the file in the current day, starting 00:00 till 00:00

Whats the best way to do that?

Thanks
Tal
# 2  
Old 06-19-2006
Try this command :
Code:
grep -c "`date +'%Y-%m-%d'`[ 0-9:,]*ERROR" /path/to/log_file

Jean-Pierre.
# 3  
Old 06-19-2006
Still doent work

Thanks Jean-Pierre,
I have tried the command but havent received the expected result. I have also tried your command by giving a specific date and it still doent work:

grep -c "2006-06-18 [0-9:,] *ERROR" SPMAgent_Debug.log
0
dsu001-sys01a:/var/cti/logs/spmagent ROOT > grep "2006-06-18" SPMAgent_Debug.log
2006-06-18 01:00:00,528 ERROR [shared.logger.LoggerCleaner] {cleanLoggersFiles} General Error

As U can see I hace the sring ERROR on the 18th but using the command I get the counter 0

any thoughts
Tal
# 4  
Old 06-19-2006
I'm not sure what's going on - Jean-Pierre seems to have a good regex.
start with this:
Code:
grep '^2006-06-18 ' SPMAgent_Debug.log | grep -c ' ERROR '

# 5  
Old 06-20-2006
Looks like a trypo?
You have:
Code:
grep -c "2006-06-18 [0-9:,] *ERROR" SPMAgent_Debug.log

instead of (the space is after the [, not before it)
Code:
grep -c "2006-06-18[ 0-9:,] *ERROR" SPMAgent_Debug.log

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

HELP on parsing this log file

Hi, I have a log file that looks like below and I am wanting to know if there is a better way of parsing it from how I am doing it right now. I am looking for when an application service is OFFLINE and ONLINE. This log file is getting written into every 30 minutes ... (1 Reply)
Discussion started by: newbie_01
1 Replies

2. Shell Programming and Scripting

Parsing log file for last 2 hours

I want to parse a log file which i am grepping root user connection but is showing whole day and previous day detail as well. First i want to see last 2 hours log file then after that i want to search particular string. Lets suppose right now its 5:00PM, So i want to see the log of 3:00PM to... (6 Replies)
Discussion started by: learnbash
6 Replies

3. Shell Programming and Scripting

Parsing Log File help

Hi, I am a newbie to scripting. I have multiple log files (saved as .gz) in a directory that looks like this 01-01-2013 10:00 pn: 123 01-01-2013 10:00 sn: 987 01-01-2013 10:00 Test1 01-01-2013 10:00 Result: Pass 01-01-2013 10:00 Time: 5:00 01-01-2013 10:00 Test2 01-01-2013 10:00... (3 Replies)
Discussion started by: linuxnew
3 Replies

4. Shell Programming and Scripting

Help Parsing a Log File

Hello all, I am new to scripting and I have written a script that performs an Rsync on my NAS and then moves on to send me an email with the status etc. The problem is that I think Rsync is taking to long to complete and the IF statement is timing out, as it doesn't appear to move on. Here... (1 Reply)
Discussion started by: Mongrel
1 Replies

5. Shell Programming and Scripting

Script for Parsing Log File

Working on a script that inputs an IP, parses and outputs to another file. A Sample of the log is as follows: I need the script to be able to input IP and print the data in an output file in the following format or something similar: Thanks for any help you can give me! (8 Replies)
Discussion started by: Winsarc
8 Replies

6. UNIX for Dummies Questions & Answers

Parsing log file continuously

Hi i have a log file, which keeps appending, i want to find "exceptions" in that log file and copy those exceptions to another file. i am using grep exception filename >> location where to copy but as the file is appending, am not able to view. i am using tail -f command , ... (5 Replies)
Discussion started by: rchaitanya
5 Replies

7. Shell Programming and Scripting

Log file text parsing

I'm new to scripting and was wondering if there was a way to accomplish what I want below using shell script(s). If there is a log file as follows, where the id is the unique id of a process, with the timestamp of when the process began and completed displayed, would it be possible to find the... (3 Replies)
Discussion started by: dizydolly
3 Replies

8. UNIX for Dummies Questions & Answers

parsing a log file

I need help in parsing the following log files. 10 Apr 2009 0:16:16 * name: Tuna Belly Format: Well done, Price: 999 only 10 Apr 2009 0:16:16 * name: Roast Beef Format: Raw, Price: 55 c 10 Apr 2009 0:16:16 * name: Pasta Format: Dry, Price: 88.43 only etcetc I need to parse this... (8 Replies)
Discussion started by: izuma
8 Replies

9. UNIX for Dummies Questions & Answers

Script for parsing details in a log file to a seperate file

Hi Experts, Im a new bee for scripting, I would ned to do the following via linux shell scripting, I have an application which throws a log file, on each action of a particular work with the application, as sson as the action is done, the log file would vanish or stops updating there, the... (2 Replies)
Discussion started by: pingnagan
2 Replies

10. Shell Programming and Scripting

Help with script parsing a log file

I have a large log file, which I want to first use grep to get the specific lines then send it to awk to print out the specific column and if the result is zero, don't do anything. What I have so far is: LOGDIR=/usr/local/oracle/Transcription/log ERRDIR=/home/edixftp/errors #I want to be... (3 Replies)
Discussion started by: mevasquez
3 Replies
Login or Register to Ask a Question