Sure, and the table is not that accurate. Keep in mind, its for free. -----Oorspronkelijk bericht----- Van: Stefan Holzwarth [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 2 oktober 2002 13:09 Aan: [EMAIL PROTECTED] Onderwerp: AW: Calculating amount of data being backed up every 24 hours.
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:[EMAIL PROTECTED]] Gesendet: Mittwoch, 2. Oktober 2002 12:52 An: [EMAIL PROTECTED] 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: [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
