Thanks Andy and others, that was it. I don't use the Web client near as often as I use the Web Admin.
David Longo >>> [EMAIL PROTECTED] 01/22/03 03:02PM >>> In general you can not get a file's attributes with an admin client. You can find the file modification date via the GUI's restore function. You don't actually have to restore the file to do this. Regards, Andy Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS Internet e-mail: [EMAIL PROTECTED] (change eye to i to reply) The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. David Longo <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 01/22/2003 12:52 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: select query question 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 [EMAIL PROTECTED] "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. ============================================================================== "MMS <health-first.org>" made the following annotations on 01/22/2003 03:46:34 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. ==============================================================================