To find scratch tapes in NetBackup, you can use the vmquery command. Below is one way you can get the output you need:
/usr/openv/volmgr/bin/vmquery -a -w | nawk ‘$20==”00\/00\/0000″ && $1 !~ /^CLN/{print $1}’
This will look for tapes which have a value of 00/00/0000 in the 20th field and the first field (tape number) does not being with CLN (Cleaning Tapes).