Thanks Del!
I actually figured out what works: select * from backups where node_name='LNBRTZM315YR' and backup_date between '06/30/2008' and '02/01/2009' and ll_name like '%lidz4dx%' but now I'm trying to find the tape this object is on and that'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 < at > VM.MARIST.EDU] On Behalf Of Del Hoobler
Sent: Friday, February 10, 2012 9:11 AM
To: ADSM-L < at > VM.MARIST.EDU
Subject: Re: Help! Select statement syntax for legal reasons
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 < at > vm.marist.edu> wrote on 02/10/2012
08:35:02 AM:
From: "Moyer, Joni M" <joni.moyer < at > HIGHMARK.COM>
To: ADSM-L < at > 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 < at > 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 < at > VM.MARIST.EDU] On
Behalf Of Del Hoobler
Sent: Friday, February 10, 2012 8:26 AM
To: ADSM-L < at > 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 < at > vm.marist.edu> wrote on 02/09/2012
03:44:49 PM:
From: Xav Paice <xpaice < at > OSS.CO.NZ>
To: ADSM-L < at > 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 < at > 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.moyer < at > 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 < at > VM.MARIST.EDU] On
Behalf
Of George Huebschman
Sent: Thursday, February 09, 2012 2:02 PM
To: ADSM-L < at > 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.Denier < at > 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.
