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: [EMAIL PROTECTED] ************************************************************************ ****** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Tuesday, 12 July, 2005 14:54 To: [email protected] 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 [EMAIL PROTECTED] ********************************
