Neat. ... I wonder where that information is stored? Even the GUI has to
get it from somewhere :)
> -----Original Message-----
> From: Andrew Raibeck [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, January 22, 2003 2:02 PM
> To: [EMAIL PROTECTED]
> Subject: Re: select query question
>
> 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
[Coats, Jack] [snip]
> 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
[Coats, Jack] [snip]
