Re: Scripts for summary

Debbie,

try select   SCHEDULE_NAME, START_TIME, END_TIME,  BYTES,
LastSess_Duration, FAILED,  SUCCESSFUL   from summary, nodes  where entity
= node_name and end_time > date()-1

david




             Debbie Bassler
             <Deborah_Bassler@
             PAPAJOHNS.COM>                                             To
             Sent by: "ADSM:           ADSM-L AT vm.marist DOT edu
             Dist Stor                                                  cc
             Manager"
             <[email protected]                                     Subject
             .edu>                     Re: [ADSM-L] Scripts for summary


             08/01/2005 01:06
             PM


             Please respond to
             "ADSM: Dist Stor
                 Manager"
             <[email protected]
                   .edu>






I'm just starting to learn the value of scripts,,,

The attached email provoked me to send this email before diving into the
script arena,,,in hopes someone may already have a script similiar to the
one I'm in need of,,,

I'm looking for a script containing the following backup information,,,

schedule name, scheduled start time, actual start time, end time, amount
of data backed up, amount of time the backup took, skipped files, and
completion status

Does anyone have something like this??

Thanks,
Debbie






Joni Moyer <joni.moyer AT HIGHMARK DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
07/28/2005 07:17 AM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        [ADSM-L] 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
joni.moyer AT highmark DOT com
********************************