Veritas-bu

[Veritas-bu] how do I find expired tapes in a robot?

2005-06-16 16:40:12
Subject: [Veritas-bu] how do I find expired tapes in a robot?
From: SKampen AT verisign DOT com (Kampen, Scott)
Date: Thu, 16 Jun 2005 13:40:12 -0700
This is a multi-part message in MIME format.

------_=_NextPart_001_01C572B3.97DF6543
Content-Type: text/plain;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

I'm not a script God and I'm sure there is someone out there that can
write a one-liner to produce the same results, but here is my script
which displays the tape label, the date it expires and the pool it is
in.  I have a Solaris 9 master server.

=20

You will need to modify the line for bpmedialist where I grep for P00 (P
zero zero).  Our tapes start with P00XXX and so change that so it lists
the first three digits of your tapes.  Also I grep out the word
"INFINITY", because obviously I won't be here when those tapes expire.
Modify the script how you wish.  It may take a few moments to run.  Hope
it helps.

=20

=20

#!/bin/sh

#set -x

#########################################

# Script written by Scott Kampen=20

# Date - 02/15/05

#

# This script lists the tapes and their

# expiration date.  This script can be

# run at anytime of the day.

#########################################

=20

rm /tmp/expire_report1

rm /tmp/expire_report2

rm /tmp/expire_report3

VMQUERY=3D/usr/openv/volmgr/bin/vmquery

VMPOOL=3D/usr/openv/volmgr/bin/vmpool

=20

bpmedialist -summary | grep P00 | grep -v INFINITY | awk '{print $1, $2,
$3}' | sort -t '/' -k 3 > /tmp/expiredates

cat /tmp/expiredates | awk '{print $1}' > /tmp/expiredates_tapes

=20

echo "Tape      Expires on       Pool" > /tmp/expire_report1

for line in `cat /tmp/expiredates_tapes`

do

tapenumber=3D$line

poolname=3D`$VMQUERY -m $tapenumber | grep pool | awk '{print $3}'`

expires=3D`grep $tapenumber /tmp/expiredates | awk '{print $3}'`

echo "$tapenumber    $expires       $poolname" >> /tmp/expire_report2

done

#cat /tmp/expire_report2 | sort -k 3,3 > /tmp/expire_report3

#cat /tmp/expire_report2 | sort -t '/' -k 2,9  > /tmp/expire_report3

cat /tmp/expire_report2 | sort -k 2,10  > /tmp/expire_report3

cat /tmp/expire_report3 >> /tmp/expire_report1

cat /tmp/expire_report1

=20

________________________________

From: veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] On Behalf Of Hindle,
Greg
Sent: Thursday, June 16, 2005 12:11 PM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] how do I find expired tapes in a robot?

=20

Hello all,

I want to create a scrip that will perform an inventory of a robot, then
tell me all the tapes in robot and when they will expire and become
scratch. Is this easy to do? Dopes anyone have a script that they can
share that does this?

=20

=20

Greg

=20




>>> The information contained in this e-mail transmission is privileged
and/or confidential intended solely for the exclusive use of the
individual addressee. If you are not the intended addressee you are
hereby notified that any retention, disclosure or other use is strictly
prohibited. If you have received this notification in error, please
immediately contact the sender and delete the material.


------_=_NextPart_001_01C572B3.97DF6543
Content-Type: text/html;
        charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40";>

<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 11 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
 /* Font Definitions */
 @font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0in;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman";}
a:link, span.MsoHyperlink
        {color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal-reply;
        font-family:Arial;
        color:navy;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
        {page:Section1;}
-->
</style>

</head>

<body lang=3DEN-US link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>I&#8217;m not a script God and =
I&#8217;m
sure there is someone out there that can write a one-liner to produce =
the same
results, but here is my script which displays the tape label, the date =
it
expires and the pool it is in.&nbsp; I have a Solaris 9 master =
server.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>You will need to modify the line =
for
bpmedialist where I grep for P00 (P zero zero).&nbsp; Our tapes start =
with P00XXX
and so change that so it lists the first three digits of your =
tapes.&nbsp; Also I
grep out the word &#8220;INFINITY&#8221;, because obviously I =
won&#8217;t be
here when those tapes expire.&nbsp; Modify the script how you =
wish.&nbsp; It may take a
few moments to run.&nbsp; Hope it helps.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>#!/bin/sh<o:p></o:p></span></font></=
p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>#set =
-x<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>####################################=
#####<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'># Script written by Scott Kampen =
<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'># Date - =
02/15/05<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>#<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'># This script lists the tapes and =
their<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'># expiration date.&nbsp; This =
script can be<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'># run at anytime of the =
day.<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>####################################=
#####<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>rm =
/tmp/expire_report1<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>rm =
/tmp/expire_report2<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>rm =
/tmp/expire_report3<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>VMQUERY=3D/usr/openv/volmgr/bin/vmqu=
ery<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>VMPOOL=3D/usr/openv/volmgr/bin/vmpoo=
l<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>bpmedialist -summary | grep P00 | =
grep -v
INFINITY | awk '{print $1, $2, $3}' | sort -t '/' -k 3 &gt; =
/tmp/expiredates<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>cat /tmp/expiredates | awk '{print =
$1}'
&gt; /tmp/expiredates_tapes<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>echo =
&quot;Tape&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Expires =
on&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Pool&quot; &gt; /tmp/expire_report1<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>for line in `cat =
/tmp/expiredates_tapes`<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>do<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>tapenumber=3D$line<o:p></o:p></span>=
</font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>poolname=3D`$VMQUERY -m $tapenumber =
| grep
pool | awk '{print $3}'`<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>expires=3D`grep $tapenumber =
/tmp/expiredates
| awk '{print $3}'`<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>echo =
&quot;$tapenumber&nbsp;&nbsp;&nbsp; =
$expires&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
$poolname&quot; &gt;&gt; =
/tmp/expire_report2<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>done<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>#cat /tmp/expire_report2 | sort -k =
3,3
&gt; /tmp/expire_report3<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>#cat /tmp/expire_report2 | sort -t =
'/' -k
2,9&nbsp; &gt; /tmp/expire_report3<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>cat /tmp/expire_report2 | sort -k =
2,10&nbsp;
&gt; /tmp/expire_report3<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>cat /tmp/expire_report3 &gt;&gt;
/tmp/expire_report1<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'>cat =
/tmp/expire_report1<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span =
style=3D'font-size:
10.0pt;font-family:Arial;color:navy'><o:p>&nbsp;</o:p></span></font></p>

<div>

<div class=3DMsoNormal align=3Dcenter style=3D'text-align:center'><font =
size=3D3
face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>

<hr size=3D2 width=3D"100%" align=3Dcenter tabindex=3D-1>

</span></font></div>

<p class=3DMsoNormal><b><font size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font =
size=3D2
face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'> =
veritas-bu-admin AT mailman.eng.auburn DOT edu
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <b><span =
style=3D'font-weight:
bold'>On Behalf Of </span></b>Hindle, Greg<br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> Thursday, June 16, =
2005
12:11 PM<br>
<b><span style=3D'font-weight:bold'>To:</span></b>
veritas-bu AT mailman.eng.auburn DOT edu<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> [Veritas-bu] how =
do I
find expired tapes in a robot?</span></font><o:p></o:p></p>

</div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'><o:p>&nbsp;</o:p></span></font></p>

<div>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Hello all,</span></font><o:p></o:p></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I want to create a scrip that will perform an =
inventory of a
robot, then tell me all the tapes in robot&nbsp;and when they will =
expire and
become scratch. Is this easy to do? Dopes anyone have a script that they =
can
share that does this?</span></font><o:p></o:p></p>

</div>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Greg</span></font><o:p></o:p></p>

<div>

<p class=3DMsoNormal><font size=3D3 face=3D"Times New Roman"><span =
style=3D'font-size:
12.0pt'>&nbsp;<o:p></o:p></span></font></p>

</div>

<p class=3DMsoNormal><font size=3D2 face=3D"Times New Roman"><span =
style=3D'font-size:
10.0pt'><br>
<br>
<br>
&gt;&gt;&gt; The information contained in this e-mail transmission is
privileged and/or confidential intended solely for the exclusive use of =
the
individual addressee. If you are not the intended addressee you are =
hereby
notified that any retention, disclosure or other use is strictly =
prohibited. If
you have received this notification in error, please immediately contact =
the
sender and delete the material.</span></font><o:p></o:p></p>

</div>

</body>

</html>

------_=_NextPart_001_01C572B3.97DF6543--