Re: Select Query Question

2003-03-03 Thread Richard Sims
>I'm trying to devise a select query that will show me the client backups >for the prev night with the following info:- > >files checked >backed up >N transfer rate >A transfer rate >elapsed time etc. > >Other than going throught the q actlog route, is there a way to get this >info using a select q

Select Query Question

2003-03-03 Thread Farren Minns
Hi TSMers I'm trying to devise a select query that will show me the client backups for the prev night with the following info:- files checked backed up N transfer rate A transfer rate elapsed time etc. Other than going throught the q actlog route, is there a way to get this info using a select q

Re: select query question

2003-01-22 Thread Coats, Jack
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 dat

Re: select query question

2003-01-22 Thread Andrew Raibeck
your friend. "Good enough" is the enemy of excellence. Richard Sims <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 01/22/2003 14:01 Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc

Re: select query question

2003-01-22 Thread Richard Sims
>Neat. ... I wonder where that information is stored? Even the GUI has to >get it from somewhere :) Why, it's right there in the TSM db! ;-) We can't see it via Select because that's a "fake" view of the database, revealing only a subset of what's there, as the server administrator - by role de

Re: select query question

2003-01-22 Thread Andrew Raibeck
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: Su

Re: select query question

2003-01-22 Thread David Longo
uot;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

Re: select query question

2003-01-22 Thread Coats, Jack
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

Re: select query question

2003-01-22 Thread Richard Sims
>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. ... I believe that only the client GUI can provide

Re: select query question

2003-01-22 Thread Thomas Denier
> 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.t

Re: select query question

2003-01-22 Thread Andrew Raibeck
]> 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 timestam

select query question

2003-01-22 Thread David Longo
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 back