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] ********************************
