scripting help to capture backs of 32 KB only 1

[CalgaryCR9]

When something goes wrong with our filers (backup destination) we end up with backups of 32 KB only in our reports.

I want to be able to capture in a report only those policies that report 32KBs only. I'm stumped on how to write a script for this. Help greatly appreciated!

current bp.conf below:
pd7bs2no>more bp.conf
SERVER = pd7bs2no
CLIENT_NAME = localhost
EMMSERVER = pd7bs2no
VXDBMS_NB_DATA = /usr/openv/db/data
VERBOSE = 3
BPDBJOBS_COLDEFS = Status 4 true
BPDBJOBS_COLDEFS = Policy 10 true
BPDBJOBS_COLDEFS = Schedule 16 true
BPDBJOBS_COLDEFS = Client 8 true
BPDBJOBS_COLDEFS = Media_Server 12 true
BPDBJOBS_COLDEFS = Started 10 true
BPDBJOBS_COLDEFS = Elapsed 10 true
BPDBJOBS_COLDEFS = Kilobytes 12 true
BPDBJOBS_COLDEFS = Files 10 true
BPDBJOBS_COLDEFS = KBperSec 6 true
VERBOSE = 3

 

[AnotherAlan]

Well here is a start;

bpdbjobs | awk '/Backup/ && $9<=32 {print $0}'

Hope this helps.
Al

 

[CalgaryCR9]

Al,

You so pointed me in the right direction and now are my hero of the day. Thank you so very much.

bpdbjobs |grep `date +"%D"` |awk '$8<=32 {print $2,$3,$5,$8}' | sort $1

Gives me exactly what I was looking for.
ims2-00 Differential-Inc 11/03/08 32
ims2-01 Differential-Inc 11/03/08 32
ims2-02 Differential-Inc 11/03/08 32
ims2-03 Differential-Inc 11/03/08 32
ims2-04 Differential-Inc 11/03/08 32
ims2-05 Differential-Inc 11/03/08 32
ims2-06 Differential-Inc 11/03/08 32
ims2-07 Differential-Inc 11/03/08 32
ims2-08 Differential-Inc 11/03/08 32
ims2-09 Differential-Inc 11/03/08 32
ims2-10 Differential-Inc 11/03/08 32
ims2-11 Differential-Inc 11/03/08 32
ims2-12 Differential-Inc 11/03/08 32
ims2-13 Differential-Inc 11/03/08 32
ims2-14 Differential-Inc 11/03/08 32
ims2-15 Differential-Inc 11/03/08 32
ims2-16 Differential-Inc 11/03/08 32
ims2-17 Differential-Inc 11/03/08 32
ims2-18 Differential-Inc 11/03/08 32
ims2-19 Differential-Inc 11/03/08 32