Brian,

"q noded ucsfscl1_2 stg=poolname"

Will give you the potential volume numbers.  You can add these as a limiter of 
your select

"and volume_name in (list from q noded)"


Fred Johanson
TSM Administrator
University of Chicago

773-702-8464



-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Brian G. Kunst
Sent: Wednesday, October 07, 2009 1:18 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] What is the best why to identify what tape volumes a backup 
object is residing on.

For security reasons, we're trying to identify what tapes a file is residing 
on.  I've found the object_id of the file we're looking for, 1524734887, and 
started a search of the CONTENTS table using the following sql command:
                                                 
SELECT * FROM CONTENTS WHERE NODE_NAME='UCSFSCL1_2' AND OBJECT_ID=1524734887 > 
/home/bkunst/qcontents.out
            
This search has been running for over 24 hours now.  Is there a quicker/better 
way to search for the volume_id for this file?
         
Thanks,
 
--
Brian Kunst
Storage Administrator
UW Technology