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:[email protected]] On Behalf Of Moyer, Joni M Sent: vrijdag 18 september 2009 14:15 To: [email protected] 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 [email protected] ________________________________ 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.
