Mark (and others),

Actually, I received more than a couple responses that suggested using
"bpdbjobs -all_columns" and then parsing from that. I have written the
first cut of a perl program that takes the output of that command and
presents it in an abridged and formatted manner. Still a couple more
things to do to refine it, but I think I'm on my way to what I need.

The problem with using the bpimage method is that some of the different
policies use tapes from the same pool. I don't have specific "offsite"
pools for tapes; the offsite tapes come from the same pools as the
onsite tapes, but they're rotated out for 90 days. So I needed a way to
search through the details of each full backup (as opposed to
incremental) to determine which tapes had been used and then report that
to me. I have been doing it manually with reading the "details" from the
Activity Monitor, but we've added quite a few systems and policies, and
it was quickly increasing the time required to derive which tapes to
pull.

However, I do *really* appreciate the offer for the "breadboard" and all
the other responses from the others on the list (you guys ROCK!). I'll
be happy to share what I have written when I am satisfied with it, too.

....k
-=-=-=-

-----Original Message-----
From: Mark.Donaldson AT cexp DOT com [mailto:Mark.Donaldson AT cexp DOT com] 
Sent: Tuesday, April 19, 2005 2:16 PM
To: Kevin Freels; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] Email reports

I've got the feeling you're overthinking this.  I don't think you have
to worry about the bpdbjobs output to get the media information for a
backup.
Especially for offsite purposes.

A typical offsite backup just writes the images to a tape that belongs
to a volume pool intended for offsites.  After that, it's simply a
matter of ejecting all tapes in that pool, boxing & sending.

When you talk about getting information for job/host, is it more useful
to get info by policy & host?  If so, you might want to look at the
"bpimagelist" command with the "-media" option.  This is an excellent
way to identify the media associated with a particular set of clients,
policies, etc.

SAGE: bpimagelist [-media] [-l|-L|-U|-idonly]
           [-d mm/dd/yyyy HH:MM:SS] [-e mm/dd/yyyy HH:MM:SS] [-hoursago
hours]
           [-keyword "keyword phrase"]
           [-client client_name] [-server server_name]
           [-backupid backup_id] [-option option_name]
           [-policy policy_name] [-pt policy_type]
           [-rl retention_level]
           [-sl sched_label] [-st sched_type]

If you can supply some more details, I might be able to breadboard
something together if you get stuck.

-M