Hello everyone! I run the report below to see the level of our nas toc disk pool and I was wondering if there is a way to also have another column called GB Utilized which multiplies total gb x percent utilized? I have tried this in so many different ways and I have not been successful. I'm not sure what I have been doing wrong, but it just won't work. Thank you in advance!
select stgpool_name as "Storage Pool",cast(est_capacity_mb/1024 as decimal(6,0)) as "Total GB",pct_utilized as "Percent Utilized" from stgpools where stgpool_name='NAS_TOC' Results of report: Storage Pool Total GB Percent Utilized ------------------ -------- ---------------- NAS_TOC 64 63.1 ******************************** Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] ********************************
