Did you replace 'LTOCLASS1' by the name of your device class?
Rainer
-----Original Message-----
On Mon, 25 Feb 2008 at 15:30 -0500, Lepre, James wrote:
> That did not work
>
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Rainer
Schöpf
> Sent: Monday, February 25, 2008 3:15 PM
> To: ADSM-L@VM.MARIST.EDU
> Subject: Re: [ADSM-L] Archive Data
>
> 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
>
Rainer Schöpf
