This will find your tapes that can be overwritten (empty of images):

vmquery -a -w |  awk '$3!~/CLN/ && $20~/^00/ && $28==0 {print $1}' 

The fields, from left to right:
   $3 - tape type (not cleaning tape)
  $20 - assigned date ("00/00/0000" is unassigned==empty)
  $28 - status (0==data tape as opposed to catalog tape or HSM tape)

-M

-----Original Message-----
From: Asher Aber [mailto:asher-a AT orbotech DOT com]
Sent: Monday, July 28, 2003 3:59 AM
To: veritas-bu AT mailman.eng.auburn DOT edu
Subject: [Veritas-bu] Netbackup 4.5 how 2 list files stored on a tape


Hi,
I need to know which tapes can be overwritten.
How do I query the database to give me a listing of the files stored on
a tape.
Hopefully the command line syntax.

I'm running Veritas Netbackup 4.5 Data Center on Sun Solaris 5.8


Asher Aber

Orbotech.COM

_______________________________________________
Veritas-bu maillist  -  Veritas-bu AT mailman.eng.auburn DOT edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu