Guru's,

In our continued effort to use ADSM in a cruel and unusual manner we need to
determine which tapes contain a set of files.

So far our best effort involves using a shell script to query volumes in the
stgpool, query contents of these volumes, and grep for file_name.

This seems to work, but I'm sure there must be a nicer way - perhaps via the
SQL interface. So far though my SQL attempts seem remarkably slow to
execute.

Does anyone have a nice *fast* SQL query to determine which tapes contain a
certain set of files?

Thanks,
Steven P.