Here is the command I use to determine what volumes in TAPEPOOL are needed for a specific node client.
select distinct node_name,volume_name,stgpool_name from volumeusage where stgpool_name='TAPEPOOL' and node_name='NODENAME'
This will give you a total volume count for a specific client
select count(distinct volume_name) as volumes, from volumeusage where stgpool_name='TAPEPOOL' and node_name='NODENAME
select distinct node_name,volume_name,stgpool_name from volumeusage where stgpool_name='TAPEPOOL' and node_name='NODENAME'
This will give you a total volume count for a specific client
select count(distinct volume_name) as volumes, from volumeusage where stgpool_name='TAPEPOOL' and node_name='NODENAME