Ok, just wanted to make sure I wasn't missing something :) -----Original Message----- From: Andrew Raibeck [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 22, 2003 2:58 PM To: [EMAIL PROTECTED] Subject: Re: select query question
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: [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. "Coats, Jack" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 01/22/2003 13:21 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] 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:[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]