Here's what I use on our version 3 server:

SELECT volume_name as "Volume", status as "Status" \
FROM   libvolumes \
WHERE  UPPER(status) = 'SCRATCH'

I've put this into a file called scratch.dsm and all I do when I
need a list of scratch tapes is type 'macro scratch.dsm'

Hope that helps. -- Tom

Thomas A. La Porte
DreamWorks Animation
tlaporte AT anim.dreamworks DOT com

On Wed, 22 Jul 1998, Jackie Balboni wrote:

>Does anyone know of a better inquiry for a scratch list of
>tapes besides  q libv?
>