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
[EMAIL PROTECTED]
ph: (204) 984-1602 fax: (204) 983-7557
"If you hold a UNIX shell up to your ear, can you hear the C?"
-------------------------------------------------------------------------------------------------
>>> [EMAIL PROTECTED] 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
