Not exactly sure what you are looking for, but here is a report I run
daily on all our tsm servers.  It gives a single line occupancy per node
along with the domain.  It might be a starting place for you to work with.


    select -
         occupancy.node_name, -
         nodes.domain_name, -
         sum(occupancy.num_files), -
         sum(occupancy.physical_mb), -
         sum(occupancy.logical_mb) -
      from occupancy, nodes -
        where occupancy.node_name =  nodes.node_name -
        group by occupancy.node_name,  nodes.domain_name





From:   Yuvaraja Shivarama <yuvaraja.deepti AT GMAIL DOT COM>
To:     ADSM-L AT VM.MARIST DOT EDU
Date:   03/20/2012 07:17 AM
Subject:        sql query from tsm end.......please help me out.....
Sent by:        "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>



Hi all,

can any one knows how to extract the occupancy report along with
domain name and node together....

regards
Yuvaraj




-----------------------------------------
The information contained in this message is intended only for the
personal and confidential use of the recipient(s) named above. If
the reader of this message is not the intended recipient or an
agent responsible for delivering it to the intended recipient, you
are hereby notified that you have received this document in error
and that any review, dissemination, distribution, or copying of
this message is strictly prohibited. If you have received this
communication in error, please notify us immediately, and delete
the original message.