Hi,
This problem is old as ADSM, but become more important with clients become 
bigger and bigger.
I need to restore one folder for windows server and need list of tapes to be 
mounted. 
In past, when I needed to restore entire node, I used to use command:
select distinct * from volumeusage where node_name=’ my NODE ‘ 
so I get the list of 200-300 tapes, combined in script with the list of mounted 
tapes, to get a new list of 50-100 tapes needed to be mounted.
The other way is to start NQR (non query restore) which build list of needed 
tapes, and then to cancel restore and see the difference, of what need to be 
mounted.
IBM-TSM support advice is to send a DCR (Design Change Request), and request 
this funcionality of TSM in the future.
 
Now, I am wandering, is anybody ever faced the same issue and/or found some 
other trick or workaround for this and how.
Thanks,
Ferid.