how to use variable in html in row and column tag shell script

Question

I am trying to create a script which uses text file as input, compares values against a threshold and create a html report. My data populates just fine, but it is not rendering colors as expected, need guidance on the same please, I mean how to use this variable in td ?

input file:

6 30 OK
5 30 OK
70 30 NOK
56 30 NOK
8 30 OK
52 30 NOK
22 30 OK

and below is my awk command:

awk 'BEGIN{
FS=" "
print  "<TABLE border=1 cellspacing=0 cellpadding=3><TR><TH>HOST</TH><TH>APP_HOST1</TH><TH>APP_HOST2</TH><TH>APP_HOST3</TH><TH>APP_HOST4</TH><TH>APP_HOST5</TH><TH>DB_HOST1</TH><TH>DB_HOST2</TH></TR>"
print "<TR><TD>DISK_ROOT</TD>"
}
 NR>=1{
bgcolor=" bgcolor=green"
if($3=="NOK"){ bgcolor=" bgcolor=red"}
printf "<TD $bgcolor>"$1"</TD>"
}
 END{
print "</TABLE>"
 }
'  ${logdir}/Disk_Space.log >> $stat_dir/html/report_Disk.html

Jaime S · Accepted Answer · 2020-02-12 09:24:03Z

1

I'm not sure about the output that you are expecting, but this could work?

awk 'BEGIN{
FS=" "
print  "<TABLE border=1 cellspacing=0 cellpadding=3><TR><TH>HOST</TH><TH>APP_HOST1</TH><TH>APP_HOST2</TH><TH>APP_HOST3</TH><TH>APP_HOST4</TH><TH>APP_HOST5</TH><TH>DB_HOST1</TH><TH>DB_HOST2</TH></TR>"
print "<TR><TD>DISK_ROOT</TD>"
}
 NR>=1{
if($3=="NOK")printf "<TD bgcolor=\"red\">"$1"</TD>"
else printf "<TD bgcolor=\"green\">"$1"</TD>"
}
 END{
print "</TABLE>"
 }
'  Disk_Space.log >> ./report_Disk.html

answered Feb 12, 2020 at 9:24

Jaime S

1,7182 gold badges21 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to use variable in html in row and column tag shell script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related