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'
