Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

HELP on parsing this log file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting HELP on parsing this log file
# 1  
Old 10-25-2013
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


Code:
 
 25_06_2013_01:00
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.mnl1.mnl1_app.svc
      1        ONLINE  ONLINE       mnl1db912
ora.mnl2.mnl2_app.svc
      1        ONLINE  ONLINE       mnl1db911
ora.mnl3.mnl3_app.svc
      1        ONLINE  ONLINE       mnl1db911
      2        OFFLINE OFFLINE      mnl1db912
      3        OFFLINE OFFLINE       mnl1db913
...
...
...
 25_06_2013_08:30
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.mnl1.mnl1_app.svc
      1        ONLINE  ONLINE       mnl1db912
ora.mnl2.mnl2_app.svc
      1        ONLINE  ONLINE       mnl1db911
ora.mnl3.mnl3_app.svc
      1        ONLINE  ONLINE       mnl1db911
      2        ONLINE  ONLINE       mnl1db912
      3        ONLINE  ONLINE       mnl1db913

From the sample excerpts above, I pass a service to check as the first argument for example, ./x.sh ora.mnl3.mnl3_app.svc which was OFFLINE at 0100 and ONLINE at 0830.

At the moment, what I am doing is reading each line, and checking if they are in the date format or ora.mnl3.mnl3_app.svc, if I found ora.mnl3.mnl3_app.svc, I then check for the next consecutive lines that starts with a white space and check if they have ONLINE or OFFLINE on it. I dontinue on from the start to the end of the log.

Is there any better way of doing this? Any advice much appreciated? Thanks in advance.
# 2  
Old 10-26-2013
Not clear what you want to achieve. Looking for a certain service or for all services? And, service ora.mnl3.mnl3_app.svc was ONLINE on server 911 at 0100, so which line to pick?
Please show us your input parameter(s) and you desired output.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

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

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

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

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

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

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

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

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

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

10. Shell Programming and Scripting

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 {cleanLoggersFiles} General Error comverse.compas.shared.exceptions.SystemParametersException: Error in reading parameter FileLocation at... (4 Replies)
Discussion started by: tbirenzweig
4 Replies
Login or Register to Ask a Question