Hi Jack,

The information is indeed stored in the database, but not exposed through
the SELECT or QUERY commands. The attributes are platform-specific, and
the server is not "aware" of the attribute structures for each platform.
To the server, they are just a "blob" of data.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.eyebm DOT com (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.




"Coats, Jack" <Jack.Coats AT BANKSTERLING DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
01/22/2003 13:21
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: select query question



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]