On Wed, Aug 18, 2004 at 09:30:40AM -0500, James M Sherman wrote:
> 
> We need to generate reports showing failed and successful backups going back
> almost a year
> for several hosts in our NetBackup (4.5) environment.

If you haven't been collecting that information, I believe it's gone.
 
> 'bpdbjobs' data is only saved here for 10 days, and I'm not sure what
> the best method is to get this information... 'bplist' is great for
> showing individual files backed up going back forever, but is there a
> better summary report we can generate that just shows all backups
> completed on a given date for a given box?   How about failed backups
> also?

bplist isn't that great.  It doesn't tell you if the file was open while
you copied it, or if you got half a backup but had a tape failure in
between.  It doesn't tell you if the backup failed but immediately
retried and was successful.  It won't help you if you got most of the
files in an Oracle database - all you need to do is miss one archive log
and you're not recoverable.

> Thanks very much, sorry if I'm missing something obvious,

Short answer:  If management wants this level of historical detail, they
need to pay for some tools to allow you to produce those reports.
Aptare's StorageConsole is a great product...  It took me about 30
seconds to generate a report showing all failed backups per client -
what the error code was.  It doesn't have an option to ignore retries
yet - some of the other reports do.

Adding StorageConsole now won't help you answer the question for what
happened last year.  It *will* help you next year when they ask the same
question again.

-- 
Ed Wilts, Mounds View, MN, USA
mailto:ewilts AT ewilts DOT org