Re: [ADSM-L] command for find filespace volume

Here is the script I use. You run it with 3 parameters:
 - node name
 - (first characters of) storage pool name 
 - (substring of) filespace name

For the second and third parameters you may also give the empty string "" as
parameter to query all stg pools/filespaces.

SELECT DISTINCT -
    CAST(volumeusage.volume_name AS CHAR(6)) as "Volume", -
    volumeusage.stgpool_name as "STGPOOL", -
    CAST(volumes.est_capacity_mb as decimal(6,0)) as "Capacity",
    CAST(volumes.pct_utilized AS DECIMAL(4,1)) AS "% used", -
    CAST(volumes.status AS CHAR(7)) as "Status", -
    CAST(volumes.access AS CHAR(6)) as "Access", -
    DATE(volumes.last_write_date) as "Last write" -
  FROM volumeusage,volumes -
  WHERE volumeusage.node_name=upper('$1') -
   AND volumeusage.stgpool_name like upper('$2' || '%') -
   AND volumeusage.filespace_name like ('%' || '$3' || '%') -
   AND volumeusage.volume_name=volumes.volume_name -
  ORDER BY 1


  Rainer Schöpf

--------------------------------------------------------------------------
On Fri, 22 Aug 2008, Pavel Sitnikov wrote:

 > Anybody know command for find particular filespace volume on the library?
 > Q FILES NODE_NAME F=D and  Q CON is not good idea in this case. And I know 
 > what it is done with Web client.
 > I want to know on what volume resides filespace.
 > I appreciate any help!
 > 
 > ..............................................................
 > С уважением, Ситников Павел 
 > Дирекция сопровождения серверных систем
 > ОАО "УРАЛСИБ", Уфа
 > (347) 251-96-62, (010) 4385
 > 

--------------------------------------------------------
ProteoSys AG
Carl-Zeiss-Straße 51
55129 Mainz

Dr. Rainer Schöpf
Leiter Software/Softwareentwicklung

Mail:   rainer.schoepf AT proteosys DOT com
Phone:  +49-(0)6131-50192-41
Fax:    +49-(0)6131-50192-11
WWW:    http://www.proteosys.com/
--------------------------------------------------------
ProteoSys AG - Carl-Zeiss-Str. 51 - D-55129 Mainz
Amtsgericht Mainz HRB 7508 - USt.-Id Nr.: DE213940570
Vorstand: Helmut Matthies (Vorsitzender), Prof. Dr. André Schrattenholz
Vorsitzender des Aufsichtsrates: Dr. Werner Zöllner