This is a multi-part message in MIME format.
------_=_NextPart_001_01C572B4.05F77F22
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Ok Thanks Scott. I will give this a try. and go from there. I have 3
master servers and 3 media servers and the tape numbers are all mixed.
We started out with certain at certain sites but as we consolidated
those sites the tapes were divided amounts the sites that needed them
the most.
=20
=20
Greg
=20
=20
=20
_____ =20
From: Kampen, Scott [mailto:SKampen AT verisign DOT com]=20
Sent: Thursday, June 16, 2005 4:40 PM
To: Hindle, Greg; veritas-bu AT mailman.eng.auburn DOT edu
Subject: RE: [Veritas-bu] how do I find expired tapes in a robot?
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
_____ =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_01C572B4.05F77F22
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40"; xmlns:v =3D=20
"urn:schemas-microsoft-com:vml" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word"><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2627" name=3DGENERATOR><!--[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-face {
font-family: Tahoma;
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.EmailStyle17 {
COLOR: navy; FONT-FAMILY: Arial; mso-style-type: personal-reply
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=3DEN-US vLink=3Dpurple link=3Dblue>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D568394120-16062005><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Ok Thanks Scott. I will give this a try. and go =
from there.=20
I have 3 master servers and 3 media servers and the tape numbers are all =
mixed.=20
We started out with certain at certain sites but as we consolidated =
those sites=20
the tapes were divided amounts the sites that needed them the=20
most.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2>Greg</FONT></DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV align=3Dleft><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV> </DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> Kampen, Scott=20
[mailto:SKampen AT verisign DOT com] <BR><B>Sent:</B> Thursday, June 16, 2005 =
4:40=20
PM<BR><B>To:</B> Hindle, Greg;=20
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> RE: [Veritas-bu] =
how do I=20
find expired tapes in a robot?<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">I’m not =
a script God=20
and I’m sure there is someone out there that can write a one-liner =
to produce=20
the same results, but here is my script which displays the tape label, =
the date=20
it expires and the pool it is in. I have a Solaris 9 master=20
server.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">You will need =
to modify=20
the line for bpmedialist where I grep for P00 (P zero zero). Our =
tapes=20
start with P00XXX and so change that so it lists the first three digits =
of your=20
tapes. Also I grep out the word “INFINITY”, because =
obviously I won’t be=20
here when those tapes expire. Modify the script how you =
wish. It may=20
take a few moments to run. Hope it =
helps.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">#!/bin/sh<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">#set=20
-x<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">#########################################<o:p></o:p></SPAN></FONT>=
</P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"># Script =
written by=20
Scott Kampen <o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"># Date -=20
02/15/05<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">#<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"># This script =
lists the=20
tapes and their<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"># expiration=20
date. This script can be<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"># run at =
anytime of the=20
day.<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">#########################################<o:p></o:p></SPAN></FONT>=
</P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">rm=20
/tmp/expire_report1<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">rm=20
/tmp/expire_report2<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">rm=20
/tmp/expire_report3<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">VMQUERY=3D/usr/openv/volmgr/bin/vmquery<o:p></o:p></SPAN></FONT></=
P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">VMPOOL=3D/usr/openv/volmgr/bin/vmpool<o:p></o:p></SPAN></FONT></P>=
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">bpmedialist =
-summary |=20
grep P00 | grep -v INFINITY | awk '{print $1, $2, $3}' | sort -t '/' -k =
3 >=20
/tmp/expiredates<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">cat =
/tmp/expiredates |=20
awk '{print $1}' > =
/tmp/expiredates_tapes<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">echo=20
"Tape Expires=20
on Pool" >=20
/tmp/expire_report1<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">for line in =
`cat=20
/tmp/expiredates_tapes`<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">do<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">tapenumber=3D$line<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">poolname=3D`$VMQUERY -m=20
$tapenumber | grep pool | awk '{print $3}'`<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">expires=3D`grep=20
$tapenumber /tmp/expiredates | awk '{print =
$3}'`<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">echo=20
"$tapenumber =
$expires =20
$poolname" >> /tmp/expire_report2<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial">done<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">#cat=20
/tmp/expire_report2 | sort -k 3,3 >=20
/tmp/expire_report3<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">#cat=20
/tmp/expire_report2 | sort -t '/' -k 2,9 >=20
/tmp/expire_report3<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">cat =
/tmp/expire_report2=20
| sort -k 2,10 > =
/tmp/expire_report3<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">cat =
/tmp/expire_report3=20
>> /tmp/expire_report1<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">cat=20
/tmp/expire_report1<o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial color=3Dnavy size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: =
Arial"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<DIV class=3DMsoNormal style=3D"TEXT-ALIGN: center" align=3Dcenter><FONT =
face=3D"Times New Roman" size=3D3><SPAN style=3D"FONT-SIZE: 12pt">
<HR tabIndex=3D-1 align=3Dcenter width=3D"100%" SIZE=3D2>
</SPAN></FONT></DIV>
<P class=3DMsoNormal><B><FONT face=3DTahoma size=3D2><SPAN=20
style=3D"FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">From:</SPAN></FONT></B><FONT=20
face=3DTahoma size=3D2><SPAN style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Tahoma">=20
veritas-bu-admin AT mailman.eng.auburn DOT edu=20
[mailto:veritas-bu-admin AT mailman.eng.auburn DOT edu] <B><SPAN=20
style=3D"FONT-WEIGHT: bold">On Behalf Of </SPAN></B>Hindle, =
Greg<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Thursday, June 16, 2005 =
12:11=20
PM<BR><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B>=20
veritas-bu AT mailman.eng.auburn DOT edu<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> [Veritas-bu] how do I =
find expired=20
tapes in a robot?</SPAN></FONT><o:p></o:p></P></DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"><o:p> </o:p></SPAN></FONT></P>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hello=20
all,</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Arial">I want to create a scrip =
that will=20
perform an inventory of a robot, then tell me all the tapes in =
robot and=20
when they will expire and become scratch. Is this easy to do? Dopes =
anyone have=20
a script that they can share that does =
this?</SPAN></FONT><o:p></o:p></P></DIV>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; FONT-FAMILY: =
Arial">Greg</SPAN></FONT><o:p></o:p></P>
<DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"> <o:p></o:p></SPAN></FONT></P></DIV>
<P class=3DMsoNormal><FONT face=3D"Times New Roman" size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt"><BR><BR><BR>>>> The information =
contained in=20
this e-mail transmission is privileged and/or confidential intended =
solely for=20
the exclusive use of the individual addressee. If you are not the =
intended=20
addressee you are hereby notified that any retention, disclosure or =
other use is=20
strictly prohibited. If you have received this notification in error, =
please=20
immediately contact the sender and delete the=20
material.</SPAN></FONT><o:p></o:p></P></DIV></BODY></HTML>
------_=_NextPart_001_01C572B4.05F77F22--
|
