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
********************************
|