For example by:
"select * from libvolumes where STATUS = 'Scratch'" for a list of all 
scratch-volumes
or 
"select library_name,count(*) scratch from libvolumes where STATUS = 'Scratch' 
group by library_name,STATUS" for the number of scratch-volumes grouped per 
library

Jeroen



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Norita binti Hassan
Sent: woensdag 29 december 2004 3:21
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Tape Scratch list


Hi,

How to produce a daily scratch report so that I can monitor of tapes usage.

Thanks


Pos Malaysia Berhad is Malaysia's national postal company
        Visit us online at www.pos.com.my

NOTICE
This message may contain privileged and/or confidential
information. If  you are  not the addressee  or authorised
to  receive this email, you must not use, copy,  disclose
or take any  action based  on this email. If you  have
received this  email in  error, please advise  the sender
immediately by  reply e-mail and delete  this message.
Pos Malaysia  Berhad takes  no responsibility  for  the
contents of this email.