Well I tried this command and I recvd the below output. I still do not know
which volumes....it just tellsme how many. Any more hints? The would be
appreciated.

adsm> select node_name as aixs70a,count(distinct volume_name) as "Number of tap
      es used" from volumeusage group by node_name
ANR2963W This SQL query may produce a very large result table, or may require a
significant amount of time to compute.
Do you wish to proceed? (Yes/No) y
AIXS70A                Number of tapes used
------------------     --------------------
ADSMRS                                   58
ADSMRS                                   58
AF_REMOTE                                 2
AIX01                                    94
AIX02                                    56
AIX03                                    95
AIX07                                    75
AIX08                                    51
AIX0A                                    41