If you have a 3.7 server you can query the summary table.
Assuming your overnight time is from 8 pm to 6 am,
and that you don't have any long running backups
from the previous night, this select
would sum all the bytes sent to the server by backups --
/* */
/* macro file to select data from the summary table */
/* with tsm 3.7 */
/* */
select sum(bytes) as sum_bytes -
from adsm.summary -
where (date(end_time) = current date - 1 days -
and time(end_time) >= '20.00.00') -
or (date(end_time) = current date) -
and activity = 'BACKUP'
(cut and paste to a file then enter <macro filename> in
dsmadmc (the commandline admin).)
--
--------------------------
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
[EMAIL PROTECTED]
--------------------------
In <AB7914985D03D211B4BD00805FA7DE7C04E856A0@TOTOMB01>, on 09/25/00
at 04:25 PM, "Selva, Perpetua" <[EMAIL PROTECTED]> said:
>Does someone know of a quick query to find out how much data was backed up
>last nite?
>as i am trying to forcast how much tapes are needed on a daily basis
>Thanks
