One SQL Query that I like to use is :

select node_name as Node,count(distinct volume_name) as "Number of tapes
used" from volumeusage group by node_name

I've never checked to see whether it takes into account volumes used for
archives, but I can't imagine why not.


        -----Original Message-----
        From:   Frederic Landreville [SMTP:landrefl AT YAHOO DOT COM]
        Sent:   Tuesday, December 21, 1999 3:40 AM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        Re: SHOW VOLUMEUSAGE <node>

        Did you try "Q OCC" ???


        Frederic Landreville    email: landrefl AT yahoo DOT com
        Lead Technical Analyst --- Yahoo Messenger Id: LANDREFL
        R.J. Reynolds International B.V. (Hilversum) Geneva Branch
        14, Chemin Rieu CH-1211 Geneva 17
        Switzerland
        Tel: +41-22-703-0323 Fax: +41-22-703-0324

        "FAILURE IS NOT AN OPTION. It comes bundled with the software."
        ----- Original Message -----
        From: "Medico, Frederic" <FMedico AT KJS DOT COM>
        To: <ADSM-L AT VM.MARIST DOT EDU>
        Sent: Tuesday, December 21, 1999 10:25 AM
        Subject: SHOW VOLUMEUSAGE <node>


        > Apparently this command (show volumeusage <node>) only works
        > for backup'ed data ...
        >
        > Any tips for archive ?
        >
        > Thanks.
        >
        >
        > Frederic
        > SP2 System Engineer Anderlecht
        >
        >
        >
        >
        > -----Original Message-----
        > From: Nathan King [mailto:nathan.king AT USAA DOT COM]
        > Sent: Monday, December 20, 1999 10:46 PM
        > To: ADSM-L AT VM.MARIST DOT EDU
        > Subject: Re: SHOW VOLUME
        >
        >
        > On the thread of SHOW. I found this lurking in my archives. It was
posted
        a
        > while back, but here it is again.
        >
        >  <<debug.html>>
        >
        >         -----Original Message-----
        >         From:   Remeta, Mark [SMTP:MRemeta AT SELIGMANDATA DOT COM]
        >         Sent:   Monday, December 20, 1999 3:34 PM
        >         To:     ADSM-L AT VM.MARIST DOT EDU
        >         Subject:        Re: SHOW VOLUME
        >
        >         Hey! Thanks Richard. SHOW VOLUMEUSAGE works!
        >         I never knew what the full command name was and just used
SHOW
        > VOLUME and it
        >         use to work. I guess now you have to type the entire
command out
        and
        > not
        >         just VOLUME.
        >
        >         Mark
        >
        >
        >         -----Original Message-----
        >         From: rbs AT bu DOT edu [mailto:rbs AT bu DOT edu]
        >         Sent: Monday, December 20, 1999 4:30 PM
        >         To: MRemeta AT SELIGMANDATA DOT COM
        >         Subject: SHOW VOLUME
        >
        >
        >         Mark - Do you mean the 'SHOW' command itself is no longer
        > recognized?
        >                Or the subcommand?  Even if you fully spell it out
as
        >         'SHow VOLUMEUSAGE NodeName'?
        >             If so, we'll have to do SQL Selects from now on.
        Richard