maniu@securebrain.com:~/dataprotector# vi backup_report.sh 




# the report page is /tmp/backup_report.html
CURRENT_TIME=`date`

# replace with your datalists 
DATALISTS="DATA1 \
DATA2 \
DATA3 \
DATA4 \
DATA5 \
DATA6 \
DATA7 \
DATA8 \
DATA9 \
DATA10 \
DATA11 \
DATA12 \
DATA13 \
DATA14 \
DATA15 \
DATA16 \
DATA17 \
DATA18 \
DATA19 \
DATA20 \
DATA21"

DIR=/tmp
cat /dev/null >  $DIR/backup_report.html
cat /dev/null >  $DIR/backup_result
cat /dev/null >  $DIR/backup_session
cat /dev/null >  $DIR/backup_date

echo "<HTML>\n" >> $DIR/backup_report.html
echo "<HEAD>\n" >> $DIR/backup_report.html
echo "<TITLE>Backup Daily  Report</TITLE>\n" >> $DIR/backup_report.html
echo "<STYLE>\n" >> $DIR/backup_report.html
echo "H1       {\n     color: #000000;\n       }\n
        H2 {\n     color: #000000;\n       }\n
        H3 {\n     color: #000000;\n       }\n
        H6 {\n     color: #55188A;\n       }\n" >> $DIR/backup_report.html
echo "</STYLE>" >> $DIR/backup_report.html
echo "</HEAD>\n" >> $DIR/backup_report.html
echo "<BODY TEXT="#000000" BGCOLOR="#FFFFFF" LINK="#0000EF" VLINK="#55188A" ALINK="#FF0000">" >> $DIR/backup_report.html
echo "<h1>" >> $DIR/backup_report.html
echo "<center>" >> $DIR/backup_report.html
echo "Backup Daily Report" >> $DIR/backup_report.html
echo "<H6 align=\"center\">latest check: $CURRENT_TIME</H6>\n">> $DIR/backup_report.html
echo "</center>">> $DIR/backup_report.html
echo "</h1>">> $DIR/backup_report.html
echo "<br>" >> $DIR/backup_report.html
echo "<br>" >> $DIR/backup_report.html
echo "<br>" >> $DIR/backup_report.html
echo "<UL>"  >> $DIR/backup_report.html
echo "<H3><pre><FONT COLOR=#FF0000> Datalist               Session           Status \
                 Start       Stop      Size MB</FONT></pre></H3>">> $DIR/backup_report.html
for u in  $DATALISTS
do
/opt/omni/bin/omnidb -session -datalist $u -latest |  tail -1 | awk '{print $1}' >> $DIR/backup_session
done
for i in $DATALISTS
do
/opt/omni/bin/omnidb -session -datalist $i -latest |  tail -1 |awk -v GG=$i '{ if ($3 == "Failed" || $3 == "Aborted" )\
 {printf "%s %-22s: %-15s %s %-18s %s\n", "<LI><H3><pre>", \ 
 GG, $1 ,"<FONT COLOR=#F00000>", $3 ,"</FONT>"} else  { if  ($3 == "In" || $3 == "Mount")\ 
 {printf "%s %-22s: %-15s %s %s %-15s %s\n", "<LI><H3><pre>", GG , $1,"<FONT COLOR=#FFd000>", $3, $4, "</FONT>"} else \
 {printf "%s %-22s: %-15s %s %-18s %s\n", "<LI><H3><pre>", GG , $1,"<FONT COLOR=#009900>", $3, "</FONT>"} } }' \
 >> $DIR/backup_result 2> /dev/null
done
for SESSION in `cat $DIR/backup_session`
do
LINESTART=`/opt/omni/bin/omnidb -session $SESSION -report |grep -n "STARTING Media Agent"|awk -F : '{print $1}'`
START=`/opt/omni/bin/omnidb -session $SESSION -report | head -$LINESTART |tail -2 | awk -F' ' '{print $7}'`
LINESTOP=`/opt/omni/bin/omnidb -session $SESSION -report |grep -n "COMPLETED Media Agent" |awk -F : '{print $1}'`
STOP=`/opt/omni/bin/omnidb -session $SESSION -report | head -$LINESTOP |tail -2 |grep -v "COMPLETED Media Agent"| awk -F' ' '{print $7}'`
SIZE=`/home/mital/size_backup.sh -session $SESSION`
echo "$START   $STOP    $SIZE</pre></H3>" >> $DIR/backup_date
done
/usr/bin/paste $DIR/backup_result $DIR/backup_date >>  $DIR/backup_report.html
echo "</UL>"  >> $DIR/backup_report.html
echo "</BODY>\n" >> $DIR/backup_report.html
echo "</HTML>" >> $DIR/backup_report.html



:q!