I am trying to find the tapes needed to recover only the "active" backups
of a client.  I used the following select command and it gives me a list of
all tapes for all backups of that client.  How can I narrow the search to
just "active" backups?

select volume_name,filespace_name from volumeusage where -
node_name='CLIENT NAME' and stgpool_name='STGPOOL'