Re: Select Statement
2001-10-01 15:05:09
SELECT stgpool_name AS ["STORAGEPOOL"], sum(physical_mb) AS ["MB's"]
FROM occupancy
GROUP BY stgpool_name;
>>> jbassi AT IHWY DOT COM 09/28/01 05:17PM >>>
All,
I am looking for a select statement that will enable me to determine the
total amount of
data backed up (disk and tape). I know I can use 'select * from stgpools'
and see 1) est_capacity_mb and 2) the pct_utilized. Is there an SQL
function where I can do the math and get the 1) capacity used for each
stgpool and 2) capacity used for all stgpools.
--
Joshua S. Bassi
Joshua S. Bassi
Independent IT Consultant
IBM Certified - AIX/HACMP, SAN, Shark
Tivoli Certified Consultant- ADSM/TSM
Cell (408)&(831) 332-4006
jbassi AT ihwy DOT com
|
|
|