AW: Calculating amount of data being backed up every 24 hours.
2002-10-02 07:09:22
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- AW: Calculating amount of data being backed up every 24 hours.,
Stefan Holzwarth <=
|
|
|