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