#!/bin/ksh
# File	: ana_ndmp_backups.ksh
# By	: Maarten.deBoer@Atos.net, 111027
# Subject	: Analyze NDMP-Tape backups of sev. volumes.
#		  Amount (MBs) & Speed (Start - End)
# In dezelfde maand. Dus aan het einde van een maand draaien.
#
PGM="`basename $0`"
TMP="/tmp/${PGM}.$$"
SSH="/usr/bin/ssh -n"
MAILTO="maarten.deboer@atos.net"
BCKLIST="$HOME/etc/check_ndmp_backups.out.ok"
FILTER="[1234567890]*"
FILERS="$HOME/etc/filers"
MON="`date +%b`"

#FILTER="naf02"


for FILER in `cat ${FILERS}|grep -v \^#|grep ${FILTER}`
do
  echo "# Filer ; Day ; MBs ; " > ${TMP}.MBs
  echo "# Filer ; Day ; Start time ; End time ; MBs ; " > ${TMP}.out
  touch ${TMP} 
  echo "${FILER} ..."

# Get from filer the volumes
  ${SSH} ${FILER} rdfile /etc/log/backup.5 > ${TMP}
  ${SSH} ${FILER} rdfile /etc/log/backup.4 >> ${TMP}
  ${SSH} ${FILER} rdfile /etc/log/backup.3 >> ${TMP}
  ${SSH} ${FILER} rdfile /etc/log/backup.2 >> ${TMP}
  ${SSH} ${FILER} rdfile /etc/log/backup.1 >> ${TMP}
  ${SSH} ${FILER} rdfile /etc/log/backup.0 >> ${TMP}
  ${SSH} ${FILER} rdfile /etc/log/backup >> ${TMP}

  grep ${FILER} ${BCKLIST}|grep 'Done'|while read LINE
  do
    VOL="`echo ${LINE} | awk -F\: '{print $2}'`"
    echo "${FILER} ${VOL} ..."

    grep ${VOL} ${TMP}|grep ${MON}|grep Start|awk '{print $7";"$4";"$5";_; "$10";"}' >> ${TMP}.out
    grep ${VOL} ${TMP}|grep ${MON}|grep End  |awk '{print $7";"$4";_; "$5";"$9" "$10";"}' >> ${TMP}.out
    grep ${VOL} ${TMP}|grep ${MON}|grep End|grep MB|awk '{print $7";"$4";"$9";"}'|sed -e 's/(//g'|sed -e 's/ MB)//g' >> ${TMP}.MBs

    echo "/vol/${VOL}/ \c ;" >> ${TMP}.MBs
    ${SSH} ${FILER} df -m ${VOL}|grep -v used|grep -v snapshot|awk '{print ";used; ;"$3}'|sed -e 's/MB//g' >> ${TMP}.MBs

  done  # grep

  cat ${TMP}.out|sort|uuencode ${FILER}_start-end-speed.csv|mailx -s "Ana bck filer (start-end-speed) ${FILER} [${PGM}]" ${MAILTO}
  cat ${TMP}.MBs|uuencode ${FILER}_vol-MBs.csv|mailx -s "Ana bck filer (MBs/bck & vol-used) ${FILER} [${PGM}]" ${MAILTO}

  rm ${TMP} ${TMP}.out ${TMP}.MBs
done  # for


exit 0