Thanks Andy, that worked very well.

Andrew Raibeck <storman AT US.IBM DOT COM> wrote: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
Sent by: "ADSM: Dist Stor Manager"
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=" 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


Joe Howell
Shelter Insurance Companies
Columbia, MO

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