Hello All,

I currently have a summary report that tells me a total of how much data
was backed up/node and also a summary of the total amount of GB backed up
in a 24 hour time period.  I was wondering if it would be possible to get a
summary of how much data was backed  up in a 24 hour time period per backup
schedule?  If so, how would this be done?  Thank you in advance!

Here are the 3 I currently run for a summary report of the day.
select entity as "Admin Task",date(start_time) as "Date",time(start_time)
as "Start",time(end_time) as "End",cast(substr(cast(end_time-start_time as
char(20)),3,8) as char(8)) as "Duration", schedule_name as
"Schedule",examined as "Examined",affected,failed,cast(bytes/1024/1024 as
decimal(6,0)) as "MB",successful from summary where
start_time>=current_timestamp - 24 hours and activity in('STGPOOL BACKUP')

select sum(cast(bytes/1024/1024/1024 as decimal(8,2))) "Total GB Backed Up"
from summary where start_time>=current_timestamp - 1 day and
activity='BACKUP'

select sum(cast(bytes/1024/1024/1024 as decimal(8,2))) "Total GB Archived"
from summary where start_time>=current_timestamp - 1 day and
activity='ARCHIVE'
q act begint=09:00 msg=6900

********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************