|
Re: Script to report on space used in Library
2001-07-11 11:20:43
|
Subject: |
Re: Script to report on space used in Library |
|
From: |
"Cook, Dwight E" <cookde AT BP DOT COM> |
|
Date: |
Wed, 11 Jul 2001 10:17:39 -0500 |
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
|
|
|
