Joni,
Maybe this will help you:
select node_name, copy_type, volume_name, stgpool_name from volumeusage
where node_name='NODENAME' group by node_name, copy_type, volume_name,
stgpool_name
Regards,
Karel
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
PAC Brion Arnaud
Sent: dinsdag 12 juli 2005 16:42
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Select on tapes used/node
Joni,
I just realized that the query I provided (and yours too) will provide
wrong results, as the same volume will be counted several times : one
entry for each filespace belonging the same node on the same volume !
Sorry ...
Arnaud
************************************************************************
******
Panalpina Management Ltd., Basle, Switzerland, CIT Department
Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: arnaud.brion AT panalpina DOT com
************************************************************************
******
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: Tuesday, 12 July, 2005 14:54
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Select on tapes used/node
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
********************************
|
