Hello everyone! I have run this select to find the total number of tapes used/node/storage pool, but I was wondering if there is a way to just count the total number of tapes used/node without breaking it down by storage pool? Thank you in advance!
select node_name,stgpool_name,count(*) as "Count" from volumeusage group by stgpool_name,node_name NODE_NAME STGPOOL_NAME Count ------------------ ------------------ ----------- CHRS041 COPY_AIX 608 CHRS047 COPY_AIX 240 CHRS049 COPY_AIX 98 CHRS051 COPY_AIX 429 CHRS054 COPY_AIX 500 CHRS057 COPY_AIX 348 CHRS058 COPY_AIX 92 CHRS144 COPY_AIX 378 CHSU602 COPY_AIX 3 CHSU603 COPY_AIX 2 NV6000 COPY_AIX 64 PGSP023 COPY_AIX 607 PGSP024 COPY_AIX 442 PGSP025 COPY_AIX 435 PGSP026 COPY_AIX 417 CHLN070 COPY_LINUX 371 CHLN071 COPY_LINUX 308 CHLN072 COPY_LINUX 286 CHLN075 COPY_LINUX 128 CHLN076 COPY_LINUX 8 ******************************** Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] ********************************
