We used the following (dirty) UNIX script on a daily basis utilising the bperror command mentioned by Flako (it does not, however, detail the last successful client backup - I'll leave that to you!) (EDIT: but you could incorporate, for each failed client, bpimagelist -U -client $CLIENT -d 12/31/12 | head -3 | tail -1 or something more appropriate to yourself?)
bperror -backstat -U| awk '($1 > 1) {print $0}'|cut -c8-20|grep -v \
CLIENT|sort -u > failed_clients
if [ ! -s /app/site/scripts/failed_clients ]
then
echo "No clients have had any failed jobs in the last 24 hours"
rm failed_clients
exit
fi
echo "The following clients have had one or more failed jobs in the \
last 24 hours"
echo "**************************************************************\
*************"
echo
cat failed_clients|
while read CLIENT
do
echo
echo "JOBS RUN FOR CLIENT $CLIENT"
echo "*********************************"
bperror -backstat -client $CLIENT| cut -d " " -f6 | sort -u > \
failed_jobid
cat failed_jobid|
while read JOB_ID
do
echo
echo "JOB_ID $JOB_ID"
bperror -backstat -U -jobid $JOB_ID
done
done
rm failed_clients
rm failed_jobid
It *will* also report if said failed job re-started & completed successfully (using the same job_id)
(***EDIT #2: just realised OP is nearly 2 months old & no return since - hopefully managed to work something out!)
