SELECT VOLUME_NAME FROM VOLUMEUSAGE WHERE NODE_NAME='node_name'

Regards,
Rama





-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: Wednesday, March 22, 2006 10:05 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Find what tape a particular backup resides on


Hello everyone,

I am trying to figure out what tape a particular backup is on for our
NAS
NDMP full backups.  I noticed that you can query the node_name, FSID,
filespace_name, etc.  but is there a way that I can tie the volume table
onto this so that I can see which tape(s) have server_1's backups on?
This
is on a TSM 5.2.4.5 server on AIX.  Thanks in advance!

********************************
Joni Moyer
Highmark
Storage Systems, Senior Systems Programmer
Phone Number: (717)302-9966
Fax: (717) 302-9826
joni.moyer AT highmark DOT com
********************************
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the sender, 
delete it and do not read, act upon, print, disclose, copy, retain or 
redistribute it. Click here for important additional terms relating to this 
e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------