Thanks Andy, that worked very well. Andrew Raibeck <[EMAIL PROTECTED]> 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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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