subject:"SELECT statement to determine if any drives available"

SELECT statement to determine if any drives available

2002-12-19 Thread Christian Sandfeld

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,

Re: SELECT statement to determine if any drives available

2002-12-19 Thread Cook, Dwight E

volume: AAE514. Dwight -Original Message- From: Christian Sandfeld [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 6:34 AM To: [EMAIL PROTECTED] Subject: SELECT statement to determine if any drives available Hi list, Does anybody know of a SELECT statement

Re: SELECT statement to determine if any drives available

2002-12-19 Thread David E Ehresman

select drive_name,drive_state,allocated_to,online from drives [EMAIL PROTECTED] 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

Re: SELECT statement to determine if any drives available

2002-12-19 Thread Christian Sandfeld

: | |Subject: Re: SELECT statement to determine if any drives available

Re: SELECT statement to determine if any drives available

2002-12-19 Thread Prather, Wanda

: SELECT statement to determine if any drives available select drive_name,drive_state,allocated_to,online from drives [EMAIL PROTECTED] 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

Re: SELECT statement to determine if any drives available

2002-12-19 Thread Gill, Geoffrey L.

That's interesting - what shows up in your allocated-to field? (Mine has nothing, even when tapes are mounted to processes and restores..) Mine too. Probably just one of those version things again ;-) By the way, I opened a PMR on the problem of nodes reporting 0.00MB backed up and others

Re: SELECT statement to determine if any drives available

2002-12-19 Thread David Longo

and restores..) -Original Message- From: David E Ehresman [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:39 AM To: [EMAIL PROTECTED] Subject: Re: SELECT statement to determine if any drives available select drive_name,drive_state,allocated_to,online from drives [EMAIL