OK all,
Here's the script I use for the e-mail output. This is a Kornshell script for Unix. You can use it on NT/Win2k if you download UWin from
This is KornShell for Windows. Please post your thoughts after you use it.
You need to create the following directories first:
/opt/openv/netbackup/logs/bpbkar
/opt/openv/netbackup/logs/bptm
/opt/openv/netbackup/logs/oldlogs/bpbkar
/opt/openv/netbackup/logs/oldlogs/bptm
#!/usr/bin/ksh
#
# file: veritas.email.sh
#
# Description:
# This script takes portions of two different veritas NetBackup reports
# and forms a comprehensive output to E-Mail after the Backup finishes.
# Then it deletes reports older than 3 days as they can get kinda big.
#
# History:
# 02/26/01 JRO - Created
#
TODAY=`date +%m%d%y`
MAILFILE=/usr/local/bin/veritas.out
WORKDIR="/opt/openv/netbackup/logs"
OLDLOGDIR="${WORKDIR}/oldlogs"
WORKFILE="log.${TODAY}"
date > ${MAILFILE}
echo "" >> ${MAILFILE}
cd ${WORKDIR}/bpbkar
# If the backup creates more than one log
# this will put all the logs into one
onefile() {
>log.temp
for LOGFILES in `ls|grep -v log.temp`
do
cat $LOGFILES >> log.temp
rm $LOGFILES
done
mv log.temp $WORKFILE
}
cd ${WORKDIR}/bptm
onefile
cd ${WORKDIR}/bpbkar
onefile
cd ${WORKDIR}/bpbkar
for BUPID in `grep -w BACKUPID $WORKFILE | awk '{ print $8 }' | cut -c10- | sort`
do
JOBPID=`grep -w $BUPID $WORKFILE | grep -w setenv | awk '{ print $2 }' | cut -c2-`
grep -w $JOBPID $WORKFILE | grep -w BACKUPID | cut -d" " -f1,8- > test.${TODAY}.${JOBPID}
grep -w $JOBPID $WORKFILE | grep -w Processing | cut -d" " -f1,7- >> test.${TODAY}.${JOBPID}
grep -w $BUPID ../bptm/$WORKFILE | grep -w write_backup | grep -w wrote.backup.id.${BUPID} | cut -d" " -f1,5- >> test.${TODAY}.${JOBPID}
grep -w $JOBPID $WORKFILE | grep -w EXIT.STATUS | cut -d" " -f1,7- >> test.${TODAY}.${JOBPID}
sort test.${TODAY}.${JOBPID} >> $MAILFILE
rm test.${TODAY}.${JOBPID}
echo "" >> $MAILFILE
done
echo "" >> $MAILFILE
echo "Statistics:" >> $MAILFILE
grep -w write_backup ${WORKDIR}/bptm/${WORKFILE} | grep -w multiplexed | cut -d" " -f1,5- >> ${MAILFILE}
echo "" >> $MAILFILE
echo "Media Used:" >> $MAILFILE
grep -w select_media ${WORKDIR}/bptm/${WORKFILE} | grep -w selected.media.id | cut -d" " -f1,5- >> $MAILFILE
echo "" >> $MAILFILE
echo "" >> $MAILFILE
/usr/openv/volmgr/bin/tpclean -L >> $MAILFILE
echo "" >> $MAILFILE
# E-mail the report
cat $MAILFILE | /usr/ucb/mail -s "`uname -n`: Veritas Backup - `date|cut -c5-`" root
# Clean up log directories
mv ${WORKDIR}/bpbkar/${WORKFILE} ${OLDLOGDIR}/bpbkar
mv ${WORKDIR}/bptm/${WORKFILE} ${OLDLOGDIR}/bptm
find ${OLDLOGDIR}/bp* -mtime +3 -type f -exec rm -f {} \;