Neat. ... I wonder where that information is stored?  Even the GUI has to
get it from somewhere :)

> -----Original Message-----
> From: Andrew Raibeck [SMTP:storman AT US.IBM DOT COM]
> Sent: Wednesday, January 22, 2003 2:02 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> 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 <David.Longo AT HEALTH-FIRST DOT ORG>
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 01/22/2003 12:52
> Please respond to "ADSM: Dist Stor Manager"
>
>
>         To:     ADSM-L AT VM.MARIST DOT EDU
>         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]