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 <nick AT laflamme DOT 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 <avalnche96 AT YAHOO DOT 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