SELECT stgpool_name AS ["STORAGEPOOL"], sum(physical_mb) AS ["MB's"] FROM occupancy GROUP BY stgpool_name;
>>> [EMAIL PROTECTED] 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 Independent IT Consultant IBM Certified - AIX/HACMP, SAN, Shark Tivoli Certified Consultant- ADSM/TSM Cell (408)&(831) 332-4006 [EMAIL PROTECTED]