Re: select statement using filespaces and tapes

2002-08-02 Thread Seay, Paul
quot;ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 31-Jul-2002 09:14 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: ADSM-L cc: Subject:Re: select statement using filespaces and tapes Marc, Don't think you c

Re: select statement using filespaces and tapes

2002-08-02 Thread Marc Lowers
or Manager" <[EMAIL PROTECTED]> 31-Jul-2002 09:14 Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: ADSM-L cc: Subject:Re: select statement using filespaces and tapes Marc, Don't think you can do this, includi

Re: select statement using filespaces and tapes

2002-07-31 Thread John Naylor
r('$2') - and stgpool_name = upper('$3') Marc Lowers <[EMAIL PROTECTED]> on 07/30/2002 05:00:29 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: (bcc: John Naylor/HAV/SSE) Subject: select stateme

Re: select statement using filespaces and tapes

2002-07-30 Thread Williams, Tim P {PBSG}
1st question...you have colocation on or off for the node/PD/storage of interest? -Original Message- From: Marc Lowers [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 30, 2002 11:00 AM To: [EMAIL PROTECTED] Subject: select statement using filespaces and tapes I'm looking for a s

select statement using filespaces and tapes

2002-07-30 Thread Marc Lowers
I'm looking for a select statement which will provide me with a list of tapes associated with a given node, filespace name and backup date. I've been looking into linking the backups table with another to provide the result but this has been unsuccessful so far. Am I close or miles off with thi