Aptare (and Bocada BackupReporter, and EMC's new reporting product, and
so forth) are all doing something mind-numbingly simple to get this
information: they either run bpdbjobs -report -all_columns (you may only
need -most_columns) or query the (no API explicitly provided by
Symantec, so do so at your own risk) underlying job DB and reformat the
data.
Getting "just the previous day" out of bpdbjobs is a bit more
complicated, partly because it doesn't take -s/d and -e flags, as many
of the NBU CLI utilities do), but also because the definition of "day"
of backups will vary by site (based on your business's idea of a backup
window), but if you're comfortable doing math in seconds-since-epoch,
it's not hard.
The -all_columns format used to be described decently in the bpdbjobs
man page, but it appears, on the NBU 6.5 and 6.5.1 systems I just look
at, that that file is mangled in the distribution media. Cute. (It was
still there in full in 5.1MP5, I believe.)
That said, for what Anil's asking here, simply configuring
BPDBJOBS_COLDEFS in bp.conf (which is described in the Unix/Linux Admin
Guide vol II) and running regular old bpdbjobs should be enough.
--
gabriel rosenkoetter
Radian Group Inc, Unix/Linux/VMware Sysadmin / Backup & Recovery
gabriel.rosenkoetter AT radian DOT biz, 215 231 1556
________________________________
From: ckstehman AT pepco DOT com [mailto:ckstehman AT pepco DOT com]
Sent: Friday, May 30, 2008 10:53 AM
To: ANIL555 AT MAURYA DOT US
Cc: veritas-bu AT mailman.eng.auburn DOT edu;
veritas-bu-bounces AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] One report with all client backup report
withtheir success or failure
This probably won't be much help but we get a daily report from Aptare
that shows exactly what you want.
The following list of server backups WERE NOT successful:
ep-wvt-ap38a 58 bsmaster 29-MAY-08 17:56:30
ep-wvt-ap79 58 bsmaster 29-MAY-08 17:56:20
NOTICE: The following list of server backups completed successfully:
bsmaster 1 bsmaster 29-MAY-08 18:57:10
bsmaster 1 bsmaster 29-MAY-08 19:05:20
bsmaster 1 bsmaster 29-MAY-08 19:12:30
cc-nta5 1 bsmaster 29-MAY-08 21:03:20
etc - etc...
It shows client name, status and completion time and date
The report runs a query against the database into a text file which can
be e-mailed
=============================
Carl Stehman
IT Distributed Services Team
Pepco Holdings, Inc.
202-331-6619
Pager 301-765-2703
ckstehman AT pepco DOT com
ANIL555 AT MAURYA DOT US
Sent by: veritas-bu-bounces AT mailman.eng.auburn DOT edu
05/30/2008 10:03 AM
To
veritas-bu AT mailman.eng.auburn DOT edu
cc
Subject
[Veritas-bu] One report with all client backup report with their
success or failure
Hi
I am good in writing script in TSM but not in NBU. I want to write
script or other easy way which will email one report every morning which
will have one line for each client saying whether backup Failed,
Completed or Missed with their status next to each client name . Is
there way ?
Report should look like
===================
Backup Start Backup finish Client Name
Status
-------------------- -------------------- -------------
-------------
05/27/08 18:00:00 05/27/08 18:12:05 BWPW37
Failed
05/27/08 18:00:00 05/27/08 18:03:52 BWPW59
Completed
Thanks again.
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
<http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu>
This Email message and any attachment may contain information that is
proprietary, legally privileged, confidential and/or subject to
copyright belonging to Pepco Holdings, Inc. or its affiliates ("PHI").
This Email is intended solely for the use of the person(s) to which it
is addressed. If you are not an intended recipient, or the employee or
agent responsible for delivery of this Email to the intended
recipient(s), you are hereby notified that any dissemination,
distribution or copying of this Email is strictly prohibited. If you
have received this message in error, please immediately notify the
sender and permanently delete this Email and any copies. PHI policies
expressly prohibit employees from making defamatory or offensive
statements and infringing any copyright or any other legal right by
Email communication. PHI will not accept any liability in respect of
such communications.
_______________________________________________
Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|
