Antwort: q libv

[Markus Veit]

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