report_hourly.sh

#!/bin/bash
#
# Daily Report
# by Ken O. Burtch
# Produce the daily email report as well as update the web dashboard.
#############################################################################

# If a non-empty string, runs the report for testing.

DRY_RUN=

# The location of the web dashboard.

cd "utils"
WEBROOT=`/usr/local/bin/spar export_dashboard_file_path.sp`
if [ -z "$WEBROOT" ] ; then
   echo "Could not lookup web dashboard location" 2>&1
   exit 1
fi
cd ..

# Yesterday, and just after midnight today

REPORT_DATE_TODAY=`date '+%m/%d'`" 00:"
REPORT_DATE_YESTERDAY=`date --date 'yesterday' '+%m/%d'`
TMP_DIR="run"
TMP1="$TMP_DIR""/""tmp1.$$"
TMP2="$TMP_DIR""/""tmp2.$$"
TMP3="$TMP_DIR""/""tmp3.$$"
TMP_BLK="$TMP_DIR""/""tmp_blk"

HS="$WEBROOT""/""hourly_summary.frag"

# For the ipset block list, there's 8 lines of headers

CURRENT_BLOCKS=`/sbin/ipset -L blocklist  | wc -l`
let "CURRENT_BLOCKS=CURRENT_BLOCKS-8"
TOTAL_ON_FILE=`cat /root/ssds/data/blocking_cnt.txt`
TOTAL_LOGINS=`cat /root/ssds/data/login_cnt.txt`
DISK_USAGE=`du -sh /root/ssds/data | cut -f1`

if [ "$CURRENT_BLOCKS" -gt 25000 ] ; then
   BGCOLOR="background-color: red"
elif [ "$CURRENT_BLOCKS" -gt 12000 ] ; then
   BGCOLOR="background-color: orange"
elif [ "$CURRENT_BLOCKS" -eq 0 ] ; then
   BGCOLOR="background-color: red"
fi


echo > "$HS"
echo '<div class="kpi_box">' >> "$HS"
echo '<div class="kpi_header">'"<b>Last Hour</b></div>" >> "$HS"
echo '<div style="width:100%; height: 100%">' >> "$HS"
echo '<table style="border: none; padding: 0; border-collapse: collapse; margin:0 auto">' >> "$HS"

BLOCKS_LIMIT=`/usr/local/bin/spar utils/export_blocks_limit.sp`
BGCOLOR="background-color: transparent"
if [ $CURRENT_BLOCKS -ge "$BLOCKS_LIMIT" ] ; then
   BGCOLOR="background-color: red"
   /usr/local/bin/spar utils/blocks_limit.sp
fi

echo "<tr>" >> "$HS"
echo '<td class="kpi_layout"><span class="plain_data" style="'"$BGCOLOR"'">'"$CURRENT_BLOCKS""</span>""</td><td>"'<span class="plain_light">'" Currently Blocked""</span>""</td>" >> "$HS"
echo "</tr><tr>" >> "$HS"
echo '<td class="kpi_layout"><span class="plain_data">'"$TOTAL_ON_FILE""</span>""</td><td>"'<span class="plain_light">'" Monitored""</span>""</td>" >> "$HS"
echo "</tr><tr>" >> "$HS"
echo '<td style="text-align:right; min-width: 50px; padding-right: 3px;">''<span class="plain_data">'"$TOTAL_LOGINS""</span>""</td><td>""<span class="plain_light">""Usernames""</span>""</td>" >> "$HS"
echo "</tr><tr>" >> "$HS"

SPACE_LIMIT=`/usr/local/bin/spar utils/export_space_limit.sp`
BGCOLOR="background-color: transparent"
DISK_USAGE=`echo "$DISK_USAGE" | cut -d. -f1` # number could be float
TMP="${DISK_USAGE%M}" # Strip units (M) from amount
if [ $TMP -ge "$SPACE_LIMIT" ] ; then
   BGCOLOR="background-color: red"
   /usr/local/bin/spar utils/space_limit.sp
fi

echo '<td class="kpi_layout">''<span class="plain_data" style="'"$BGCOLOR"'">'"$DISK_USAGE""</span>""</td><td>"'<span class="plain_light">'"Storage Used""</span>""</td>" >> "$HS"
echo "</tr>" >> "$HS"
echo "</table>" >> "$HS"
echo "</div>" >> "$HS"
echo "</div>" >> "$HS"