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/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
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