Try a variation of the awk script below.  This one lists failures in an
abbreviated table.

/usr/openv/netbackup/bin/admincmd/bpdbjobs -report |
awk '
BEGIN   {
        {print "\nClient    Class                Kbytes       Stat
Duration  Start         End         Sched   StorUnit   MServ\n"}
        }
        {
# when there are 11 fields check for partly successful and failed backups
        if ( $11 ~ /Done/ && $5 > 0)
        {printf"%-10s%
-20s%11.0f%6s%10s%8s%6s%8s%6s%6s%12s%10s\n",$2,$3,$4,$5,substr
($6,0,5),substr($7,0,5),substr($8,0,5),substr($9
,0,5),substr($10,0,5),$12,$13,$14}
#  when there are 10 fields, make sure 4th field is a valid status code
before printing
        else if ( $10 ~ /Done/ && $4 < 256 )
{printf"%-10s%-31s%6s%10s%8s%6s%8s%6s%6s%12s%10s\n",$2,$3,$4,substr
($5,0,5),substr($6,0,5),substr($7,0,5),substr($8,0,5),substr($9,0
,5),$11,$12,$13}
        }'
#END    {
#               {print "  "}
#       }
#       '
/usr/openv/netbackup/bin/admincmd/bpdbjobs -summary

-------------------------------------------------------------------------------------------------

John P. Vrla                 Infrastructure Analyst
CETS/GIS/IFS            Unix-MidRange Computing Skill Center
214-951-4736              Dallas/Pegasus Place/B-7-W39
--------------------------------------------------------------------------------------------------