What about something along these lines - I can never get the math to work
right on SELECT statements (I'd just run two, and do the math myself...)
(select count(*) from volhistory where type='STGNEW') - (select count(*)
from volhistory where usage='STGDELETE') [that's a minus sign between the
two
Not exactly as what you wanted, but will this work better?
select count(*) as volumes_count, status from volumes where status in
('FULL','FILLING','Empty', 'PENDING') group by status
Sung Y. Lee
- Forwarded by Sung Y Lee/Austin/IBM on 04/20/2005 03:17 PM -
"ADSM: Dist Stor Manager" wro
This was what I finally provided to the person asking the question.
Try this as a define script input through the browser.
select summary.entity as ""NODE NAME"", nodes.domain_name as ""DOMAIN"",
nodes.platform_name as ""PLATFORM"", cast((cast(sum(summary.bytes) as float)
/ 1024 / 1024) as decima
