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
cc
Manager"
<[EMAIL PROTECTED] Subject
.EDU> AW: [ADSM-L] Find what tape a
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 >
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: [