Or you could run an sql on the occupancy table for just your tape storage pool.
>>> "Cook, Dwight E" <[EMAIL PROTECTED]> 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
-----Original Message-----
From: Brown, Ken C [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 8:50 AM
To: [EMAIL PROTECTED]
Subject: Script to report on space used in Library
Does anyone have a script that reports the amount of space used on tapes?
instead of using "q Filespace"
Ken C. Brown
International Truck and Engine Corporation
NGV Server Team
(937) 342-7561
[EMAIL PROTECTED]
