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
I use the following select statement to list all tapes for the pimary storagepools last written from yesterday 19:00 to today 10:00. select volume_name as Volume, stgpool_name as Stgpool, date(last_write_date) as "Date", - time(last_write_date) as "Time" from volumes where - last_write_date >

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

2006-03-22 Thread Schaub Joachim Paul ABRAXAS INFORMATIK AG
If the object_ID is nnn then issue the command: SHOW BFO 0 nnn Which will show you the volume name -Ursprüngliche Nachricht- Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Joni Moyer Gesendet: Mittwoch, 22. März 2006 16:05 An: ADSM-L@VM.MARIST.EDU Betreff: [