Hi,
In your script add:
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' and schedule_name ' '
De: ADSM: Dist Stor Manager em nome de Joni Moyer
Enviada: qui 28/7/2005 08:17
Para: ADSM-L@VM.MARIST.EDU
Assunto: Scripts for summary
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
[EMAIL PROTECTED]
