One of my users wants to be able to see what the timestamp on
a backed up file is without restoring the file.  NOT the timestamp
of the time it was backed up but what the timestamp on the client
system was for that file when it was backed up.

Ex: backup was at 11pm last night and test.txt was backed up.
The timestamp of the file on the client at the time was 3:15pm.
Is there a sql select that shows this?  I looked at tables some and
it was not obvious, found the timestamp of the backup time but
not the actual "attributes" of the backup file.

I have TSM server 4.2.2.10.

Thanks,


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH      321.434.5536
Pager  321.634.8230
Fax:    321.434.5509
david.longo AT health-first DOT org


"MMS <health-first.org>" made the following
 annotations on 01/22/2003 02:54:10 PM
------------------------------------------------------------------------------
This message is for the named person's use only.  It may contain confidential, 
proprietary, or legally privileged information.  No confidentiality or 
privilege is waived or lost by any mistransmission.  If you receive this 
message in error, please immediately delete it and all copies of it from your 
system, destroy any hard copies of it, and notify the sender.  You must not, 
directly or indirectly, use, disclose, distribute, print, or copy any part of 
this message if you are not the intended recipient.  Health First reserves the 
right to monitor all e-mail communications through its networks.  Any views or 
opinions expressed in this message are solely those of the individual sender, 
except (1) where the message states such views or opinions are on behalf of a 
particular entity;  and (2) the sender is authorized by the entity to give such 
views or opinions.

==============================================================================