Bob thanks for this SQL, is it normal to return the vales of

STGpoolname   name of storage pool
unnamed [2]     yyyyy
unnamed [3]     zzzzz

etc  what is unnamed 2, 3 etc?

> ----------
> From:         Brazner, Bob[SMTP:Bob.Brazner AT JCI DOT COM]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         19 January 2000 22:30
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      How can I calculate all used space in my storage-Pools
>
> <<File: pic19721.pcx>>
>
> Subject:
>                                                   How can I calculate all
>                                                   used space in my
>                                                   storage-Pools
>
> Attachment(s):
>                                                   <font size=-1></font>
> Try this:
> select stgpool_name, sum(physical_mb), sum(logical_mb) from occupancy
> group
> by stgpool_name
>
> Bob Brazner
> Johnson Controls, Inc.
> (Embedded image moved to file: pic19721.pcx)
>
>