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