select volume_name, status from libvolumes where status='Scratch'

or, if you have multiple libraries attached:

select library_name, volume_name, status from libvolumes where
status='Scratch'


Sandra wrote:

Dear All,
Please give me the knowledge of a query that can give me the names of tapes,
that in my scratch pool.

I know there are 3 tapes that are scratch, but i don't know the volume labels.
What command would give me the volume labels for those tapes?

Kind Regards,
Sandra