Re: Script to report on space used in Library
2001-07-11 11:35:46
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
|
|
|