I would go at it in the opposite direction.

First Richard's query:

SELECT * FROM BACKUPS WHERE NODE_NAME='____' AND
FILESPACE_NAME='____' AND HL_NAME='____' AND LL_NAME='____'

That will give you a list of the backup versions of the file, including
the DATE and the OBJECT_ID.

You can use the object ID to match the version to the tape:

show bfo 0 object-ID

If the file is NOT in an aggregate , it will either give you the volume
name

if the file is in an aggregate, it will give you the object id of the
"super bitfile", and you do

show bfo 0 object-ID again, this time with the object id of the "super
bitfile", and you will get the volume name.


How tedious it is, depends on how many versions of the file there are.

Details about using "show bfo", including examples, in technote 1166278.

Wanda Prather
"I/O, I/O, It's all about I/O"  -(me)





-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Richard Sims
Sent: Tuesday, June 21, 2005 2:56 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Need backup dates of files on a specific tape...


On Jun 21, 2005, at 2:41 PM, Richard Sims wrote:

>
> SELECT * FROM CONTENTS WHERE NODE_NAME='____' AND
> FILESPACE_NAME='____' AND HL_NAME='____' AND LL_NAME='____'
>

Duh... that should have said:

SELECT * FROM BACKUPS WHERE NODE_NAME='____' AND
FILESPACE_NAME='____' AND HL_NAME='____' AND LL_NAME='____'

      sorry about that,   Richard Sims