Re: SELECT statement to determine if any drives available

ADSM-L

[Top] [All Lists]

Re: SELECT statement to determine if any drives available

2002-12-19 09:44:49

Subject:	Re: SELECT statement to determine if any drives available
From:	David E Ehresman <deehre01 AT LOUISVILLE DOT EDU>
To:	ADSM-L AT VM.MARIST DOT EDU
Date:	Thu, 19 Dec 2002 09:38:33 -0500

 select drive_name,drive_state,allocated_to,online from
  drives

>>> csa AT FERROSAN DOT COM 12/19/02 07:34AM >>>
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

[More with this subject...]

<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

Previous by Date:	Re: Disaster Recovery Test, Kauffman, Tom
Next by Date:	Re: Disaster Recovery Test, Joe Pendergast
Previous by Thread:	Re: SELECT statement to determine if any drives available, Cook, Dwight E
Next by Thread:	Re: SELECT statement to determine if any drives available, Christian Sandfeld
Indexes:	[Date] [Thread] [Top] [All Lists]