James Lepre Wed, 24 Mar 2004 07:47:09 -0800
Here is what you will need
select distinct node_name,volume_name,stgpool_name from volumeusage where node_name='xxxxx'