AW: [ADSM-L] AW: [ADSM-L] Find what tape a particular backup resides on

2006-03-22 Thread Thomas Rupp
on this table can run forever. Thomas -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Joni Moyer Gesendet: Mittwoch, 22. März 2006 17:06 An: ADSM-L@VM.MARIST.EDU Betreff: Re: [ADSM-L] AW: [ADSM-L] Find what tape a particular backup resides on

Re: AW: [ADSM-L] Find what tape a particular backup resides on

2006-03-22 Thread Joni Moyer
cc Manager" <[EMAIL PROTECTED] Subject .EDU> AW: [ADSM-L] Find what tape a

AW: [ADSM-L] Find what tape a particular backup resides on

2006-03-22 Thread Thomas Rupp
: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Joni Moyer Gesendet: Mittwoch, 22. März 2006 16:39 An: ADSM-L@VM.MARIST.EDU Betreff: Re: [ADSM-L] Find what tape a particular backup resides on Hello, I have tried this command: select * from volumeusage where node_name='

Re: Find what tape a particular backup resides on

2006-03-22 Thread Joni Moyer
<[EMAIL PROTECTED] .EDU> 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

AW: [ADSM-L] Find what tape a particular backup resides on

2006-03-22 Thread Schaub Joachim Paul ABRAXAS INFORMATIK AG
: [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

Re: Find what tape a particular backup resides on

2006-03-22 Thread Choudarapu, Ramakrishna (GTI)
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 w

Find what tape a particular backup resides on

2006-03-22 Thread Joni Moyer
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