If you have the activity log, a cheap&dirty method would be to select from
volumeusage, then reconcile with the tapes that were used during that period
(ie, search=' mounted' on the act-log query)... alternatively, do a query
vol & query content for each tape returned from the volumeusage table.  (You
could use the show cmd for volumeusage & other info, but that's another
story;  search the archives for the full list of show cmd arguments.)
Consider the following SELECT query, to queue up the right tapes:
select distinct node_name,volume_name,stgpool_name from volumeusage \
where node_name='ClientXYZ' and stgpool_name='3570POOL'


 -----Original Message-----
From:   Jolley, Bill
Sent:   Thursday, May 03, 2001 6:45 AM
To:     ADSM-L AT VM.MARIST DOT EDU
Subject:        Identify tape volumes

I am looking for a select statement to identify tape volumes used during an
oracle db backup
for a specific date (04/20/01).  Can anyone help me?

Thanks


William M. Jolley
EDS
9014 Research Drive
Charlotte, NC  28226

Tel:704-548-5524
pag:877-471-5029

email:bill.jolley AT eds DOT com