This select statement is a bit faster, I think:

 select volume_name from volumes
    where devclass_name='LTOCLASS1'
      and stgpool_name in
        (select distinct stgpool_name from occupancy where type='Bkup')

 Rainer Schöpf


-----Original Message-----
On Mon, 25 Feb 2008 at 15:03 -0500, William Boyer wrote:

 > Might run for a while
 > 
 >      Select distinct volume_name from contents where type='Arch'
 > 
 > Bill Boyer
 > Tell me again how lucky I am to be working here...I keep forgetting!
 > 
 > 
 > -----Original Message-----
 > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
 > Of Lepre, James
 > Sent: Monday, February 25, 2008 2:53 PM
 > To: ADSM-L AT VM.MARIST DOT EDU
 > Subject: Re: Archive Data
 > 
 > Yes that works, but know I need to find out which tapes have archive data
 > 
 > -----Original Message-----
 > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
 > Of Stapleton, Mark
 > Sent: Monday, February 25, 2008 2:35 PM
 > To: ADSM-L AT VM.MARIST DOT EDU
 > Subject: Re: [ADSM-L] Archive Data
 > 
 > Query occupancy <node_name> stgp=<stgpool_name> type=archive Query occupancy 
 > <node_name> stgp=<stgpool_name> type=backup
 > 
 > --
 > Mark Stapleton
 > CDW Berbee
 > System engineer
 > 7145 Boone Avenue North, Suite 140
 > Brooklyn Park MN 55428-1511
 > 763-592-5963
 > www.berbee.com
 > 
 > > -----Original Message-----
 > > From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On 
 > > Behalf
 > Of
 > > Lepre, James
 > > Sent: Monday, February 25, 2008 1:13 PM
 > > To: ADSM-L AT VM.MARIST DOT EDU
 > > Subject: Re: [ADSM-L] Archive Data
 > >
 > > Hello Everyone,
 > >
 > >    Does anyone know a sql statement that would produce what type of
 > data
 > > is on the tapes?  I am trying to figure out which tapes have backup
 > data
 > > on them and which tapes have archive data on them.
 > >
 > > TSM SERVER VERSION 5.4.1.1
 > >
 > > Any help is always appreciated
 > >
 > > Thank you
 > >
 > > James
 > >
 > >
 > >
 > > ---------------------------------------------------------------
 > > Confidentiality Notice: The information in this e-mail and any
 > attachments
 > > thereto is intended for the named recipient(s) only.  This e-mail,
 > > including any attachments, may contain information that is privileged
 > and
 > > confidential  and subject to legal restrictions and penalties
 > regarding
 > > its unauthorized disclosure or other use.  If you are not the intended
 > > recipient, you are hereby notified that any disclosure, copying,
 > > distribution, or the taking of any action or inaction in reliance on
 > the
 > > contents of this e-mail and any of its attachments is STRICTLY
 > PROHIBITED.
 > > If you have received this e-mail in error, please immediately notify
 > the
 > > sender via return e-mail; delete this e-mail and all attachments from
 > your
 > > e-mail  system and your computer system and network; and destroy any
 > paper
 > > copies you may have in your possession. Thank you for your
 > cooperation.
 > 

   Rainer Schöpf