This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C4ABAF.F33D38DE
Content-Type: text/plain;
charset="iso-8859-1"
You could count it from the image list. Errors 0 (successful) & 1 (almost
successful) generate images which can be counted - add your failure count to
it to make a total.
bpimagelist -hoursago 24 | grep -c "^IMAGE"
Another method, somewhat cleaner, could be using the "bperror -hoursago 24
<other opts>" to gather your info & parse.
bperror -hoursago 24 | awk '$17=="EXIT" && $18=="STATUS" {if($19<2){good++}
else{bad++}}
END {print "Good: "good" Bad: "bad" => "int(good/(good+bad)*100)"% s
uccess."}'
Output looks like:
Good: 1011 Bad: 28 => 97% success.
HTH - 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 Hardy,
Andrew
Sent: Wednesday, October 06, 2004 7:32 AM
To: Netbackup managers
Subject: [Veritas-bu] Bpdbjobs database file ??
All,
I have a script which reports the number of all backup stream failures, over
a 24 hour period, between 08:00am & 08:00am every day.
However, in order for me to easily report on percentage failures of all
streams during that period, I need to be able to find out the total number
of streams (successful or failed) during that period.
Getting the failed jobs is easy, because there is a daily log file which is
created in /usr/openv/netbackup/db/failure_history.
Getting the total number of jobs which ran between these times, is however
proving a little more difficult !! I have tried running the bpdbjobs
command with all the options, but cannot seem to find an output which shows
the start time of each stream.
I guess there must be a file somewhere which has this info, since the GUI
reports this from somewhere, but I cannot find out where it is .......
Can anyone help
Many Thanks
Andy Hardy
Andy Hardy
Technical Specialist, Data Storage Services,
Marks & Spencer PLC, 3 Longwalk Road,Room 1SW,
Stockley Park, Uxbridge,Middesex,UB11 1AW.
* 020 8718 5975
* 07733 333324
* <mailto:andrew.hardy AT marks-and-spencer DOT com>
mailto:andrew.hardy AT marks-and-spencer DOT com
_____
Registered Office:
Marks and Spencer plc
Waterside House
35 North Wharf Road
London
W2 1NW
Registered No. 214436 in England and Wales.
Telephone (020) 7935 4422
Facsimile (020) 7487 2670
www.marksandspencer.com
Please note that electronic mail may be monitored.
This e-mail is confidential. If you received it by mistake, please let us
know and then delete it from your system; you should not copy, disclose, or
distribute its contents to anyone nor act in reliance on this e-mail, as
this is prohibited and may be unlawful.
The registered office of Marks and Spencer Financial Services PLC, Marks and
Spencer Unit Trust Management Limited, Marks and Spencer Life Assurance
Limited and Marks and Spencer Savings and Investments Limited is Kings
Meadow, Chester, CH99 9FB. These firms are authorised and regulated by the
Financial Services Authority.
------_=_NextPart_001_01C4ABAF.F33D38DE
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Bpdbjobs database file ??</TITLE>
<META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=051251514-06102004>You
could count it from the image list. Errors 0 (successful) & 1 (almost
successful) generate images which can be counted - add your failure count to it
to make a total.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=051251514-06102004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=051251514-06102004>bpimagelist -hoursago 24 | grep -c
"^IMAGE"</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=051251514-06102004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=051251514-06102004>Another method, somewhat cleaner, could be using
the "bperror -hoursago 24 <other opts>" to gather your info &
parse.</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=051251514-06102004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=051251514-06102004>bperror -hoursago 24 | awk '$17=="EXIT" &&
$18=="STATUS" {if($19<2){good++}<BR>else{bad++}}</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=051251514-06102004>END
{print "Good: "good" Bad: "bad" => "int(good/(good+bad)*100)"%
s<BR>uccess."}'<BR></DIV></SPAN></FONT>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=051251514-06102004>Output
looks like:</SPAN></FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN
class=051251514-06102004></SPAN></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=051251514-06102004>Good:
1011 Bad: 28 => 97% success.<BR></DIV></SPAN></FONT>
<DIV><FONT face=Arial color=#0000ff size=2><SPAN class=051251514-06102004>HTH -
M</DIV></SPAN></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu]<B>On Behalf Of
</B>Hardy,
Andrew<BR><B>Sent:</B> Wednesday, October 06, 2004 7:32 AM<BR><B>To:</B>
Netbackup managers<BR><B>Subject:</B> [Veritas-bu] Bpdbjobs database file
??<BR><BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>All,</FONT> </P>
<P><FONT face=Arial size=2>I have a script which reports the number of all
backup stream failures, over a 24 hour period, between 08:00am & 08:00am
every day.</FONT></P>
<P><FONT face=Arial size=2>However, in order for me to easily report on
percentage failures of all streams during that period, I need to be able to
find out the total number of streams (successful or failed) during that
period.</FONT></P>
<P><FONT face=Arial size=2>Getting the failed jobs is easy, because there is
a
daily log file which is created in
/usr/openv/netbackup/db/failure_history.</FONT></P>
<P><FONT face=Arial size=2>Getting the total number of jobs which ran between
these times, is however proving a little more difficult !! I have tried
running the bpdbjobs command with all the options, but cannot seem to find an
output which shows the start time of each stream.</FONT></P>
<P><FONT face=Arial size=2>I guess there must be a file somewhere which has
this info, since the GUI reports this from somewhere, but I cannot find out
where it is .......</FONT></P>
<P><FONT face=Arial size=2>Can anyone help </FONT></P>
<P><FONT face=Arial size=2>Many Thanks</FONT> </P>
<P><FONT face=Arial size=2>Andy Hardy</FONT> </P><BR><BR>
<UL>
<P><SPAN lang=en-us><B><FONT face="Times New Roman" size=2>Andy
Hardy</FONT></B></SPAN> <BR><SPAN lang=en-us><FONT face="Times New Roman"
size=2>Technical Specialist, Data Storage Services,</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face="Times New Roman" size=2>Marks & Spencer PLC, 3
Longwalk Road,Room 1SW,</FONT></SPAN> <BR><SPAN lang=en-us><FONT
face="Times New Roman" size=2>Stockley Park, Uxbridge,Middesex,UB11
1AW.</FONT></SPAN> <BR><SPAN lang=en-us><FONT face=Wingdings
color=#800000>(<FONT face="Courier New"></FONT></FONT> <FONT
face="Times New Roman" size=2>020 8718 5975</FONT></SPAN> <BR><SPAN
lang=en-us><FONT face=Wingdings color=#800000>(<FONT
face="Courier New"></FONT></FONT> <FONT face="Times New Roman" size=2>07733
333324</FONT><B></B></SPAN> </P></UL>
<P><SPAN lang=en-us><FONT face=Wingdings color=#0000ff>+<FONT
face="Courier New"></FONT></FONT> </SPAN><A
href="mailto:andrew.hardy AT marks-and-spencer DOT com"><SPAN
lang=en-us><U></U><U><FONT face="Times New Roman" color=#0000ff
size=2>mailto:andrew.hardy AT marks-and-spencer DOT
com</FONT></U></SPAN></A><SPAN
lang=en-us></SPAN> </P><BR><BR>
<HR>
<P><BR>Registered Office:<BR>Marks and Spencer plc<BR>Waterside House<BR>35
North Wharf Road<BR>London<BR>W2 1NW<BR><BR>Registered No. 214436 in England
and Wales.<BR><BR>Telephone (020) 7935 4422<BR>Facsimile (020) 7487
2670<BR><BR>www.marksandspencer.com<BR><BR>Please note that electronic mail
may be monitored.<BR><BR>This e-mail is confidential. If you received it by
mistake, please let us know and then delete it from your system; you should
not copy, disclose, or distribute its contents to anyone nor act in reliance
on this e-mail, as this is prohibited and may be unlawful.<BR><BR>The
registered office of Marks and Spencer Financial Services PLC, Marks and
Spencer Unit Trust Management Limited, Marks and Spencer Life Assurance
Limited and Marks and Spencer Savings and Investments Limited is Kings
Meadow,
Chester, CH99 9FB. These firms are authorised and regulated by the Financial
Services Authority. <BR><BR></P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C4ABAF.F33D38DE--
|