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 DOT 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 DOT EDU] On Behalf
> Of George Huebschman
> Sent: Thursday, February 09, 2012 2:02 PM
> To: ADSM-L AT VM.MARIST DOT 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 DOT 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
>