Shekhar,

are the cases o.k.? I bet, it should look like

select count (*) from volumes where devclass_name='STK9710'
                                                   ^^^

Regards,

Reinhard

Shekhar Dhotre writes:
 > tsm: TSM>select count (*) from volumes where devclass_name='stk9710'
 >
 >  Unnamed[1]
 > -----------
 >           0
 >
 > tsm: TSM>select count (*) from drmedia
 >
 >  Unnamed[1]
 > -----------
 >          49
 >
 > tsm: TSM>select avg(EST_CAPACITY_MB) from volumes where 
 > devclass_name='stk9710'
 >
 >                        Unnamed[1]
 >
 > whats wrong with first and third query? or not applicable to stk?
 > ---------------------------------
 >
 >
 >
 >
 >
 > "DDA.RFC-822=ADSM-L AT VM.MARIST DOT EDU/P=Internet/A= /C=us" on 09/19/2000 
 > 01:23:01 PM
 > Please respond to "DDA.RFC-822=ADSM-L AT VM.MARIST DOT EDU/P=Internet/A= 
 > /C=us" @ X400
 > To: "DDA.RFC-822=ADSM-L AT VM.MARIST DOT EDU/P=Internet/A= /C=us"@X400
 > cc:
 >
 > Subject: Re: Determining Capacity on ADSM?
 >
 > >How do I determine how many physical slots my 3494 library has?
 >
 > mtlib -l /dev/lmcp0 -qL | grep cells
 >
 > >How do I determine how many tapes are offsite?
 >
 > a) select count(*) from volumes where stgpool_name='BACKUP3590_OFFSITE'
 > (where a storagepool is used for offsite.)
 > b) select count(*) from drmedia
 > (where DRM is in use.)
 > c) select count(*) from volumes where access='OFFSITE'
 > (where you set the access or use DRM.)
 >
 > Note: tapes may be in transit to-and-from offsite.
 > Also, db backups are not in the volume table.
 >
 > >How do I determine how many tapes total I have?
 >
 > select count(*) from volumes where devclass_name='MAGSTAR3590'
 > (where your device class name is MAGSTAR3590.)
 >
 > >How do I determine the average capacity per tape?
 > >
 >
 > select avg(EST_CAPACITY_MB) from volumes where devclass_name='MAGSTAR3590'
 >
 > --
 > Richard

--
Reinhard Mersch                        Westfaelische Wilhelms-Universitaet
Reinhard Mersch                        Westfaelische Wilhelms-Universitaet
Zentrum fuer Informationsverarbeitung - ehemals Universitaetsrechenzentrum
Roentgenstrasse 9-13, D-48149 Muenster, Germany      Tel: +49(251)83-31583
E-Mail: mersch AT uni-muenster DOT de                       Fax: 
+49(251)83-31653