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

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 query of

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

Re: select query question

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

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.txt

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 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 question In general

Re: select query question

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

Re: select query question

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

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

Re: select query question

2003-01-22 Thread Andrew Raibeck
is 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: Subject:Re: select query question

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 database