I think that the VOLUMEUSAGE table is probably your best bet for this
info. I'd suggest a query like this:

   select distinct volume_name, node_name
      from volumeusage
      where stgpool_name='POOLNAME'
      order by volume_name, node_name

(substitute your copy storage pool name for POOLNAME).

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.




Joe Howell <jhowell_tsm AT YAHOO DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
08/11/2003 07:21
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Help with query



I've got a collocated offsite copy storage pool and need to get a list of
what nodes are represented on what volumes.  The only way I know of is to
issue a "select distinct node_name from volumeusage where
volume_name=<volume>" but this seems inelegant and in any case takes a
VERY, VERY long time.  Is there a better way to get this information?



Joe Howell
Shelter Insurance Companies
Columbia, MO

---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software