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.
|