ADSM-L

Re: [ADSM-L] select for % used

2012-10-25 22:37:11
Subject: Re: [ADSM-L] select for % used
From: Nick Laflamme <nick AT LAFLAMME DOT US>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 25 Oct 2012 21:33:21 -0500
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

<Prev in Thread] Current Thread [Next in Thread>