[Veritas-bu] List tapes with no "time assigned"

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_01C305D3.740A3450
Content-Type: text/plain;
        charset="iso-8859-1"

You want to look at vmquery output, field 20 is time assigned.  If it's
unassigned it's "00/00/0000" (or "00/00/00" if v3.2 & below).
 
This works regardless of version:
 
vmquery -a -w | awk 'NR>3 && $20 ~/00\/00\/00/ {print $1}'
 
HTH - M

-----Original Message-----
From: Shafto, Eric [mailto:Eric.Shafto AT drkw DOT com]
Sent: Friday, April 18, 2003 11:38 AM
To: veritas-netbackup
Subject: [Veritas-bu] List tapes with no "time assigned"


I am trying to list all tapes that have no "time assigned" and that are in
my library. I've looked at a number of commands, but I can't seem to find a
way to do this. I'm pretty good at massaging text, but I can't seem to find
a command that lists unassigned media.
 
Any pointers will be appreciated.


If you have received this e-mail in error or wish to read our e-mail
disclaimer statement and monitoring policy, please refer to
http://www.drkw.com/disc/email/ or contact the sender.



------_=_NextPart_001_01C305D3.740A3450
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">


<META content="MSHTML 5.50.4923.2500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=977035117-18042003><FONT face=Arial color=#0000ff size=2>You 
want to look at vmquery output, field 20 is time assigned.&nbsp; If it's 
unassigned it's "00/00/0000" (or "00/00/00" if v3.2 &amp; 
below).</FONT></SPAN></DIV>
<DIV><SPAN class=977035117-18042003><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=977035117-18042003><FONT face=Arial color=#0000ff size=2>This 
works regardless of version:</FONT></SPAN></DIV>
<DIV><SPAN class=977035117-18042003><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=977035117-18042003><FONT face=Arial color=#0000ff 
size=2>vmquery -a -w | awk 'NR&gt;3 &amp;&amp; $20 ~/00\/00\/00/ {print 
$1}'</FONT></SPAN></DIV>
<DIV><SPAN class=977035117-18042003><FONT face=Arial color=#0000ff 
size=2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=977035117-18042003><FONT face=Arial color=#0000ff size=2>HTH - 
M</FONT></SPAN></DIV>
<BLOCKQUOTE>
  <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma 
  size=2>-----Original Message-----<BR><B>From:</B> Shafto, Eric 
  [mailto:Eric.Shafto AT drkw DOT com]<BR><B>Sent:</B> Friday, April 18, 2003 
11:38 
  AM<BR><B>To:</B> veritas-netbackup<BR><B>Subject:</B> [Veritas-bu] List tapes 
  with no "time assigned"<BR><BR></FONT></DIV>
  <DIV><SPAN class=228422917-18042003><FONT face=Arial color=#0000ff size=2>I 
am 
  trying to list all tapes that have no "time assigned" and that are in my 
  library. I've looked at a number of commands, but I can't seem to find a way 
  to do this. I'm pretty good at massaging text, but I can't seem to find a 
  command that lists unassigned media.</FONT></SPAN></DIV>
  <DIV><SPAN class=228422917-18042003><FONT face=Arial color=#0000ff 
  size=2></FONT></SPAN>&nbsp;</DIV>
  <DIV><SPAN class=228422917-18042003><FONT face=Arial color=#0000ff size=2>Any 
  pointers will be appreciated.</FONT></SPAN></DIV><FONT size=3><BR><BR>If you 
  have received this e-mail in error or wish to read our e-mail disclaimer 
  statement and monitoring policy, please refer to 
  http://www.drkw.com/disc/email/ or contact the 
sender.<BR></BLOCKQUOTE></FONT></BODY></HTML>

------_=_NextPart_001_01C305D3.740A3450--