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.
