Re: [ADSM-L] which one is more accurate count?

Select node_name,sum(physical_MB) from occupancy group by node_name
Would seem to give you the total usage for each of you nodes.  If you don't 
want to count copypools,  
Select node_name,sum(physical_MB) from occupancy where stgpool_name in (select 
stgpool_name from stgpools where pooltype='PRIMARY) group by node_name


73,
Tim Conway
JBS USA | 1770 Promontory Ci | Greeley, CO 80634| USA
Direct: 970-506-7998  | Fax: 970.336.6195
email: Timothy.Conway AT jbssa DOT com
JBS Server Team


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Avy Wong
Sent: Tuesday, August 10, 2010 1:50 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] which one is more accurate count?

Hi tsm experts,
        In order to get an accurate count of the storage capacity used by all 
the nodes, I thought if I go about using select statement #1, I get the storage 
usage of from each storage pool, add them up,  will get me an accurate count or 
rather simply run # 2 will do the job?


1) select vu.node_name, ao.total_mb, count(distinct vu.volume_name) as tapes, 
ao.total_mb/count(distinct vu.volume_name) as "AVG MB/tape" from volumeusage 
vu, auditocc ao where vu.stgpool_name='YOUR_POOL_NAME' and 
vu.node_name=ao.node_name group by vu.node_name, ao.total_mb order by 4


2) select filespaces.node_name,sum(PCT_UTIL * CAPACITY/100) as 
"TOTAL_CAPACITY(MB)" from filespaces group by filespaces.node_name order by 
"NODE_NAME""

Avy Wong
Business Continuity Administrator
Mohegan Sun
1 Mohegan Sun Blvd
Uncasville, CT 06382
(860)862-8164
(cell) (860)961-6976


The information contained in this message may be privileged and confidential 
and protected from disclosure. If the reader of this message is not the 
intended recipient, or an employee or agent responsible for delivering this 
message to the intended recipient, you are hereby notified that any 
dissemination, distribution, or copy of this communication is strictly 
prohibited. If you have received this communication in error, please notify us 
immediately by replying to the message and deleting it from your computer.