I use this kind of script ... It works
$1 node name
$2 name of pool

select
volumeusage.volume_name,volumes.access,volumes.error_state,volumeusage.stgpool_name

from volumeusage,volumes where volumeusage.node_name=upper('$1')and
volumeusage.stgpool_name='$2' and volumeusage.volume_name =
volumes.volume_name order by volume_name

Cordialement

François Chevallier
Parc Club du Moulin à Vent
33 av G Levy
69200 - Vénissieux France
tél : 04 37 90 40 56