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

-----Original Message-----
From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]On Behalf Of Kevin
Freels
Sent: Monday, April 18, 2005 10:38 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Email reports


Greetings!!

I have more or less asked this question before. I looked through my
archives, but I didn't really find the answer I was looking for.

I want to have NB email the "details" of each individual backup job when
it completes to the admin email address. By this, I mean the same stuff
you would see if you went to the Activity Monitor and did a "details" on
any of the completed jobs. What I need is the ability to see what media
were used for what job so I can create a report each morning about what
tapes were used (by job/host) and need to be rotated out of the robot
(for off-site archives). I would also settle for individual emails from
each job (I could pipe that to a file and form my own "report" if
needed).

I looked through all the logs under netbackup/logs and really didn't see
anything separated by job ID. I imagine that bpend_notify can be
used/altered to do this, but where is the individual job ID info/history
kept? Is that actually under the db directory (didn't see anything
there)?

I'm wondering if bpdbjobs would be able to do this, but it seems to me
that command just lists the processes, not the details. Has anyone done
anything like this? I can parse out the detail info using perl if I have
to, but I'm really lazy and don't like to re-invent the wheel.  :-)

Again, thanks as always!


....k
-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-==-
Kevin Freels                         kfreels AT askjeeves DOT com
Senior UNIX SysAdmin                          510.985.7444
Ask Jeeves                                         ask.com
"We keep you alive to serve this ship. Row well and live."

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu