one crude way is to do a restore and look for the tape requested...q sess
f=d
for offsite tapes...restore volume preview=yes

-----Original Message-----
From: Braich, Raminder [mailto:raminder.braich AT DAVEY DOT COM]
Sent: Friday, August 23, 2002 8:25 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Which volume contains the backups
Importance: High


Hello,
   We backup our SAP/Oracle system using TDP for R/3. The OS is windows NT.
I am trying to find out the volumes which contain the backups from last
Friday(08/16/2002) for our production server. I have tried querying
volumeusage table but it does not take the date condition. I would also like
to know the copypool tapes that contain that backup and are offsite.  Does
anyone know how to go around this.
  Any and all help is very much appreciated.

Thanks
Raminder Braich
SAP/Oracle DBA