Joni, The parameter that must be specifed is the nodename, that is the $1. So run the script with the nodename nodename as parameter. Kurt
________________________________ Van: ADSM: Dist Stor Manager namens Joni Moyer Verzonden: vr 18/11/2005 21:27 Aan: [email protected] Onderwerp: Re: [ADSM-L] AW: [ADSM-L] Find # of tapes used per node Hi Thomas, I got the following error when I ran that command: ANR1464E RUN: Command script VOLUMESPERNODE, line 5, parameter 1 was not specified: 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'). ANR1463E RUN: Command script VOLUMESPERNODE completed in error. Any ideas? Thanks! ******************************** Joni Moyer Highmark Storage Systems, Systems Programmer NEW NUMBER: (717)302-9966 NEW FAX: (717) 302-9826 [EMAIL PROTECTED] ******************************** "Thomas Rupp" <[EMAIL PROTECTED] ERKE.AT> To Sent by: "ADSM: [email protected] Dist Stor cc Manager" <[EMAIL PROTECTED] Subject .EDU> AW: [ADSM-L] Find # of tapes used per node 11/18/2005 03:23 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED] .EDU> 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] ********************************
