Hi Joni, Sorry... I am not a SQL expert. I will let one of the other SQL experts assist with your question. I just wanted to make sure that you had the correct object names.
Thanks, Del ---------------------------------------------------- "ADSM: Dist Stor Manager" <ADSM-L@vm.marist.edu> wrote on 02/10/2012 08:35:02 AM: > From: "Moyer, Joni M" <joni.mo...@highmark.com> > 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" <ADSM-L@vm.marist.edu> > > Thanks Del! > > If I were looking for lidb88n.nsf files from the server > LNBRTZM315YR, then would the syntax be as follows? I'm trying to > find all backup objects during the time period below? Thanks again! > > select * from backups where node_name='LNBRTZM315YR' and backup_date > between '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! Select statement syntax for legal reasons > > When formulating your queries, please keep this in mind... > > From the Data Protect for Domino User's Guide... > > A single database backup is stored as two objects on the > Tivoli Storage Manager server. The objects created are the > relative database name and the relative database name > plus a .DATA extension. For example, a backup of > database mail6\user1.nsf would result in the following two objects: > > 1. The relative name of the database: > > mail6\user1.nsf > > 2. The relative name of the database plus .DATA: > > mail6\user1.nsf.DATA > > > Thanks, > > Del > > ---------------------------------------------------- > > Del Hoobler > Tivoli Storage Manager Development > IBM Corporation > > > > "ADSM: Dist Stor Manager" <ADSM-L@vm.marist.edu> wrote on 02/09/2012 > 03:44:49 PM: > > > From: Xav Paice <xpa...@oss.co.nz> > > To: ADSM-L@vm.marist.edu > > Date: 02/09/2012 03:48 PM > > Subject: Re: Help! Select statement syntax for legal reasons > > Sent by: "ADSM: Dist Stor Manager" <ADSM-L@vm.marist.edu> > > > > You could, if you really want a SQL query, run the following SQL on > > a regular basis and dump the output to a file, which will give you a > > listing on the day of the tapes for that criteria: > > > > SELECT VOLUME_NAME from contents where object_id in (SELECT > > object_id FROM backups WHERE node_name LIKE 'LNBRTZM3%5YR' AND > > ll_name LIKE 'training%.nsf') > > > > If that wildcard is supposed to be just one character replace % with > > _ , but I took * in your question to mean 'one or more of any > > character'. Pedantic, but please ignore my own spelling and typos. > > > > However, the query will probably take an age to run and you'll need > > to keep a close eye on the server in case of log pinning etc. I'd > > advise against it if possible. > > > > Note that, as previously noted, a query like this will only give you > > a current snapshot - you seem to be asking which tapes the data was > > on between some dates in the past - I don't know how to do that. > > You could tell the auditors to advise you what data to collect for > > them to query you on at a later date...maybe you need to pull a > > complete TSM database backup out of the cycle and pop it on a shelf > > on a regular basis to keep them happy. > > > > DISCLAIMER - I've not tested that query, it might have errors I've > > not spotted. > > > > > > ----- "Joni M Moyer" <joni.mo...@highmark.com> wrote: > > > > > > > > > > I guess that's what I'm looking for today. A report that will show me > > > where that particular file is on what particular tape for LNMBRZM355YR > > > for the mail1 filesystem for the training.nsf database for the time > > > frame of 7/08 - 1/09. It's just proof for them of where it resides as > > > of today. I just don't know what the syntax of the SQL statement > > > should be to get that information? > > > > > > 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 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...@jeffersonhospital.org> wrote: > > > > > > > -----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 names we > > > are > > > > >looking for are the training*.nsf and we need to know what tapes > > > the > > > > >data is on. > > > > > > > > > > > > > > >LNBRTZM335YR, mail1\training.nsf > > > > > > > > > >LNBRTZM355YR, mail2\training2.nsf > > > > > > > > > >Does anyone know what the syntax of this select statement would be > > > to > > > > >find this information? Any help is greatly appreciated as I was > > > told > > > > >I need this information by EOD and I'm not quite sure how to > > > gather > > > > >this from the TSM server side. My TSM server is on AIX and is at > > > > >5.5.5.0. > > > > > > > > TSM files on tape are more or less routinely moved to other volumes > > > > by reclamation processing. As far as I can tell, there are three > > > > possible ways of dealing with this possibility: suppress > > > reclamation > > > > of the volumes involved, send updates to the lawyers when and if > > > > files are move to other volumes, or respond in bad faith by > > > implying > > > > that today's information will remain valid indefinitely. > > > > > > > > Thomas Denier > > > > > > > ________________________________ > > This e-mail and any attachments to it are confidential and are > intended solely for use of the individual or entity to whom they are > addressed. If you have received this e-mail in error, please notify > the sender immediately and then delete it. If you are not the > intended recipient, you must not keep, use, disclose, copy or > distribute this e-mail without the author's prior permission. The > views expressed in this e-mail message do not necessarily represent > the views of Highmark Inc., its subsidiaries, or affiliates. >
