What is the best why to identify what tape volumes a backup object is residing on.

[Brian G. Kunst]

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