I use the following script I got from this list (probably):
/* -------------------------------------------*/
/* Script Name: vols-node */
/* Description: List volumes per node */
/* Parameter: nodename */
/* Author: [EMAIL PROTECTED] */
/* Example: run vols-node myUnixBox */
/* !!! WARNING !!! RESOURCE INTENSIVE !!! */
/* -------------------------------------------*/
select volumes.volume_name as "Volume",-
volumes.stgpool_name as "StgPool",-
volumes.est_capacity_mb as "Cap.(MB)",-
volumes.pct_utilized as "Utlzd(%)",-
volumes.status as "Status",-
volumeusage.filespace_name as "Filespace" -
from volumes,volumeusage -
where volumes.volume_name=volumeusage.volume_name and -
volumeusage.node_name=upper('$1')
HTH
Thomas Rupp
-----Ursprüngliche Nachricht-----
Von: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] Im Auftrag von Joni Moyer
Gesendet: Freitag, 18. November 2005 21:19
An: [email protected]
Betreff: [ADSM-L] Find # of tapes used per node
Hello,
I am trying to find out the number of onsite & offsite tapes that a
particular group of nodes are using. I have been using the following
select statement:
select distinct count(*) as "Volume Count",node_name from volumeusage where
stgpool_name like 'COPY%' and node_name like 'FJSU%' group by node_name
select distinct count(*) as "Volume Count",node_name from volumeusage where
stgpool_name like 'TAPE%' and node_name like 'FJSU%' group by node_name
but the results I get are adding up to more than the total number of tapes
that are being used by the environment, so I believe that I am getting
incorrect data. Could someone please let me know what I might be doing
wrong? Thanks!
********************************
Joni Moyer
Highmark
Storage Systems, Systems Programmer
Work:(717)302-6603
(717)302-9966 (NEW NUMBER as of 11/17/2005)
(717) 302-9826 (NEW FAX after 11/17/2006)
[EMAIL PROTECTED]
********************************
