When using drm:
select status,count(*) as "3584LIB" from libvolumes where
library_name='3584LIB' group by status
select state,count(*) as "DRMEDIA" from drmedia group by state



-----Oorspronkelijk bericht-----
Van: Michelle Wiedeman [mailto:michelle.wiedeman AT MULTRIX DOT COM]
Verzonden: maandag 7 oktober 2002 13:43
Aan: ADSM-L AT VM.MARIST DOT EDU
Onderwerp: q libv


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