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
|