Brian, my ADSM server choked on your SQL statement... it didn't like the
"as". However, I did work this out on my own:
select node_name, sum(capacity * (PCT_UTIL/100)) from filespaces group by
node_name
It works the way I want it to, but I'd like to round the result... I tried a
few obvious syntaxes, but no dice. Any suggestions?
Daniel Swan
HP Unix Team
ISM-BC
3030 2nd Ave SE
Calgary, AB, T2A 5N7
ph. 403-530-1726
fax: 403-530-1066
> -----Original Message-----
> From: Johnson, Brian [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, September 20, 2000 10:23 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Another ADSM capacity question
>
> You could try,
>
> select node_name, sum(physical_mb), as DATA_IN_MB, sum(num_files) from
> occupancy group by node_name order by node_name
>
>
> Brian Johnson
> Merrill Lynch
>
> 212-647 3557
>
>
