sh/awk (partly) script returning a null value but want it to return a value

Question

I have the following sh script: the values that it is outputting looks like the following: As you can see it is returning a null value against the following line: This should look like the lines above and below. ([time] - [time] - [duration] etc) Which is in turn effecting the time calculation ( negative number) I need to put

Accepted Answer

I managed to get this working.I did the following:#!/bin/shfunction usage(){echo ""echo " use like this: cat ../mfshangingsoctelsim.2015-07-28.*.log | ./kevin.sh ms504201"echo " use one of the following scanners for alh: ms504201 ms503201 ms502201 ms501201"echo "now exiting..."exit 1}#[[ $# -eq 1 ]] || usage#[[ $1 == "attack" ]] || usagedate=$(date --date="-1 days" +%F)clearecho "==============================================================="echo " RED status on BCS loops on $date"echo "==============================================================="echogrep -E 'SCS([0-9]*)_ORDER(_OUTER|)_LOOP' $(ls -tr ../mfsBoxedOutboundService.$date.*.log) |awk -v scanner="$1" 'begin{indexx = 0outerred = 0 # is it time to check all SCS? - 1 yes as OUTER is redscs01=0;scs02=0;scs03=0;scs04=0;scs05=0;scs07=0;scs08=0;scs09=0;scs10=0scs11=0;scs12=0;scs13=0;scs14=0;scs15=0;scs17=0;scs18=0;scs19=0;scs20=0t = 0tt = 0}{printf($3);if (match($0,"state=RED")&&match($0,"SCS_ORDER_OUTER_LOOP")&&outerred==0) {scsouterred[indexx]=substr($3,1,8); scsouterbreachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10); outerred=1; scs01=1;scs02=1;scs03=1;scs04=1;scs05=1;scs07=1;scs08=1;scs09=1;scs10=1; scs11=1;scs12=1;scs13=1;scs14=1;scs15=1;scs17=1;scs18=1;scs19=1;scs20=1; }if (outerred==1) { if (match($0,"state=GREEN")&&match($0,"SCS_ORDER_OUTER_LOOP")) {scsoutergreen[indexx]= substr($3,1,8);indexx++;outerred=0} if (scs01=1&&match($0,"SCS01_ORDER_LOOP")) {scs01breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs01=0;} if (scs02=1&&match($0,"SCS02_ORDER_LOOP")) {scs02breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs02=0;} if (scs03=1&&match($0,"SCS03_ORDER_LOOP")) {scs03breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs03=0;} if (scs04=1&&match($0,"SCS04_ORDER_LOOP")) {scs04breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs04=0;} if (scs05=1&&match($0,"SCS05_ORDER_LOOP")) {scs05breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs05=0;} if (scs07=1&&match($0,"SCS07_ORDER_LOOP")) {scs07breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs07=0;} if (scs08=1&&match($0,"SCS08_ORDER_LOOP")) {scs08breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs08=0;} if (scs09=1&&match($0,"SCS09_ORDER_LOOP")) {scs09breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs09=0;} if (scs10=1&&match($0,"SCS10_ORDER_LOOP")) {scs10breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs10=0;} if (scs11=1&&match($0,"SCS11_ORDER_LOOP")) {scs11breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs11=0;} if (scs12=1&&match($0,"SCS12_ORDER_LOOP")) {scs12breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs12=0;} if (scs13=1&&match($0,"SCS13_ORDER_LOOP")) {scs13breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs13=0;} if (scs14=1&&match($0,"SCS14_ORDER_LOOP")) {scs14breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs14=0;} if (scs15=1&&match($0,"SCS15_ORDER_LOOP")) {scs15breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs15=0;} if (scs17=1&&match($0,"SCS17_ORDER_LOOP")) {scs17breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs17=0;} if (scs18=1&&match($0,"SCS18_ORDER_LOOP")) {scs18breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs18=0;} if (scs19=1&&match($0,"SCS19_ORDER_LOOP")) {scs19breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs19=0;} if (scs20=1&&match($0,"SCS20_ORDER_LOOP")) {scs20breachlevel[indexx]=substr($0,index($0,"occupancy=")+10,index($0,"]>")-index($0,"occupancy=")-10);scs20=0;} } # main loop to collect scs levels and wait for greenprintf("rrrrrrrrrrrrr");}END{print "";print "-------------scs------------------------------------------------";i = (substr(scsoutergreen[a],1,2)-substr(scsouterred[a],1,2))*60+(substr(scsoutergreen[a],4,2)-substr(scsouterred[a],4,2))for (a in scsouterred) {if (((substr(scsoutergreen[a],1,2)-substr(scsouterred[a],1,2))*60)<=0&&(substr(scsoutergreen[a],4,2)-substr(scsouterred[a],4,2))<=0) {t = 0} #start of t = ifelse if (((substr(scsoutergreen[a],1,2)-substr(scsouterred[a],1,2))*60)<= 0) {t = (0+(substr(scsoutergreen[a],4,2)-substr(scsouterred[a],4,2)))}else if ((substr(scsoutergreen[a],4,2)-substr(scsouterred[a],4,2))<= 0) {t = (((substr(scsoutergreen[a],1,2)-substr(scsouterred[a],1,2))*60)+0)}else {t = ((substr(scsoutergreen[a],1,2)-substr(scsouterred[a],1,2))*60+(substr(scsoutergreen[a],4,2)-substr(scsouterred[a],4,2)))} #end of t = ifprint scsouterred[a],"-",scsoutergreen[a],"-",t,"min","outer:",scsouterbreachlevel[a],"scs01:",scs01breachlevel[a],"scs02:",scs02breachlevel[a],"scs03:",scs03breachlevel[a],"scs04:",scs04breachlevel[a],"scs05:",scs05breachlevel[a],"scs07:",scs07breachlevel[a],"scs08:",scs08breachlevel[a],"scs09:",scs09breachlevel[a],"scs10:",scs10breachlevel[a],"scs11:",scs11breachlevel[a],"scs12:",scs12breachlevel[a],"scs13:",scs13breachlevel[a],"scs14:",scs14breachlevel[a],"scs15:",scs15breachlevel[a],"scs17:",scs17breachlevel[a],"scs18:",scs18breachlevel[a],"scs19:",scs19breachlevel[a],"scs20:",scs20breachlevel[a];tt = tt + t;}print "total number of incidents: ",indexx," for ",tt," minutes rr"print "-----NOTE-----r"print "If time is empty recovery was after 23:59:99 on ",$3}'The changes I made from the original is that I modified the setting of the t variable in the lower half of the script from:t = (substr(scsoutergreen[a],1,2)-substr(scsouterred[a],1,2))*60+(substr(scsoutergreen[a],4,2)-substr(scsouterred[a],4,2))To the following:if (((substr(scsoutergreen[a],1,2)-substr(scsouterred[a],1,2))*60)<=0&&(substr(scsoutergreen[a],4,2)-substr(scsouterred[a],4,2))<=0) {t = 0} #start of t = ifelse if (((substr(scsoutergreen[a],1,2)-substr(scsouterred[a],1,2))*60)<= 0) {t = (0+(substr(scsoutergreen[a],4,2)-substr(scsouterred[a],4,2)))}else if ((substr(scsoutergreen[a],4,2)-substr(scsouterred[a],4,2))<= 0) {t = (((substr(scsoutergreen[a],1,2)-substr(scsouterred[a],1,2))*60)+0)}else {t = ((substr(scsoutergreen[a],1,2)-substr(scsouterred[a],1,2))*60+(substr(scsoutergreen[a],4,2)-substr(scsouterred[a],4,2)))}This resolves the null time issue and returns a 0 if the time works out to be <= 0 or the actual calculation if it isn’t.

Advertisement

Answer