Shell Programming and Scripting

Hi Guru's.... I've one log file in all my systems which writes the backup information..

I'have written a command like this:

ssh -l ora${sid} ${primaryhost} "tail -50 /oracle/$ORACLE_SID/newbackup/END_BACKUP.log" |grep 'insert' |tail -1| awk '{print $7}'

We have nearly 50 systems in our landscape, hence when i run this command the $7 would not work since the log file is saving in exactly in all the systems when i check i found the below three formats:

1.) insert into sapqd4.sdbah values ('20080808051812','net','QD4','DB','0','20080808054531','netbackup','netbackup')
2.) new 1: insert into sapqd1.sdbah values ('20080725011009','net','QD1','DB','0','20080725052004','netbackup','netbackup')
3.) new 1: insert into sapr3.sdbah values ('20080920182244','net','DB','0','20080921013618','netbackup')

Hence when i use the $7 the output is not accurate..

Now i would like to wirte a a command which only searches for ( and display the output..

Actual line:
new 1: insert into sapr3.sdbah values ('20080927210501','net','DB','0','20080928084821','netbackup')

Desired output:

('2008/09/27/ 21:05:01 ','net','DB',' 0 ',' 2008/09/28/ 08:48:21 ','netbackup')

The things which shown in read should not dispaly, the only ouput the i need is in black colour.

Any help would be greatfully appreciated..


Thanks in advance..

Code:

ssh -l ora${sid} ${primaryhost} "tail -50 /oracle/$ORACLE_SID/newbackup/END_BACKUP.log" |
awk '/insert/ { line=$0 }
END {
  sep="";
  n=split (line, f, "'"'"'");
  for (i=1; i<=n; i++)
    if (f[i] !~ /[^0-9]/) {
      if (f[i] > 10000)
        printf "%s%s/%s/%s/ %s:%s:%s", sep, substr(f[i],1,4), substr(f[i],5,2), substr(f[i],7,2),
          substr(f[i],9,2), substr (f[i],11,2), substr (f[i],13,2);
      else
        printf "%s%s", sep, f[i];
      sep=",";
    }
  printf "\n"; }'

Notice how this splits on single quote (obfuscatedly written "'"'"'" because of shell quoting mechanisms) and extracts those values which are all numeric. If this is unsuitable, probably an altogether different strategy is required.

May be this can help you a little bit

bijayant@bijayant~ $ cat testfile
new 1: insert into sapr3.sdbah values ('20080927210501','net','DB','0','20080928084821','netbackup')

bijayant@bijayant ~ $ cat testfile |cut -d "(" -f2 | tr "','" " " | awk '{print $1 " " $4 " " $5}'
20080927210501 0 20080928084821