There's no such query that I can think of, since the CONTENTS table does
not include the object ID of the files in that table, so you can't tie
anything directly to the BACKUPS table.

However, another possible approach: Assuming you know the file name you
are looking for (and it sounds like you do), you could go to the client
machine from which it was backed up, and use "dsmc query backup
yourfilename -inactive" to see all existing versions. Save the output,
which includes the backup date. Delete the volume (this is irreversible,
so don't do this until you are good & ready!!!), then repeat the client
query. Comparing the results of the two queries, the version that does not
appear in the second query output is the missing version. You can do this
for all required files, tedious as it might be.

Any particular reason you need the backup dates?

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-06-21
10:59:33:

> Hello All-
>
> My team lead posted this question to ADSM.org with no results- so I'll
> warn you now, it's a stumper!
>
> I have a situation where a tape has been destroyed and cannot be
> restored from offsite tapes. I need to know the backup date of the file
> on the tape. Does anyone have a select statement for this?
>
> Any takers? Thanks for your time. -JG