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 against the contents table (which can be huge)
for just those tapes and that Node.

I hope that is helpful.

George Huebschman

On Thu, Feb 9, 2012 at 12:22 PM, Moyer, Joni M <joni.moyer AT highmark DOT 
com>wrote:

> 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 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.
>
> Any help is greatly appreciated!
>
> Thanks in advance!
>
> Joni
>
>
> ________________________________
>
> 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.
>