Chris,

This select statement will give you by using node name.

select node_name, volume_name, stgpool_name from volumeusage where
node_name='MUSCAT1'

You can combine the two searching keys, for example

select node_name, volume_name, stgpool_name from volumeusage where
node_name='MUSCAT1' and filespace_name='/local/apps'

For more columns of 'volumeusage' table type

select * from syscat.columns where tabname='VOLUMEUSAGE'

Regard,
Abeid Al-Habsy
PDO, Oman