Select volume_name fron contents where object_id in (select object_id from 
contents where volume_name='volumename') and stgpool='primarypoolname') group 
by volume_name

I think it would take a LONG freaking time to run, though.

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Lepre, James
Sent: Tuesday, February 24, 2009 1:49 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Select Statement

Hello Everyone,

 

 Is there a select statement or preview to see which tapes will be needed to 
reclaim an offsite volume. 

 

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.