SELECT VOLUME_NAME FROM VOLUMEUSAGE WHERE NODE_NAME='node_name' Regards, Rama
-----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Wednesday, March 22, 2006 10:05 AM To: ADSM-L@VM.MARIST.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 [EMAIL PROTECTED] ******************************** -------------------------------------------------------- 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/ --------------------------------------------------------
