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: [EMAIL PROTECTED]
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
