Re: Calculating amount of data being backed up every 24 hours.

This reports on MB / Node:

* 
select summary.entity as "NODE NAME", nodes.domain_name as "DOMAIN", 
nodes.platform_name as "PLATFORM", \
cast((cast(sum(summary.bytes) as float) / 1024 / 1024) as decimal(10,2)) as 
MBYTES , \
count(*) as "CONECTIONS" from summary ,nodes where 
summary.entity=nodes.node_name and \
summary.activity='BACKUP' and start_time >current_timestamp - 1 day group by 
entity, domain_name, platform_name order by
MBytes desc

Ex:

NODE NAME              DOMAIN                 PLATFORM                   MBYTES 
     CONECTIONS
------------------     ------------------     ----------------     ------------ 
    -----------
UNXR                   NISA_DOM               AIX                      72963.48 
              8
UNXP                   NISA_DOM               AIX                      34052.88 
              9
UNXM                   NISA_DOM               AIX                      10923.21 
              6
CITRIX01               NT_CLIENTS             WinNT                      734.06 
              2
WAG                    NT_CLIENTS             WinNT                      454.40 
              2
CWS                    NISA_DOM               AIX                        178.12 
             15
NISAMTA                NT_CLIENTS             WinNT                       48.38 
              2
UNXD                   NISA_DOM               AIX                         42.87 
              3
KOSTELNJ               NT_CLIENTS             WinNT                       30.72 
              1
MILES                  NT_CLIENTS             WinNT                       26.45 
              2
99                     NOVELL_CLIENTS         NetWare                      4.32 
              2
MAX                    NOVELL_CLIENTS         NetWare                      4.32 
              2
UNXA                   AIX_TEST_SERVERS       AIX                          0.04 
             17
UNXB                   AIX_TEST_SERVERS       AIX                          0.02 
              1


----------------------------------------------------------------------------------------------
Miles Purdy 
System Manager
Agriculture and Agri-Food Canada,
Information Systems Team,
Farm Income Programs Directorate
Winnipeg, MB, CA
purdym AT fipd.gc DOT ca
ph: (204) 984-1602 fax: (204) 983-7557

"If you hold a UNIX shell up to your ear, can you hear the C?"
-------------------------------------------------------------------------------------------------

>>> Robert.Andrew.Dowsett AT HYDRO DOT COM 27-Sep-02 6:46:55 AM >>>
Hi everyone.

Does anyone have any suggestions regarding how to calculate how much data
is being handled by TSM every day ??

Ideally I would like to write a script which tells me how much data is
being backed up by TSM every day (in total), how much is going to disk
storage pools and how much is going to tape storage pools. The trouble is I
can't seem to think up a simple way to measure these statistics without
resorting to complicated select statements and mathematics.


Thanks in advance for your help.

Robert Dowsett