Considering that I've gone the other direction, from the contents of a tape to 
the backup date of every object on the tape, it should be possible, but it 
might not be practical; the TSM V6 DB tables aren't indexed very well for this 
kind of work. 

Complications might include inactive copies of the file you're looking for and 
copy pool copies. 

If you know when the file was backed up, you might play with EXPORT NODE and 
the PREVIEW option, not to mention limiting the dates of the data being backed 
up and see what that gets you. 

The collocation policies you use might influence your techniques some; the more 
tightly you collocate, the more manageable starting with QUERY NODEDATA and 
going to Q CONTENT becomes -- although that doesn't deal with inactive copies 
with any delicacy. 

Datamining on TSM: just another fun day with the database! 

Nick

On Jun 28, 2012, at 7:38 PM, Geoff Gill wrote:

> Hello,
>  
> Over the years I've saved a lot of commands but never saw one for this. I'm 
> not sure if it is possible but I thought I'd ask to see if anyone has it.
>  
> Is it possible to create a select command that I input the name of a file 
> that was backed up and have the output tell me what tape(s) it would be on? I 
> have a command that will tell me all the tapes a node has data on, and 
> another to spit out the contents of a tape to a file, and from there search 
> for the filename but I'm curious if there is an easier way.
>  
> Thank You
> Geoff Gill
>