Hi, to get a better overview try this one select library_name, status, count(*) as NO_OF_Tapes from adsm.libvolumes group by library_name, status
Mit freundlichen Grüßen / Best Regards Markus Veit An: [EMAIL PROTECTED] Kopie: Thema: q libv [EMAIL PROTECTED] U Received : 07.10.2002 13:43 Bitte antworten an "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