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.