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:[EMAIL PROTECTED] Behalf Of Norita binti Hassan Sent: woensdag 29 december 2004 3:21 To: ADSM-L@VM.MARIST.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.
