Michelle,
Here you go. All you have to do is enter you library name:
select count(*) from libvolumes where status='Scratch' and library_name
='Library_Name'
Mike.
Regards,
Michael Swinhoe
Storage Management Group
Zurich Financial Services
E-mail: mailto:[EMAIL PROTECTED]
Michelle Wiedeman
<michelle.wiedeman@MU To: [EMAIL PROTECTED]
LTRIX.COM> cc:
Sent by: "ADSM: Dist Subject: q libv
Stor Manager"
<[EMAIL PROTECTED]
>
07/10/2002 12:42
Please respond to
"ADSM: Dist Stor
Manager"
hi!
does anyone know how to query the library volumes and see the amount of
scratch tapes there wthout having to plough through the whole list of all
volumes?
thnx,
Michelle
___________________________________________________________________________
The information contained in this message is confidential and may be
legally privileged. If you are not the intended recipient, please do not
read, copy or otherwise use it and do not disclose it to anyone else.
Please notify the sender of the delivery error and then delete the
message from your system.
Any views or opinions expressed in this email are those of the author only.
Communications will be monitored regularly to improve our service and for
security and regulatory purposes.
Thank you for your assistance.
___________________________________________________________________________
