The scenario is I have a copy pool tape that was accidently damaged. I
would like to know which primary pool tapes I would need to recreate
this copypool tape. The first obvious way is to run a backup stgpool
preview=yes command however that will ALSO show other volumes out of
sync and doesn't really give me the mapping directly to the 1 volume.

Is there a select query I can run where the input is the copypool
volume and it returns the primary pool volumes? I am pretty sure I
used to have this query and can't located it now that I need it.

Appreciate the help!