Hi, 

This one could give you an approximate value, but we have to remember that 
tapes in the FILLING status have their %utilized obtained using an estimate 
(estcap_MB), and thus are not 100% correct.

select pct_utilized,est_capacity_mb,(cast(pct_utilized/100 as 
decimal(5,3))*est_capacity_mb) as MBUsed from volumes where volume_name like 
'T%'

Paul

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Moyer, Joni M
Sent: vrijdag 18 september 2009 14:15
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Calculate total data backed up on tape

Hi Everyone,

Would anyone know how to calculate the total amount of data that is stored on 
physical tape?  All of my physical tapes begin with a T* so I'm thinking this 
would be easy, but I have not found the correct syntax that works yet.  Any 
ideas?  Thanks in advance!

Joni Moyer
Storage Administrator III
(717)302-9966
joni.moyer AT highmark DOT com


________________________________
This e-mail and any attachments to it are confidential and are intended solely 
for use of the individual or entity to whom they are addressed. If you have 
received this e-mail in error, please notify the sender immediately and then 
delete it. If you are not the intended recipient, you must not keep, use, 
disclose, copy or distribute this e-mail without the author's prior permission. 
The views expressed in this e-mail message do not necessarily represent the 
views of Highmark Inc., its subsidiaries, or affiliates.