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
-----Original Message-----
From: veritas-bu-bounces AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-bounces AT mailman.eng.auburn DOT edu] On Behalf Of fullejn
Sent: Thursday, February 19, 2009 6:30 PM
To: VERITAS-BU AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Scripting bpdbjobs
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}'
+----------------------------------------------------------------------
|This was sent by joshua.n.fuller AT lmco DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu