Veritas-bu

[Veritas-bu] Daily batch of status notifications? NB 3.4

2002-10-29 14:06:11
Subject: [Veritas-bu] Daily batch of status notifications? NB 3.4
From: Mark.Donaldson AT experianems DOT com (Donaldson, Mark)
Date: Tue, 29 Oct 2002 12:06:11 -0700
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_01C27F7E.3E98E6D0
Content-Type: text/plain

Reposting a snipped copy for length limits...

I just reviewed the script I posted yesterday and found a problem.  I've
rewritten it to remove some of my site specific tape number stuff and clean
up a problem in the sorting routine that generates the server list.

NEW VERSION:
#!/bin/ksh

MAILADDR=YOU AT YOURDOMAIN DOT COM
PATH=$PATH:/usr/openv/netbackup/bin/admincmd
TMPFILE=/var/tmp/`basename $0`.tmp.$$

cols=92
hours=24

bperror -columns $cols -U -media -hoursago $hours | \
    awk 'BEGIN {set=0 }
    { if ( $0~/media id [A-Za-z0-9][A-Za-z0-9]* removed from media/ ) {
        set=1
        remline=$0 }
      else {
        if ( set==0 ) {
          print }
        else  {
          set=0
          if ( $0!~/expired/ ) {
            print remline
            print $0 }
        }
      }
    }' >$TMPFILE

if [ `wc -l $TMPFILE | awk '{print $1}'` -gt 1 ] ; then
     mailx -s "`hostname|cut -f1 -d.|tr '[a-z]' '[A-Z]'` NB ${hours}hr
Rpt:Media Report" $MAILADDR <$TMPFILE
fi

echo "## Problem Summary..." >$TMPFILE
bperror -columns $cols -U -backstat -by_statcode -hoursago $hours | \
     awk 'BEGIN {switch=0}
          {if ( $1>0 && $1~/^[0-9][0-9]*$/ ) {switch=1}
           if ( switch==1 ) {
             if ( $1~/^[0-9][0-9]*$/ ) {print}
             else {
               count=0
               while ( ++count <= NF ) { print "\t\t" $count }
             }
           }
          }' >>$TMPFILE

svrlist=`bperror -columns $cols -U -backstat -by_statcode -hoursago $hours |
\
     awk 'BEGIN {switch=0}
          {if ( $1>0 && $1~/^[0-9][0-9]*$/ ) {switch=1}
           if ( switch==1 && $1!~/^[0-9][0-9]*$/) {
             count=0
             while ( ++count <= NF ) {print $count}}}' | sort -u`

echo "\n## Problem Detail by server..." >>$TMPFILE
for each in $svrlist
do
  echo "\n## Client: $each" >>$TMPFILE
  bperror -client $each -columns $cols -U -problems -hoursago $hours
>>$TMPFILE
done

if [ `egrep -vc "^ *$|^#" $TMPFILE` -gt 0 ] ; then
  mailx -s "`hostname|cut -f1 -d.|tr '[a-z]' '[A-Z]'` NB ${hours}hr
Rpt:Problems Report" $MAILADDR <$TMPFILE
fi

[ -f $TMPFILE ] && rm -f $TMPFILE
exit

-----Original Message-----
From: Donaldson, Mark 
Sent: Monday, October 28, 2002 10:16 AM
To: 'Browne, Alexander (Alec)'; 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: RE: [Veritas-bu] Daily batch of status notifications? NB 3.4

Here's a script I use that mails two reports each morning covering the
previous 24 hours run.  It summarizes media errors & backup errors.

<SNIP>

-----Original Message-----
From: Browne, Alexander (Alec) [mailto:abrowne AT tigr DOT org]
Sent: Friday, October 25, 2002 2:25 PM
To: 'veritas-bu AT mailman.eng.auburn DOT edu'
Subject: [Veritas-bu] Daily batch of status notifications? NB 3.4


We use a notification setup whereby an email is sent out for each non-zero
exit status job that completes.  This tends to fill up the inbox.  Is there
a way to send one email a day with a list of the exit status codes for the
previous night's backups?  This idea is partly inspired by the option on
this mailing list to get messages in a batch.

Thanks!

------_=_NextPart_001_01C27F7E.3E98E6D0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2653.12">
<TITLE>RE: [Veritas-bu] Daily batch of status notifications? NB =
3.4</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>Reposting a snipped copy for length limits...</FONT>
</P>

<P><FONT SIZE=3D2>I just reviewed the script I posted yesterday and =
found a problem.&nbsp; I've rewritten it to remove some of my site =
specific tape number stuff and clean up a problem in the sorting =
routine that generates the server list.</FONT></P>

<P><FONT SIZE=3D2>NEW VERSION:</FONT>
<BR><FONT SIZE=3D2>#!/bin/ksh</FONT>
</P>

<P><FONT SIZE=3D2>MAILADDR=3DYOU AT YOURDOMAIN DOT COM</FONT>
<BR><FONT =
SIZE=3D2>PATH=3D$PATH:/usr/openv/netbackup/bin/admincmd</FONT>
<BR><FONT SIZE=3D2>TMPFILE=3D/var/tmp/`basename $0`.tmp.$$</FONT>
</P>

<P><FONT SIZE=3D2>cols=3D92</FONT>
<BR><FONT SIZE=3D2>hours=3D24</FONT>
</P>

<P><FONT SIZE=3D2>bperror -columns $cols -U -media -hoursago $hours | =
\</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; awk 'BEGIN {set=3D0 }</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; { if ( $0~/media id =
[A-Za-z0-9][A-Za-z0-9]* removed from media/ ) {</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
set=3D1</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
remline=3D$0 }</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else {</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if ( =
set=3D=3D0 ) {</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; print =
}</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
else&nbsp; {</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
set=3D0</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if ( =
$0!~/expired/ ) {</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp; print remline</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp; print $0 }</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp; }' &gt;$TMPFILE</FONT>
</P>

<P><FONT SIZE=3D2>if [ `wc -l $TMPFILE | awk '{print $1}'` -gt 1 ] ; =
then</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; mailx -s =
&quot;`hostname|cut -f1 -d.|tr '[a-z]' '[A-Z]'` NB ${hours}hr Rpt:Media =
Report&quot; $MAILADDR &lt;$TMPFILE</FONT>
<BR><FONT SIZE=3D2>fi</FONT>
</P>

<P><FONT SIZE=3D2>echo &quot;## Problem Summary...&quot; =
&gt;$TMPFILE</FONT>
<BR><FONT SIZE=3D2>bperror -columns $cols -U -backstat -by_statcode =
-hoursago $hours | \</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; awk 'BEGIN =
{switch=3D0}</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {if ( =
$1&gt;0 &amp;&amp; $1~/^[0-9][0-9]*$/ ) {switch=3D1}</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
if ( switch=3D=3D1 ) {</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp; if ( $1~/^[0-9][0-9]*$/ ) {print}</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp; else {</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp; count=3D0</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp; while ( ++count &lt;=3D NF ) { print =
&quot;\t\t&quot; $count }</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp; }</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
}</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }' =
&gt;&gt;$TMPFILE</FONT>
</P>

<P><FONT SIZE=3D2>svrlist=3D`bperror -columns $cols -U -backstat =
-by_statcode -hoursago $hours | \</FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp; awk 'BEGIN =
{switch=3D0}</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {if ( =
$1&gt;0 &amp;&amp; $1~/^[0-9][0-9]*$/ ) {switch=3D1}</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
if ( switch=3D=3D1 &amp;&amp; $1!~/^[0-9][0-9]*$/) {</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp; count=3D0</FONT>
<BR><FONT =
SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp; while ( ++count &lt;=3D NF ) {print $count}}}' | sort =
-u`</FONT>
</P>

<P><FONT SIZE=3D2>echo &quot;\n## Problem Detail by server...&quot; =
&gt;&gt;$TMPFILE</FONT>
<BR><FONT SIZE=3D2>for each in $svrlist</FONT>
<BR><FONT SIZE=3D2>do</FONT>
<BR><FONT SIZE=3D2>&nbsp; echo &quot;\n## Client: $each&quot; =
&gt;&gt;$TMPFILE</FONT>
<BR><FONT SIZE=3D2>&nbsp; bperror -client $each -columns $cols -U =
-problems -hoursago $hours &gt;&gt;$TMPFILE</FONT>
<BR><FONT SIZE=3D2>done</FONT>
</P>

<P><FONT SIZE=3D2>if [ `egrep -vc &quot;^ *$|^#&quot; $TMPFILE` -gt 0 ] =
; then</FONT>
<BR><FONT SIZE=3D2>&nbsp; mailx -s &quot;`hostname|cut -f1 -d.|tr =
'[a-z]' '[A-Z]'` NB ${hours}hr Rpt:Problems Report&quot; $MAILADDR =
&lt;$TMPFILE</FONT>
<BR><FONT SIZE=3D2>fi</FONT>
</P>

<P><FONT SIZE=3D2>[ -f $TMPFILE ] &amp;&amp; rm -f $TMPFILE</FONT>
<BR><FONT SIZE=3D2>exit</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Donaldson, Mark </FONT>
<BR><FONT SIZE=3D2>Sent: Monday, October 28, 2002 10:16 AM</FONT>
<BR><FONT SIZE=3D2>To: 'Browne, Alexander (Alec)'; =
'veritas-bu AT mailman.eng.auburn DOT edu'</FONT>
<BR><FONT SIZE=3D2>Subject: RE: [Veritas-bu] Daily batch of status =
notifications? NB 3.4</FONT>
</P>

<P><FONT SIZE=3D2>Here's a script I use that mails two reports each =
morning covering the previous 24 hours run.&nbsp; It summarizes media =
errors &amp; backup errors.</FONT></P>

<P><FONT SIZE=3D2>&lt;SNIP&gt;</FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Browne, Alexander (Alec) [<A =
HREF=3D"mailto:abrowne AT tigr DOT org">mailto:abrowne AT tigr DOT 
org</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Friday, October 25, 2002 2:25 PM</FONT>
<BR><FONT SIZE=3D2>To: 'veritas-bu AT mailman.eng.auburn DOT edu'</FONT>
<BR><FONT SIZE=3D2>Subject: [Veritas-bu] Daily batch of status =
notifications? NB 3.4</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>We use a notification setup whereby an email is sent =
out for each non-zero exit status job that completes.&nbsp; This tends =
to fill up the inbox.&nbsp; Is there a way to send one email a day with =
a list of the exit status codes for the previous night's backups?&nbsp; =
This idea is partly inspired by the option on this mailing list to get =
messages in a batch.</FONT></P>

<P><FONT SIZE=3D2>Thanks!</FONT>
</P>

</BODY>
</HTML>
------_=_NextPart_001_01C27F7E.3E98E6D0--

<Prev in Thread] Current Thread [Next in Thread>