All schedules that run over midnight are counted twice:
So your results are not correct.

Regards Stefan Holzwarth

-----Ursprüngliche Nachricht-----
Von: Karel Bos [mailto:Karel.Bos AT NUON DOT COM]
Gesendet: Mittwoch, 2. Oktober 2002 12:52
An: ADSM-L AT VM.MARIST DOT EDU
Betreff: Re: Calculating amount of data being backed up every 24 hours.


Or
 
/*                                              */
/* Query TSM to make a daily summary            */
/*                                              */
set sqldatetimeformat i
set sqldisplaymode w
set sqlmathmode r
commit
select count(*) as "Count", -
  case -
    when sum(bytes) > 1073741824 then -
         cast(sum(bytes)/1073741824 as varchar(24))||' Gb' -
    when sum(bytes) > 1048576 then -
         cast(sum(bytes)/1048576 as varchar(24))||' Mb' -
    when sum(bytes) > 1024 then -
         cast(sum(bytes)/1024 as varchar(24))||' Kb' -
    else cast(sum(bytes) as varchar(24)) -
  end as "Bytes", activity as "Activity" -
 from adsm.summary -
  where date(start_time) = current date - 1 day -
     or date(end_time) = current date - 1 day -
   group by activity
commit
 
 
----------------------------------------------------------------------------
----
 
 
 
-----Oorspronkelijk bericht-----
Van: David E Ehresman [mailto:ISVILLE.deehre01@LOUEDU]
Verzonden: vrijdag 27 september 2002 17:38
Aan: ADSM-L AT VM.MARIST DOT EDU
Onderwerp: Re: Calculating amount of data being backed up every 24
hours.
 
 
>Does anyone have any suggestions regarding how to calculate how much
>data
>is being handled by TSM every day ??
>
>
 
Get a trial of Servergraph/TSM, http://www.servergraph.com , and see if
it does what you want (and a whole lot more).
 
David Ehresman
A satisfied customer