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