Matt,
 
The scratch column is case sensitive.  Looks like the yes & no are 
capitalized.  
 
The status column is YES|NO|NULL
 
james

________________________________

From: ADSM: Dist Stor Manager on behalf of Richard Sims
Sent: Tue 11/30/2004 6:13 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Select Statement Help for Volume Breakdown



Matt -

Do   select * from volumes where scratch='Yes'
That is, a volume which is in use in a storage pool,
which came from the Scratch tape pool, will have its
SCRATCH column set to Yes.  A storage pool volume
which is in the storage pool because of a Define Volume
will have a SCRATCH column value of No.

    Richard Sims

On Nov 30, 2004, at 7:21 AM, Matt Chan wrote:

> Hello all,
>
> Related to this in a way then, can anyone help me with how to determine
> which of all my defined tapes are scratch, for audit purposes ?
>
> Matt Chan
>
>
> "Stapleton, Mark" <mark.stapleton AT BERBEE DOT COM>
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 23/11/2004 07:23 AM
> Please respond to
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
>
> To
> ADSM-L AT VM.MARIST DOT EDU
> cc
>
> Subject
> Re: Select Statement Help for Volume Breakdown
>
> There are no scratch tapes in storage pools. A tape volume only exists
> in a storage pool when it contains client data (and is therefore no
> longer a scratch tape).
>
> --
> Mark Stapleton (stapleton AT berbee DOT com)
> Berbee Information Networks
> Office 262.521.5627