Help with query

2003-08-14 Thread Joe Howell
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.

Re: Help with query

2003-08-14 Thread Andrew Raibeck
is the enemy of excellence. Joe Howell [EMAIL PROTECTED] Sent by: ADSM: Dist Stor Manager [EMAIL PROTECTED] 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

Re: Help with query

2003-08-12 Thread Joe Howell
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