Paul and all, When I attempt to use any of the following select statements my "Total MB" returned is always 0. I get my list of nodes but there is never any numbers for size.
Since this is my first attempt at select statements, I am sure I doing something wrong. I have tried from command line and through macro's. I am trying this on a W2K TSM v4.2.2 server. Thanks, Mark B. -----Original Message----- From: Seay, Paul [mailto:[EMAIL PROTECTED]] Sent: Monday, September 16, 2002 11:43 PM To: [EMAIL PROTECTED] Subject: Re: Backup reporting See if these will help: /* SQL Script: */ /* */ /* backup_volume_last_24hours.sql */ /* Date Description */ /* 2002-06-10 PDS Created */ /* Create Report of total MBs per each session */ select entity as "Node Name ", cast(bytes/1024/1024 as decimal(10,3)) as "Total MB ", cast(substr(cast(end_time-start_time as char(17)),3,8) as char(8)) as "Elapsed ", substr(cast(start_time as char(26)),1,19) as "Date/Time ", case when cast((end_time-start_time) seconds as decimal) >0 then cast(bytes/cast((end_time-start_time) seconds as decimal)/1024/1024 as decimal(6,3)) else cast(0 as decimal(6,3)) end as " MB/Sec" from summary where start_time>=current_timestamp - 1 day and activity='BACKUP' /* Create Report of total MBs and length of backup for each node */ select entity as "Node Name ", cast(sum(bytes/1024/1024) as decimal(10,3)) as "Total MB", substr(cast(min(start_time) as char(26)),1,19) as "Date/Time ", cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as char(8)) as "Length " from summary where start_time>=current_timestamp - 22 hours and activity='BACKUP' group by entity /* Create Report of total backed up*/ select sum(cast(bytes/1024/1024/1024 as decimal(6,3))) "Total GB Backup" from summary where start_time>=current_timestamp - 1 day and activity='BACKUP'
