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
joni.moyer AT highmark DOT com
********************************