Shell Programming and Scripting

Job <302735>, Job Name <SOME_JOB_NAME_HERE>, User <hsimpson>, Proj
                     ect <default>, Command </path/to/job.sh -sysparm "254 CR66
                     " -log /path/to/logs/log.log -print /path/to/print.txt>
Tue Aug 24 06:56:48: Submitted from host <computer1>, to Queue <Queue_1>, CWD </
                     path/to/scripts>, Re-runnable;
Tue Aug 24 06:56:50: Dispatched to <myserver.com>;
Tue Aug 24 06:56:50: Starting (Pid 22582);
Tue Aug 24 06:56:50: Running with execution home </home/hsimpson>, Execution
                     CWD </path/to/scripts>, Execution Pid <22582>;
Tue Aug 24 06:56:52: Exited with exit code 1. The CPU time used is 0.5 seconds;


Summary of time in seconds spent in various states by  Tue Aug 24 06:56:52
  PEND     PSUSP    RUN      USUSP    SSUSP    UNKWN    TOTAL
  2        0        2        0        0        0        4
------------------------------------------------------------------------------

Job <302742>, Job Name <THIS_IS_A_JOB_NAME_HERE>, User <hsimpson
                     >, Project <default>, Command </path/to/job.sh -sysparm 
                     "254 CR66" -log /path/to/logs/log.log -print /path/to/
                     print.txt>
Tue Aug 24 06:57:59: Submitted from host <server4>, to Queue <Queue_2>, CWD </
                     path/to/scripts>, Re-runnable;
Tue Aug 24 06:58:05: Dispatched to <myserver.com>;
Tue Aug 24 06:58:05: Starting (Pid 28265);
Tue Aug 24 06:58:05: Running with execution home </home/hsimpson>, Execution
                     CWD </path/to/scripts>, Execution Pid <28265>;
Tue Aug 24 14:14:42: Done successfully. The CPU time used is 3.9 seconds;
Tue Aug 24 14:14:42: Post job process done successfully;

Summary of time in seconds spent in various states by  Tue Aug 24 14:14:42
  PEND     PSUSP    RUN      USUSP    SSUSP    UNKWN    TOTAL
  6        0        26197    0        0        0        26203
------------------------------------------------------------------------------

Job <302845>, Job Name <JOB_NAME_GOES_HERE_HERE_HERE>, User <hsimpson>, Proj
                     ect <default>, Command </path/to/job.sh -sysparm "254 CR66
                     " -log /path/to/logs/log.log -print /path/to/print.txt>
Tue Aug 24 08:16:07: Submitted from host <myserver.com>, to Queue
                     <Queue_3>, CWD </tmp>, Re-runnable;
Tue Aug 24 08:16:11: Dispatched to <myserver.com>;
Tue Aug 24 08:16:11: Starting (Pid 11867);
Tue Aug 24 08:16:11: Running with execution home </home/hsimpson>, Execution CWD <
                     /tmp>, Execution Pid <11867>;
Tue Aug 24 08:38:50: Exited with exit code 1. The CPU time used is 0.6 seconds;


Summary of time in seconds spent in various states by  Tue Aug 24 08:38:50
  PEND     PSUSP    RUN      USUSP    SSUSP    UNKWN    TOTAL
  4        0        1359     0        0        0        1363

302735,Tue Aug 24 06:56:48,Tue Aug 24 06:56:52,2,2,4,SOME,JOB
302742,Tue Aug 24 06:57:59,Tue Aug 24 14:14:42,6,26197,26203,THIS,IS
302845,Tue Aug 24 08:16:07,Tue Aug 24 08:38:50,4,1359,1363,JOB,NAME

#AWK

function p()          { if(jobno!="") { print jobno "," submit "," done "," pend "," run "," total "," jobname1 "," jobname2 } 
}

/^Job/                { jobno=substr($0,6,6); 
                        split($0,a,","); 
                        split(a[2],b,"_"); 
                        jobname1=b[1]; 
                        jobname2=b[2]
}                            
                                                                           
/Submitted/           { submit=substr($0,1,19)
}                            
                            
/^Summary/            { done=substr($0,56,19)
}
                            
/PEND/                { getline; 
                        pend=$1; 
                        run=$3; 
                        total=$NF; 
                        p()
}

awk '/^Job/ {printf substr($2,2,length($2)-3)",";x=substr($5,2);y=$6}
/Submitted from host/{printf $1" "$2" "$3" "substr($4,1,length($4)-1)","}
/^Summary of time/ {printf $(NF-3)" "$(NF-2)" "$(NF-1)" "$NF","}
/^ +[0-9]/{printf $3","$19","$NF","x","y"\n"}' FS=" |_" urfile
302735,Tue Aug 24 06:56:48,Tue Aug 24 06:56:52,2,2,4,SOME,JOB
302742,Tue Aug 24 06:57:59,Tue Aug 24 14:14:42,6,26197,26203,THIS,IS
302845,Tue Aug 24 08:16:07,Tue Aug 24 08:38:50,4,1359,1363,JOB,NAME