ADSM-L

Re: Command for finding...

2000-05-09 09:50:11
Subject: Re: Command for finding...
From: Bill Colwell <bcolwell AT DRAPER DOT COM>
Date: Tue, 9 May 2000 09:50:11 -0400
Greg - try an sql select command --

select count(*) from volumes
 where stgpool_name = 'NAME_IN_CAPS'

This is the results from a commandline admin client --

adsm> select count(*) from volumes where stgpool_name = '9840APOOL'
ANR2963W This SQL query may produce a very large result table, or may
require a significant amount of time to compute.

Do you wish to proceed? (Yes/No) y

 Unnamed[1]
-----------
        589
        589

adsm>



In <4.3.1.0.20000509092727.00a70cc0 AT zipcode.umis.upenn DOT edu>, on 05/09/00
   at 09:50 AM, Greg Dick <gregoryd AT ISC.UPENN DOT EDU> said:

>Anybody know what command I can use to find out how many tapes are in a
>storage pool?
>ThanX,
>Greg

--
--------------------------
--------------------------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------
=========================================================================
<Prev in Thread] Current Thread [Next in Thread>