select volume_name from volumes where stgpool_name='<your primary pool>' and pct_utilized<'10' and status='FULL' or select volume_name from volumes where stgpool_name='<your primary pool>' and pct_utilized<'10'
On Fri, Oct 26, 2012 at 5:33 AM, Nick Laflamme <n...@laflamme.us> wrote: > 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
