How About this? Would it provide a list of volumes used by each node is a storage pool?:
select distinct volume_name,node_name,stgpool_name from volumeusage where not stgpool_name='<my_store_pool_name>'
How About this? Would it provide a list of volumes used by each node is a storage pool?:
select distinct volume_name,node_name,stgpool_name from volumeusage where not stgpool_name='<my_store_pool_name>'