I think you meant to select from the BACKUPS table... the CONTENTS table doesn't have BACKUP_DATE, HL_NAME, or LL_NAME columns. But even then, if there are multiple versions, you can't easily distinguish which one is on a given volume.
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 11:41:55: > On Jun 21, 2005, at 1:59 PM, George, Jason wrote: > > > 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 > > > > Here's the least expensive way I know of doing this (where the tape > identity should > allow you to uniquely isolate the right file): > > Do 'Query CONtent <Volname> F=D' > where "Client's Name for File" contains HL_NAME and LL_NAME separated > by a space. > > then > > SELECT * FROM CONTENTS WHERE NODE_NAME='____' AND > FILESPACE_NAME='____' AND HL_NAME='____' AND LL_NAME='____' > > which yields the BACKUP_DATE. The Select should run quickly. > > Richard Sims