ADSM-L

Re: Command to list Copy pool mountable tapes

2005-09-08 11:11:09
Subject: Re: Command to list Copy pool mountable tapes
From: "Prather, Wanda" <Wanda.Prather AT JHUAPL DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 8 Sep 2005 11:10:51 -0400
If you don't want to use DRM, here's another way:  Change OFFSITETAPE to
the name of your COPYPOOL.

select volume_name from volumes where stgpool_name='OFFSITETAPE' and
volume_name in (select volume_name from libvolumes)

Wanda Prather
"I/O, I/O, It's all about I/O"  -(me)


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Ray Louvier
Sent: Wednesday, September 07, 2005 6:57 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Command to list Copy pool mountable tapes


Does anyone have a select or query command to list copy pool tapes that
are in the library only. 

 

Office: 281-871-5502  |  Mobile: 713-471-1844

 

----------------------------------------------------------------------
This e-mail, including any attached files, may contain confidential and
privileged information for the sole use of the intended recipient.  Any
review, use, distribution, or disclosure by others is strictly
prohibited.  If you are not the intended recipient (or authorized to
receive information for the intended recipient), please contact the
sender by reply e-mail and delete all copies of this message.

<Prev in Thread] Current Thread [Next in Thread>