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