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)