I use the following script I got from this list (probably):

/*  -------------------------------------------*/
/*  Script Name: vols-node                     */
/*  Description: List volumes per node         */
/*  Parameter:   nodename                      */
/*  Author:      ilja.coolen AT abp DOT nl            */
/*  Example:  run vols-node myUnixBox          */
/*  !!! WARNING !!! RESOURCE INTENSIVE !!!     */
/*  -------------------------------------------*/
select volumes.volume_name as "Volume",-
volumes.stgpool_name as "StgPool",-
volumes.est_capacity_mb as "Cap.(MB)",-
volumes.pct_utilized as "Utlzd(%)",-
volumes.status as "Status",-
volumeusage.filespace_name as "Filespace" -
from volumes,volumeusage -
where volumes.volume_name=volumeusage.volume_name and -
volumeusage.node_name=upper('$1')

HTH
Thomas Rupp 

-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] Im Auftrag 
von Joni Moyer
Gesendet: Freitag, 18. November 2005 21:19
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: [ADSM-L] Find # of tapes used per node


Hello,

I am trying to find out the number of onsite & offsite tapes that a
particular group of nodes are using.  I have been using the following
select statement:

select distinct count(*) as "Volume Count",node_name from volumeusage where
stgpool_name like 'COPY%' and node_name like 'FJSU%' group by node_name

select distinct count(*) as "Volume Count",node_name from volumeusage where
stgpool_name like 'TAPE%' and node_name like 'FJSU%' group by node_name

but the results I get are adding up to more than the total number of tapes
that are being used by the environment, so I believe that I am getting
incorrect data.  Could someone please let me know what I might be doing
wrong?  Thanks!

********************************
Joni Moyer
Highmark
Storage Systems, Systems Programmer
Work:(717)302-6603
(717)302-9966 (NEW NUMBER as of 11/17/2005)
(717) 302-9826 (NEW FAX after 11/17/2006)
joni.moyer AT highmark DOT com
********************************