Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Improve "df" output: create as html table 4
- Thread starter hallux
- Start date
- Thread starter
- #3
Thanks, the <pre> tag cleaned it up.
I then created a quick and dirty script (and awk file) to create a table without borders in html.
#!/bin/ksh
{
echo "<BODY BGCOLOR=#000000 TEXT=#FFFFFF LINK=#FFFFFF \ ALINK=#FFFFFF VLINK=#FFFFFF TOPMARGIN=0 LEFTMARGIN=0 RIGHTMARGIN=0 BOTTOMMARGIN=0 >"
echo "<TABLE WIDTH=90% ALIGN=center BGCOLOR=#000093 BORDER=3 CELLPADDING=1 CELLSPACING=1><TR><TD>"
echo "<PRE>"
echo "<table border="1">"
echo "<table frame="void">" # no borders
df -kI | awk -f df2tb.awk # create individual rows w/ awk
echo "</PRE></TD></TR></TABLE>"
} > df.htm
uuencode df.htm df.htm | mailx -s "df output" \ somebody@somewhere.com # e-mail output to somebody
$ cat df2tb.awk
# df2tb.awk -- send output to html table row format
# input -- output from df -kI in AIX
{ print "<tr>"
print "<td>"$1"</td>"
print "<td>"$2"</td>"
print "<td>"$3"</td>"
print "<td>"$4"</td>"
print "<td>"$5"</td>"
print "<td>"$6"</td>"
print "</tr>"
}
-Brent
I then created a quick and dirty script (and awk file) to create a table without borders in html.
#!/bin/ksh
{
echo "<BODY BGCOLOR=#000000 TEXT=#FFFFFF LINK=#FFFFFF \ ALINK=#FFFFFF VLINK=#FFFFFF TOPMARGIN=0 LEFTMARGIN=0 RIGHTMARGIN=0 BOTTOMMARGIN=0 >"
echo "<TABLE WIDTH=90% ALIGN=center BGCOLOR=#000093 BORDER=3 CELLPADDING=1 CELLSPACING=1><TR><TD>"
echo "<PRE>"
echo "<table border="1">"
echo "<table frame="void">" # no borders
df -kI | awk -f df2tb.awk # create individual rows w/ awk
echo "</PRE></TD></TR></TABLE>"
} > df.htm
uuencode df.htm df.htm | mailx -s "df output" \ somebody@somewhere.com # e-mail output to somebody
$ cat df2tb.awk
# df2tb.awk -- send output to html table row format
# input -- output from df -kI in AIX
{ print "<tr>"
print "<td>"$1"</td>"
print "<td>"$2"</td>"
print "<td>"$3"</td>"
print "<td>"$4"</td>"
print "<td>"$5"</td>"
print "<td>"$6"</td>"
print "</tr>"
}
-Brent
-
1
- #4
hey.
this is the cgi-perl script i use for my site...change the url and other headings and it shud work fine..
****************************************************
#!/usr/bin/perl
print "Content-type:text/html\n\n";
@t=`df | grep -v "Filesystem"`;
print <<EndOfHTML;
<html><head><title>Matrix's file system information</title></head>
<body background="<br>
<table bgcolor="#A0B0A0" cellpadding="3" align="center">
<tr bgcolor="#204D20"><td colspan="6"><h5></h5></td></tr>
<tr bgcolor="">
<td colspan="6" align="center" style="color: #000000">
<h2>Matrix's File system information</h2>
</td>
</tr>
<tr bgcolor="#204D20"><td colspan="6"><h5></h5></td></tr>
<tr colspan="6"></tr>
<tr bgcolor="#204D20">
<td align="center" style="color: #FFFFFF">
<h3>Filesystem</h3>
</td>
<td align="center" style="color: #FFFFFF">
<h3>No. of 1K Blocks</h3>
</td>
<td align="center" style="color: #FFFFFF">
<h3>Used Blocks</h3>
</td>
<td align="center" style="color: #FFFFFF">
<h3>Available Blocks</h3>
</td>
<td align="center" style="color: #FFFFFF">
<h3>% of Usage</h3>
</td>
<td align="center" style="color: #FFFFFF">
<h3>Mount Point</h3>
</td>
</tr>
EndOfHTML
foreach $i (@t)
{
print "<tr bgcolor=\"#A9D79F\">";
@i = split (' ', $i);
for ($x = 0; $x <= $#i; $x++)
{
print "<td align=\"center\"><h4>$i[$x]</h4></td>";
}
print "</tr>";
}
print <<EndOfHTML2;
<tr bgcolor="#204D20"><td colspan="6"><h5></h5></td></tr>
<tr bgcolor="">
<td colspan="6" align="center" style="color: #000080">
<a href=" || <a href=" </td>
</tr>
<tr bgcolor="#204D20"><td colspan="6"><h5></h5></td></tr>
</table>
</body>
</html>
EndOfHTML2
****************************************************
this is the cgi-perl script i use for my site...change the url and other headings and it shud work fine..
****************************************************
#!/usr/bin/perl
print "Content-type:text/html\n\n";
@t=`df | grep -v "Filesystem"`;
print <<EndOfHTML;
<html><head><title>Matrix's file system information</title></head>
<body background="<br>
<table bgcolor="#A0B0A0" cellpadding="3" align="center">
<tr bgcolor="#204D20"><td colspan="6"><h5></h5></td></tr>
<tr bgcolor="">
<td colspan="6" align="center" style="color: #000000">
<h2>Matrix's File system information</h2>
</td>
</tr>
<tr bgcolor="#204D20"><td colspan="6"><h5></h5></td></tr>
<tr colspan="6"></tr>
<tr bgcolor="#204D20">
<td align="center" style="color: #FFFFFF">
<h3>Filesystem</h3>
</td>
<td align="center" style="color: #FFFFFF">
<h3>No. of 1K Blocks</h3>
</td>
<td align="center" style="color: #FFFFFF">
<h3>Used Blocks</h3>
</td>
<td align="center" style="color: #FFFFFF">
<h3>Available Blocks</h3>
</td>
<td align="center" style="color: #FFFFFF">
<h3>% of Usage</h3>
</td>
<td align="center" style="color: #FFFFFF">
<h3>Mount Point</h3>
</td>
</tr>
EndOfHTML
foreach $i (@t)
{
print "<tr bgcolor=\"#A9D79F\">";
@i = split (' ', $i);
for ($x = 0; $x <= $#i; $x++)
{
print "<td align=\"center\"><h4>$i[$x]</h4></td>";
}
print "</tr>";
}
print <<EndOfHTML2;
<tr bgcolor="#204D20"><td colspan="6"><h5></h5></td></tr>
<tr bgcolor="">
<td colspan="6" align="center" style="color: #000080">
<a href=" || <a href=" </td>
</tr>
<tr bgcolor="#204D20"><td colspan="6"><h5></h5></td></tr>
</table>
</body>
</html>
EndOfHTML2
****************************************************
-
3
- #5
This ksh script will take the output from df and produce a html page with all the columns aligned and a bar graph showing disk capacity. Try it!
#!/usr/bin/ksh
exec 3> df.html
print -u3 '<HTML><HEAD><TITLE>STATS</TITLE></HEAD><BODY>'
print -u3 '<H3>'$(uname -n)'</H3><TABLE BORDER=2 CELLSPACING=0 CELLPADDING=2>'
print -u3 '<TR><TH>Filesystem</TH><TH>1024-blocks</TH><TH>Used</TH>'
print -u3 '<TH>Available</TH><TH>Capacity</TH><TH>Mounted On</TH></TR>'
df -Pkl |awk 'NR>1 && NF==6'|sort|while read FS SIZE USED FREE PERC MOUNT
do
print -u3 '<TR><TD>'$FS'</TD><TD ALIGN=RIGHT>'$SIZE'</TD>'
print -u3 '<TD ALIGN=RIGHT>'$USED'</TD><TD ALIGN=RIGHT>'$FREE'</TD>'
print -u3 '<TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=0><TR>'
print -u3 '<TD WIDTH='$((150*$USED/$SIZE))' BGCOLOR="black"></TD>'
print -u3 '<TD WIDTH='$((150*$FREE/$SIZE))' BGCOLOR="gray"></TD>'
print -u3 '<TD><FONT SIZE=-1 COLOR=black> '$PERC'</FONT></TD>'
print -u3 '<TR></TABLE></TD><TD>'$MOUNT'</TD></TR>'
done
print -u3 '</TABLE><P>Generated at '$(date '+%H:%M on %d-%b-%y')'</BODY></HTML>'
exec 3<&-
#!/usr/bin/ksh
exec 3> df.html
print -u3 '<HTML><HEAD><TITLE>STATS</TITLE></HEAD><BODY>'
print -u3 '<H3>'$(uname -n)'</H3><TABLE BORDER=2 CELLSPACING=0 CELLPADDING=2>'
print -u3 '<TR><TH>Filesystem</TH><TH>1024-blocks</TH><TH>Used</TH>'
print -u3 '<TH>Available</TH><TH>Capacity</TH><TH>Mounted On</TH></TR>'
df -Pkl |awk 'NR>1 && NF==6'|sort|while read FS SIZE USED FREE PERC MOUNT
do
print -u3 '<TR><TD>'$FS'</TD><TD ALIGN=RIGHT>'$SIZE'</TD>'
print -u3 '<TD ALIGN=RIGHT>'$USED'</TD><TD ALIGN=RIGHT>'$FREE'</TD>'
print -u3 '<TD><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=0><TR>'
print -u3 '<TD WIDTH='$((150*$USED/$SIZE))' BGCOLOR="black"></TD>'
print -u3 '<TD WIDTH='$((150*$FREE/$SIZE))' BGCOLOR="gray"></TD>'
print -u3 '<TD><FONT SIZE=-1 COLOR=black> '$PERC'</FONT></TD>'
print -u3 '<TR></TABLE></TD><TD>'$MOUNT'</TD></TR>'
done
print -u3 '</TABLE><P>Generated at '$(date '+%H:%M on %d-%b-%y')'</BODY></HTML>'
exec 3<&-
- Thread starter
- #6
Thanks Sosatan and Ygor:
Very nice, both scripts. I especially liked the bar graph on Ygor's report. These are helpful to see other methods of improving a simple df output and all of the tools you all are using.
Ygor, I have never used the exec command before, could you explain the "exec 3" part of the script. It appears that you are defining 3 as output to a file df.html, then at the end "exec 3<&-" is running all of the preceding lines as input "-" to "3", and running it as a background process using "&". So does "exec 3" mean to run everything up to the next "exec 3"?
I appreciate your time and knowledge.
-Brent
Very nice, both scripts. I especially liked the bar graph on Ygor's report. These are helpful to see other methods of improving a simple df output and all of the tools you all are using.
Ygor, I have never used the exec command before, could you explain the "exec 3" part of the script. It appears that you are defining 3 as output to a file df.html, then at the end "exec 3<&-" is running all of the preceding lines as input "-" to "3", and running it as a background process using "&". So does "exec 3" mean to run everything up to the next "exec 3"?
I appreciate your time and knowledge.
-Brent
- Status
Similar threads
- Locked
- Question
- Locked
- Question