Hi


Thanks very much for your suggestions. They are really useful. I am going
to implement them as a script and create some nice graphs to put on the
web.

Thanks again
Rob

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Robert Dowsett
Hydro IS Partner, Enterprise Server Team,
Visit Address: Akerbygget, Sandsliveien 251, Sandsli, Bergen
Mail address: P. O. Box. 7190, N50-20 Bergen.
Phone +47 - 5599 2507, Fax +47 - 5599 5020
Mobile: +47 - 91759732
----------------------------------------------------------------------------------------------------------------------------------------------------------------------



                    Alan.Davenport@SEL
                    ECTIVE.COM                To:     ADSM-L AT VM.MARIST DOT 
EDU
                    Sent by:                  cc:
                    [email protected]        Subject:     Re: Calculating 
amount of data being backed up every 24
                    DU                        hours.


                    2002-09-27 17:32
                    Please respond to
                    ADSM-L






Hi Robert,

    I use run this script every morning via a scheduled admin command to
list what was backed up the previous day. It's fairly simple but it allows
me to track things nicely:


Name           Line       Command

               Number
----------     ------
------------------------------------------------------------
LIST_BACK-     10         select bytes,entity from summary where
activity='BACKUP' and
 UP_TOTALS                 (date(end_time)=date(current_date-1 day)) and
bytes>0 order
                           by bytes desc

               20         select sum(bytes) as total_bytes from summary
where
                           activity='BACKUP' and
(date(end_time)=date(current_date-1
                           day))


   Take care,
       Al

Alan Davenport
Senior Storage Administrator
Selective Insurance
alan.davenport AT selectvie DOT com
(973) 948-1306

-----Original Message-----
From: Robert Dowsett [mailto:Robert.Andrew.Dowsett AT HYDRO DOT COM]
Sent: Friday, September 27, 2002 7:47 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Calculating amount of data being backed up every 24 hours.


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