Select on tapes used/node
2005-07-12 08:54:07
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
********************************
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- Select on tapes used/node,
Joni Moyer <=
|
|
|