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:[EMAIL PROTECTED] On Behalf Of Lepre,
> James
> Sent: Monday, February 25, 2008 2:53 PM
> To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] On Behalf Of
> Stapleton, Mark
> Sent: Monday, February 25, 2008 2:35 PM
> To: ADSM-L@VM.MARIST.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:[EMAIL PROTECTED] On Behalf
> Of
> > Lepre, James
> > Sent: Monday, February 25, 2008 1:13 PM
> > To: ADSM-L@VM.MARIST.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
