Thanks for the start,,,,,,once I get some start and end times identified in the script it should work nicely,,
Debbie David W Litten <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 08/01/2005 01:48 PM Please respond to "ADSM: Dist Stor Manager" To: [email protected] cc: Subject: Re: [ADSM-L] 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: [email protected] 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 <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[email protected]> 07/28/2005 07:17 AM Please respond to "ADSM: Dist Stor Manager" To: [email protected] 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 [EMAIL PROTECTED] ********************************
