Shell Programming and Scripting

Hi,

Under Linux FS /usr/OV/log, I have a log file hsc.log.27Jun05
which contains alert logs for various alerts ;

====
#Fri Jun 24 01:35:12 IST 2005 ihm001a1-enf.pocus1#
23-Jun-05 20:00 ihm001a1
File not received in /pgrb/cre/ieceu11/data/bkpsrcve/MGECLON003 from last 30 min
Please raise a Priority 2 ticket for iMASC-GECS
Please do not raise an SDM between Saturday 1500 CUT to Sunday 0330 CUT

#Fri Jun 24 03:32:26 IST 2005 ihqr09a1.poceur1#
23-Jun-05 22:00
Msg : Defunct processes on ihqr09a1
PIDs
260286
Investigate


====

#Fri Jun 24 05:22:23 IST 2005 ihm001a1-enf.pocus1##
23-Jun-05 23:50 ihm001a1
Filesystem: /perb/dre/yeceu11
Space Utilized: 100%
Severity: 2
Raise a ticket to relevant AST

====

I would like to extract data from this log file and format the output
something like;

From 2nd line I would like to extract : date, node name
From 3rd line : Alert type, filesystem
From 5th line : severity

Can somebody help please.

input file

Code:

#Fri Jun 24 01:35:12 IST 2005 ihm001a1-enf.pocus1# 
23-Jun-05 20:00 ihm001a1 
File not received in /pgrb/cre/ieceu11/data/bkpsrcve/MGECLON003 from last 30 min 
Please raise a Priority 2 ticket for iMASC-GECS 
Please do not raise an SDM between Saturday 1500 CUT to Sunday 0330 CUT 

#Fri Jun 24 03:32:26 IST 2005 ihqr09a1.poceur1# 
23-Jun-05 22:00 
Msg : Defunct processes on ihqr09a1 
PIDs 
260286 
Investigate 


#Fri Jun 24 05:22:23 IST 2005 ihm001a1-enf.pocus1## 
23-Jun-05 23:50 ihm001a1 
Filesystem: /perb/dre/yeceu11 
Space Utilized: 100% 
Severity: 2 
Raise a ticket to relevant AST

results

Code:

23-Jun-05 20:00 ihm001a1  File not received in /pgrb/cre/ieceu11/data/bkpsrcve/MGECLON003 from last 30 min  
23-Jun-05 22:00  Msg : Defunct processes on ihqr09a1  
23-Jun-05 23:50 ihm001a1  Filesystem: /perb/dre/yeceu11  Severity: 2

Code:

#!/bin/ksh

#From 2nd line I would like to extract : date, node name 
#From 3rd line : Alert type, filesystem
#From 5th line : severity

awk ' BEGIN{counter=0}
      {
          if(index($0,"#")==1) { 
              counter=1
              printf("\n")
          }
          else                 {counter++}
          if(counter==2) {printf("%s ", $0)}
          if(counter==3) {printf("%s ", $0)}
          if(counter==5) {
              if(index($0,"Severity")>0) { printf("%s ", $0)}
          }
      } 
      END {printf("\n")}' filename

Hi,

Many thanks for the help.

I got the output I wanted, however, I would like to format the output following ;

If from 3rd line Alert type is "FileSystem" then I need to prefix it with "NV001 : <rest of string>
If from 3rd line Alert type is "running or RUNNING" then I need to prefix it with "NV002 : <rest of string>
If from 3rd line Alert type is "FTM files or File not received" then I need to prefix it with "NV003 : <rest of string>

Further, I would like extract the count of NV001,NV002,NV003 from the file and append at the end of above string something like;
NV001: <rest of string>:Count=<>

Could you please assist how can I achieve this.