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:      ADSM-L AT VM.MARIST DOT 
EDU                                                           
                                               Kopie:                           
                                                       
                                               Thema:   q libv                  
                                                       
                                                                                
                                                       
             owner-adsm-l AT VM.MARIST DOT ED                                   
                                                              
             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