I found this select statement over@momo66. The following select statement will show the node name, total MB stored per node, number of tapes the data is spanned across and the average MB/tape. This can help estimate restore times and ensure your reclamation process is running efficiently.

select vu.node_name, ao.total_mb, count(distinct vu.volume_name) as tapes, ao.total_mb/count(distinct vu.volume_name) as "AVG MB/tape" from volumeusage vu, auditocc ao where vu.stgpool_name='TAPEPOOL' and vu.node_name=ao.node_name group by vu.node_name, ao.total_mb order by 4

Cheers
Ryan Partington