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_01C347C1.C6CEAEC0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
It's 00/00/0000 in v3.4 & up, 00/00/00 in v3.2 & down.
=20
vmquery -a -w | awk '$3 !~ /CLN/ && \
$20 ~ /^00/ && \
$12 =3D=3D "poolname" && \
$28 =3D=3D 0 {print $1}'=20
=20
This query will do it for you.
=20
$3 !~ /CLN/ will skip the cleaning tapes
$20 ~/00/ will find the unassigned tapes (date stamp thing Scott
mentioned)
$12 =3D=3D "poolname" will find tapes in this pool (or use =
!=3D"scratchpoolname"
to find all but those *not* in the scratchpool.)
$28 =3D=3D 0 will skip NB Catalog tapes & HSM (Storage Migrator) tapes.
=20
HTH - M
-----Original Message-----
From: scott.kendall AT abbott DOT com [mailto:scott.kendall AT abbott DOT com]
Sent: Friday, July 11, 2003 7:15 AM
To: Johnny =D8stergaard
Cc: veritas-bu AT mailman.eng.auburn DOT edu
Subject: Re: [Veritas-bu] How to list tapes in a volumepool that are =
empty
when tapes expire (in the NetBackup sense, not within Media Manager), =
a.k.a.
"don't have any valid images on them", they become unassigned (unless =
they
are frozen, suspended tapes will unassign).=20
Therefore, if you do a vmquery on a volume pool, anything with =
00/00/0000
(or maybe it's --/--/---- or -, don't remember off hand and I think =
they
changed it with one of the reporting options between 3.4 and 4.5) for =
an
"assigned date" will be unassigned, or not have valid images on it.=20
- Scott=20
Johnny =D8stergaard (JOE) <joe AT europaeiske DOT dk>=20
Sent by: veritas-bu-admin AT mailman.eng.auburn DOT edu=20
07/11/2003 04:43 AM=20
=20
To: veritas-bu AT mailman.eng.auburn DOT edu=20
cc: =20
Subject: [Veritas-bu] How to list tapes in a volumepool =
that
are empty
Can anyone help me with a command to list all tapes in a volumepool =
that
don't have any valid images on them any more?=20
/johnny=20
------_=_NextPart_001_01C347C1.C6CEAEC0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4926.2500" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D303162915-11072003><FONT face=3DArial =
color=3D#0000ff size=3D2>It's=20
00/00/0000 in v3.4 & up, 00/00/00 in v3.2 & =
down.</FONT></SPAN></DIV>
<DIV><SPAN class=3D303162915-11072003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D303162915-11072003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2>vmquery -a -w | awk '$3 !~ /CLN/=20
&& \</FONT></SPAN></DIV>
<DIV><SPAN class=3D303162915-11072003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2> &nb=
sp; &nb=
sp; =20
$20 ~ /^00/ &&=20
\<BR> &=
nbsp; &=
nbsp; =20
$12 =3D=3D "poolname" &&=20
\<BR> &=
nbsp; &=
nbsp; =20
$28 =3D=3D 0 {print $1}' </FONT></SPAN></DIV>
<DIV><SPAN class=3D303162915-11072003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D303162915-11072003><FONT face=3DArial =
color=3D#0000ff size=3D2>This=20
query will do it for you.</FONT></SPAN></DIV>
<DIV><SPAN class=3D303162915-11072003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D303162915-11072003><FONT face=3DArial =
color=3D#0000ff size=3D2>$3 !~=20
/CLN/ will skip the cleaning tapes</FONT></SPAN></DIV>
<DIV><SPAN class=3D303162915-11072003><FONT face=3DArial =
color=3D#0000ff size=3D2>$20=20
~/00/ will find the unassigned tapes (date stamp thing =
Scott=20
mentioned)</FONT></SPAN></DIV>
<DIV><SPAN class=3D303162915-11072003><FONT face=3DArial =
color=3D#0000ff size=3D2>$12 =3D=3D=20
"poolname" will find tapes in this pool (or use !=3D"scratchpoolname" =
to find all=20
but those *not* in the scratchpool.)</FONT></SPAN></DIV>
<DIV><SPAN class=3D303162915-11072003><FONT face=3DArial =
color=3D#0000ff size=3D2>$28 =3D=3D=20
0 will skip NB Catalog tapes & HSM (Storage Migrator)=20
tapes.</FONT></SPAN></DIV>
<DIV><SPAN class=3D303162915-11072003><FONT face=3DArial =
color=3D#0000ff=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D303162915-11072003><FONT face=3DArial =
color=3D#0000ff size=3D2>HTH -=20
M</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> =
scott.kendall AT abbott DOT com=20
[mailto:scott.kendall AT abbott DOT com]<BR><B>Sent:</B> Friday, July 11, =
2003 7:15=20
AM<BR><B>To:</B> Johnny =D8stergaard<BR><B>Cc:</B>=20
veritas-bu AT mailman.eng.auburn DOT edu<BR><B>Subject:</B> Re: [Veritas-bu] =
How to=20
list tapes in a volumepool that are =
empty<BR><BR></FONT></DIV><BR><FONT=20
face=3DArial size=3D2>when tapes expire (in the NetBackup sense, not =
within Media=20
Manager), a.k.a. "don't have any valid images on them", they become =
unassigned=20
(unless they are frozen, suspended tapes will unassign).</FONT> =
<BR><BR><FONT=20
face=3DArial size=3D2>Therefore, if you do a vmquery on a volume =
pool, anything=20
with 00/00/0000 (or maybe it's --/--/---- or -, don't remember off =
hand and I=20
think they changed it with one of the reporting options between 3.4 =
and 4.5)=20
for an "assigned date" will be unassigned, or not have valid images =
on=20
it.</FONT> <BR><BR><BR><FONT face=3DArial size=3D2>- Scott</FONT> =
<BR><BR><BR><BR>
<TABLE width=3D"100%">
<TBODY>
<TR vAlign=3Dtop>
<TD>
<TD><FONT face=3Dsans-serif size=3D1><B>Johnny =D8stergaard (JOE) =
<joe AT europaeiske DOT dk></B></FONT> <BR><FONT =
face=3Dsans-serif=20
size=3D1>Sent by: =
veritas-bu-admin AT mailman.eng.auburn DOT edu</FONT>=20
<P><FONT face=3Dsans-serif size=3D1>07/11/2003 04:43 AM</FONT> =
<BR></P>
<TD><FONT face=3DArial size=3D1> =
</FONT><BR><FONT=20
face=3Dsans-serif size=3D1> To: =
=20
veritas-bu AT mailman.eng.auburn DOT edu</FONT> <BR><FONT =
face=3Dsans-serif size=3D1> cc: =
=20
</FONT> <BR><FONT face=3Dsans-serif =
size=3D1> =20
Subject: [Veritas-bu] =
How to=20
list tapes in a volumepool that are=20
empty</FONT></TR></TBODY></TABLE><BR><BR><BR><FONT face=3DArial =
size=3D2>Can=20
anyone help me with a command to list all tapes in a volumepool that =
don't=20
have any valid images on them any more?</FONT><FONT face=3D"Times New =
Roman"=20
size=3D3> </FONT>
<P><FONT face=3DArial size=3D2>/johnny</FONT><FONT face=3D"Times New =
Roman" size=3D3>=20
</FONT>
<P>
<P></P></BLOCKQUOTE></BODY></HTML>
------_=_NextPart_001_01C347C1.C6CEAEC0--
|