Or you can

      q med * stg=COPYPOOL wherest=mountablei


At 11:10 AM 9/8/2005 -0400, you wrote:

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.

Fred Johanson
ITSM Administrator
University of Chicago
773-702-8464