Off the top of my head: select volume_name from volumes where pct_utilized<10
You may also want to test for status='filling' compared to status='full' while you're at it. On Oct 25, 2012, at 9:20 PM, Geoff Gill <avalnch...@yahoo.com> wrote: > Hello, > > Anyone have a select that will show all the tapes that are in primary tape > pools that are less than 10% used? > > > > Thank You > Geoff Gill
