That's what the SQL Query was designed to do... I use it to generate a
report for chargeback.
If you want to see the volume numbers then just alter the query.

select distinct volume_name,node_name from volumeusage

should work



        -----Original Message-----
        From:   Michael Dummitt [SMTP:Michael.Dummitt AT ROSSNUTRITION DOT COM]
        Sent:   Tuesday, December 21, 1999 12:25 PM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        Re: SHOW VOLUMEUSAGE <node>

        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
        AF_REMOTE                                 2
        AIX01                                    94
        AIX02                                    56
        AIX03                                    95
        AIX07                                    75
        AIX08                                    51
        AIX0A                                    41