Re: Help! Select statement syntax for legal reasons

2012-02-10 Thread Moyer, Joni M
#x27;s taking quite a while. I'm not even sure it will return a result at this point in time. Thanks again! -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: Friday, February 10, 2012 9:11 AM To: ADSM-L@VM.MARIST.EDU Subje

Re: Help! Select statement syntax for legal reasons

2012-02-10 Thread Del Hoobler
2012 08:35:02 AM: > From: "Moyer, Joni M" > To: ADSM-L@vm.marist.edu > Date: 02/10/2012 08:37 AM > Subject: Re: Help! Select statement syntax for legal reasons > Sent by: "ADSM: Dist Stor Manager" > > Thanks Del! > > If I were looking for lidb88n

Re: Help! Select statement syntax for legal reasons

2012-02-10 Thread Moyer, Joni M
en '06/30/2008' and '02/01/2009' and ll_name='/mail/lidb88n.nsf.*'? -Original Message- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Del Hoobler Sent: Friday, February 10, 2012 8:26 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: Help! Se

Re: Help! Select statement syntax for legal reasons

2012-02-10 Thread Del Hoobler
ks, Del Del Hoobler Tivoli Storage Manager Development IBM Corporation "ADSM: Dist Stor Manager" wrote on 02/09/2012 03:44:49 PM: > From: Xav Paice > To: ADSM-L@vm.marist.edu > Date: 02/09/2012 03:48 PM > Subject: Re: Help! Select statement syntax for

Re: Help! Select statement syntax for legal reasons

2012-02-09 Thread Xav Paice
t; Any thoughts/ideas? > > Thanks! > > -Original Message- > From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf > Of George Huebschman > Sent: Thursday, February 09, 2012 2:02 PM > To: ADSM-L@VM.MARIST.EDU > Subject: Re: Help! Select statement syntax for

Re: Help! Select statement syntax for legal reasons

2012-02-09 Thread Moyer, Joni M
2 2:02 PM To: ADSM-L@VM.MARIST.EDU Subject: Re: Help! Select statement syntax for legal reasons I agree with Thom, the data gets spread everywhere and moved often by reclamation. You can only tell them where it was when you ran the report. On Thu, Feb 9, 2012 at 1:35 PM, Thomas Denier < thomas.den..

Re: Help! Select statement syntax for legal reasons

2012-02-09 Thread Ajay Patel
Hi, Please check this link https://www-304.ibm.com/support/docview.wss?uid=swg21114873 Regards, Ajay Patel From: George Huebschman To: ADSM-L@vm.marist.edu, Date: 02/09/2012 12:10 PM Subject:Re: [ADSM-L] Help! Select statement syntax for legal reasons Sent by:"

Re: Help! Select statement syntax for legal reasons

2012-02-09 Thread Richard Sims
My suspicion is that the legal request is a lawyer's pro forma procedure written in the 1980s for collecting evidentiary information in a data processing environment: "Obtain a list of the tapes upon which the data resides". It's likely that they don't actually care what tapes are involved: th

Re: Help! Select statement syntax for legal reasons

2012-02-09 Thread George Huebschman
I agree with Thom, the data gets spread everywhere and moved often by reclamation. You can only tell them where it was when you ran the report. On Thu, Feb 9, 2012 at 1:35 PM, Thomas Denier < thomas.den...@jeffersonhospital.org> wrote: > -Joni Moyer wrote: - > > >I have a situation where

Re: Help! Select statement syntax for legal reasons

2012-02-09 Thread George Huebschman
Joni, It isn't elegant, and it won't produce a report format, but it should narrow your search down a lot and make a query of the Contents Table a lot lighter: You could try initiating restores of the data to see what tapes are called for. Just check the actlog. Then you could do a select aga

Re: Help! Select statement syntax for legal reasons

2012-02-09 Thread Thomas Denier
-Joni Moyer wrote: - >I have a situation where someone wants to know what tapes particular >people's backup data is on for our TDP for Mail backups for the time >period from 7/08 - 1/09. The TSM client names are LNBRTZM3*5YR and >the mail filesystem location is: mailx and the .nsf file na

Help! Select statement syntax for legal reasons

2012-02-09 Thread Moyer, Joni M
Hi Everyone, I have a situation where someone wants to know what tapes particular people's backup data is on for our TDP for Mail backups for the time period from 7/08 - 1/09. The TSM client names are LNBRTZM3*5YR and the mail filesystem location is: mailx and the .nsf file names we are lookin