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
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------
In <AB7914985D03D211B4BD00805FA7DE7C04E856A0@TOTOMB01>, on 09/25/00
In <AB7914985D03D211B4BD00805FA7DE7C04E856A0@TOTOMB01>, on 09/25/00
   at 04:25 PM, "Selva, Perpetua" <perpetua.selva AT RBCDS DOT COM> 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