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
|