On Wed, Feb 05, 2003 at 10:31:03AM -0500, Theresa Sarver wrote:
> Hi all;
>
> Does anyone have a script that calculates the total spaced used per node (and
>possibly per stg pool)?
>
> Thank you;
> Theresa
Here are some selects I run in my daily tsm reports
# list number of files and used storage per node, sorted by used storage
select node_name,
sum(num_files) as NUM_FILES,
sum(logical_mb) as STORAGE_MB,
sum(physical_mb) as TOTAL_MB
from occupancy
where stgpool_name <> 'COPYPOOL'
group by node_name
order by storage_mb desc
# list number of files and used storage per node, sorted by number of files
select node_name,
sum(num_files) as NUM_FILES,
sum(logical_mb) as STORAGE_MB
from occupancy
where stgpool_name <> 'COPYPOOL'
group by node_name
order by num_files desc
# total number of files backed up and used storage in primary pools
select sum(num_files)/1000 as "NUM_FILES x 1000",
sum(logical_mb)/1024 as STORAGE_GB,
sum(physical_mb)/1024 as TOTAL_GB
from occupancy
where stgpool_name <> 'COPYPOOL'
# Storage and used files per storage pool
select node_name,
stgpool_name,
sum(num_files) as NUM_FILES,
sum(logical_mb) as STORAGE_MB,
sum(physical_mb) as TOTAL_MB
from occupancy
group by node_name, stgpool_name
order by node_name, stgpool_name
-Marcel
--
======-------- Marcel J.E. Mol MESA Consulting B.V.
=======--------- ph. +31-(0)6-54724868 P.O. Box 112
=======--------- [EMAIL PROTECTED] 2630 AC Nootdorp
__==== www.mesa.nl ---____U_n_i_x______I_n_t_e_r_n_e_t____ The Netherlands ____
They couldn't think of a number, Linux user 1148 -- counter.li.org
so they gave me a name! -- Rupert Hine -- www.ruperthine.com
