Ok Eric,

Here's what you're looking for I think (this one challenged me...)

This command gives the following output

adsm> select contact, occupancy.node_name, sum(logical_mb) as STORAGE_MB from
      nodes, occupancy where nodes.node_name = occupancy.node_name group by
      contact, occupancy.node_name

CONTACT              NODE_NAME                  STORAGE_MB
------------------           ------------------
                   ---------------------------------
                   ---------------------------------

John Sorensen          BEBEAR                      463.82
John Sorensen          BEEBEE                      1105.20
Kelly Lipp                 LIPSTR                         13783.56
Kelly Lipp, Laptop     WEAZER                      2470.04
Laura Buckley          BIRD                              1013.30
Laura Buckley          LOLA                             3393.12
Laura's System        SNAIL                              698.00
Nicole's PC              COLE                              1562.06
strat                         STRAT                            1549.06

Laura Buckley
Storage Solutions Specialists, Inc.
(719) 531-7171
buckley AT storsol DOT com