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

        Great script for hunting down "problem children" backing up the
wrong stuff! At our site we have a lot of archives being pushed from hosts,
so I changed "BACKUP" to "ARCHIVE" and I get some great summary stats.

        Kudos to Miles for a very helpful script. The one I was using to get
this information out of the server was U-G-L-Y because I am not all that
good with SQL queries, but I am good with kornshell scripting. This is
~much~ better.

Thanks,
Ben
Micron Technology



-----Original Message-----
From: Miles Purdy [mailto:PURDYM AT FIPD.GC DOT CA]
Sent: Friday, September 27, 2002 6:55 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: 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