Jump to content
Aks

How to insert variable data in html table with unix commands

Recommended Posts

Hi I am using below script to create 3 tables adjacent to each other :

PARAMETERS

MOUNT

SIZE

1

f

fg

fgh

BEFORE_USAGE

USED

AVAILABLE

USE%

1

f

5

fg

fgh

t2

AFTER_USAGE

USED

AVAILABLE

USE%

Fvfev

kjhkj

kjgfhkg

fbghvg

gcfv

hfjghj

QUERY : I want to use df -h command which should fill the data  ( <td> ) in the above 3 table columns ( Parameters/ Before_Usgae/After_Usage). 

BEFORE USAGE : The disk space before clearing the space on the server.

AFTER USAGE : Disk space after clearing the space.

The problem here is : I am able to write the code in linux to generate the table like above ( next to each other) but unable to generate the data for ( Mount/size) , ( Used/available/use%) in runtime. 

Please help me how can i achieve this.

-------------------------
#! /bin/bash

MailTO=xyz@gmail.com
DATE=`/bin/date '+%Y%m%d-%H%M%S'`
HOST=`hostname`
ALERT_DIR_COUNT=`df -Ph | grep -v "Use%" | sed 's/%//g' | awk '$5 > 70 {print $1,$2,$3,$4,$5"%",$6;}' | column -t | wc -l`


(
printf "To: xyz@gmail.com\n"
printf "Subject:$HOST\n :$ALERT_DIR_COUNT\n mounts reached threshold & Logs Cleared : $Numberofdays days\n"
printf "Content-Type: text/html\n"
printf "<html>\n"
printf "<body>\n"

df -Ph | awk '

BEGIN {

printf "<table border="1" cellspacing="0" cellpadding="0">"
printf "<tr>"
printf "<td width="40">"
printf "<table width="100" border="1" cellspacing="0" cellpadding="1">"
printf "<tr>"
printf "<th style=\"font-size:12px\" bgcolor=#B2BABB align=center colspan="2">PARAMETERS</th>"
printf "<tr>"
printf "<th style=\"font-size:12px\" bgcolor=#EAEDED>MOUNT</th>"
printf "<th style=\"font-size:12px\" bgcolor=#EAEDED>SIZE</th>"
printf "</tr>"
printf "<tr>"
printf "<td>1</td>"
printf "<td>f</td>"
printf "</tr>"
printf "<tr>"
printf "<td>fg</td>"
printf "<td>fgh</td>"
printf "</tr>"
printf "</table>"
printf "</td>"
printf "<td width="30">"


printf "<table width="100" border="1" cellspacing="0" cellpadding="1">"
printf "<tr>"
printf "<th style=\"font-size:12px\"bgcolor=#73C6B6 align=center colspan="3">BEFORE_USAGE</th>"
printf "<tr>"
printf "<th style=\"font-size:12px\" bgcolor=#D0ECE7>USED</th>"
printf "<th style=\"font-size:12px\" bgcolor=#D0ECE7>AVAILABLE</th>"
printf "<th style=\"font-size:12px\" bgcolor=#D0ECE7>USE%</th>"
printf "</tr>"
printf "<tr>"
printf "<td>1</td>"
printf "<td>f</td>"
printf "<td>5</td>"
printf "</tr>"
printf "<tr>"
printf "<td>fg</td>"
printf "<td>fgh</td>"
printf "<td>t2</td>"
printf "</tr>"
printf "</table>"
printf "</td>"
printf "<td width="30">"

printf "<table width="100" border="1" cellspacing="0" cellpadding="1">"
printf "<tr>"
printf "<th style=\"font-size:12px\" bgcolor=#7FB3D5 align=center colspan="3">AFTER_USAGE</th>"
printf "<tr>"
printf "<th style=\"font-size:12px\" bgcolor=#D6EAF8>USED</th>"
printf "<th style=\"font-size:12px\" bgcolor=#D6EAF8>AVAILABLE</th>"
printf "<th style=\"font-size:12px\" bgcolor=#D6EAF8>USE%</th>"
printf "</tr>"
printf "<tr>"
printf "<td>Fvfev</td>"
printf "<td>kjhkj</td>"
printf "<td>kjgfhkg</td>"
printf "</tr>"
printf "<tr>"
printf "<td>fbghvg</td>"
printf "<td>gcfv</td>"
printf "<td>hfjghj</td>"
printf "</tr>"
printf "</table>"
printf "</td>"
printf "</tr>"
printf "</table>"
}
  END { print "</table>" }'
printf "</body>\n</html>\n" ) | /usr/sbin/sendmail $MailTO
 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...