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:seay_pd AT NAPTHEON DOT COM]
Sent: Monday, September 16, 2002 11:43 PM
To: ADSM-L AT VM.MARIST DOT EDU
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'