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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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@VM.MARIST.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