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:Mike.Swinhoe AT UK.Zurich DOT com



                    Michelle Wiedeman
                    <michelle.wiedeman@MU        To:     ADSM-L AT VM.MARIST 
DOT EDU
                    LTRIX.COM>                   cc:
                    Sent by: "ADSM: Dist         Subject:     q libv
                    Stor Manager"
                    <ADSM-L AT VM.MARIST DOT EDU
                    >


                    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.

___________________________________________________________________________