ADSM-L

Re: Script to report on space used in Library

2001-07-11 11:35:46
Subject: Re: Script to report on space used in Library
From: Gene Walters <gwalters AT GWMAIL.STATE.WV DOT US>
Date: Wed, 11 Jul 2001 11:35:21 -0400
Or you could run an sql on the  occupancy table for just your tape storage pool.

>>> "Cook, Dwight E" <cookde AT BP DOT COM> 07/11/01 11:17AM >>>
Try
        select volume_name,cast((pct_utilized * est_capacity_mb / 100) as
decimal ) as "MB on Tape" from adsm.volumes where devclass_name='3590DEVC'
or
        select cast(sum(pct_utilized * est_capacity_mb / 100) as decimal )
as "MB on Tape" from adsm.volumes  where devclass_name='3590DEVC'

ie.
select cast(sum(pct_utilized * est_capacity_mb / 100) as decimal )
 as "MB on Tape" from adsm.volumes where devclass_name='3590DEVC'

         MB on Tape
-------------------
            3604926
            3604926

<Prev in Thread] Current Thread [Next in Thread>