bpdbjobs query and scripting

[dnaflr2]

I have been tasked to query bpdbjobs regularly to report back all successful full backups of all clients. I have been staring at man for bpdbjobs and have found the command and options below, but I need more assistance massaging it for the desired results. Anyone currently have something similar working?

/usr/openv/netbackup/bin/admincmd/bpdbjobs -all_columns -M ${BACKUPSERVER}| cut -d, -f1-34 | awk -F, '{print $1, $4, $5, $6, $7, $33}'

[Darren_Dunham]

bpdbjobs has a very complex format if you're using 'all_columns' (which is necessary for some information).  Are you comfortable scripting in any particular language?

What data are you looking for that the script you show isn't giving you?

-- 

Darren

[J_H_Is_gone]

Have you tried <installdir>/openv/netbackup/bin/mail_bp_reports You get something like this.

STATUS CLIENT        POLICY           SCHED      SERVER      TIME COMPLETED 

0    server1         server1          Daily_Incr  meidaserver    02/10/2009 12:39:06 

196   server2         server2          Daily_Incr  mediaserver    02/10/2009 12:39:13                  (client backup was not attempted because backup window closed) 

0    exchserver1     Exchange_server  Daily_Full  mediaserver    02/10/2009 17:51:46 

0    exchserver1     Exchange_2007    Daily_Full  meidaserver    02/10/2009 17:57:03 

0    server3         Windows_Producti  Daily_Incr  mediaserver    02/10/2009 18:03:34