Use the following:

select count(*) from libvolumes where status = 'Scratch'

Joerg Pohlmann



"Dearman, Richard" <rdearm1 AT UIC DOT EDU>@VM.MARIST.EDU> on 2001-10-17 
15:19:40

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  How many scratch volumes in library?


How can I find out quickly how many scratch volumes I have in my library?

Thanks
***************************EMAIL  DISCLAIMER**************************
This e-mail and any files transmitted with it may be confidential and are
intended solely for the use of the individual or entity to whom they are
addressed.   If you are not the intended recipient or the individual
responsible for delivering the e-mail to the intended recipient, any
disclosure, copying, distribution or any action taken or omitted to be
taken
in reliance on it, is strictly prohibited.  If you have received this
e-mail
in error, please delete it and notify the sender or contact Health
Information  Management (312) 996-3941.