SELECT statement to determine if any drives available

Subject:	SELECT statement to determine if any drives available
From:	Christian Sandfeld <csa AT FERROSAN DOT COM>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Thu, 19 Dec 2002 13:34:03 +0100

Hi list,

Does anybody know of a SELECT statement that will show if any drives are
available for use (not in use by another process or session)?

I need this for scripting purposes as I have only two drives in my library,
and while doing reclamation both drives are in use.


Kind regards,

Christian

<Prev in Thread]	Current Thread	[Next in Thread>
SELECT statement to determine if any drives available, Christian Sandfeld <= Re: SELECT statement to determine if any drives available, Cook, Dwight E Re: SELECT statement to determine if any drives available, David E Ehresman Re: SELECT statement to determine if any drives available, Christian Sandfeld Re: SELECT statement to determine if any drives available, Prather, Wanda Re: SELECT statement to determine if any drives available, Gill, Geoffrey L. Re: SELECT statement to determine if any drives available, David Longo Re: SELECT statement to determine if any drives available, David E Ehresman Re: SELECT statement to determine if any drives available, David E Ehresman Re: SELECT statement to determine if any drives available, Jacque Mergens Re: SELECT statement to determine if any drives available, Seay, Paul