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:ads...@vm.marist.edu] On Behalf Of Brian G. Kunst Sent: Wednesday, October 07, 2009 1:18 PM To: ADSM-L@VM.MARIST.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
