$1 and $2 are parameters you pass when you run the script. Adjust the numbers to fit what you want to see.
select nodes.domain_name,summary.activity,sum(cast(summary.bytes/1- 024/1024/1024 as decimal(6,2))) as GB from nodes, summary where (end_time between current_timestamp - $1 hours and current_timestamp - $2 hours) and (activity='BACKUP' or activity='RESTORE' or activity='ARCHIVE' or activity='RETRIEVE') and ((nodes.node_name=summary.entity)) group by domain_name,summary.activity order by activity,domain_name asc Here's the output from one of my servers using 24 48 tsm: MSPTSM01COL>run query_past_activity_by_domain 48 24 DOMAIN_NAME ACTIVITY GB ------------------ ------------------ --------------------------------- HP-COL ARCHIVE 33.86 AIX-COL BACKUP 70.33 BRMS BACKUP 89.12 DOMINO BACKUP 8.87 HP-COL BACKUP 185.04 NT2-COL BACKUP 4.05 SUN-COL BACKUP 8.60 DOMINO RESTORE 11.35 AIX-COL RETRIEVE 0.52 ANR1462I RUN: Command script QUERY_PAST_ACTIVITY_BY_DOMAIN completed successfully. tsm: MSPTSM01COL> [EMAIL PROTECTED] Timothy Hughes <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 12/09/2004 12:08 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To [EMAIL PROTECTED] cc Subject Is there a way to check past backup totals Hello all, Is There a way for me to find out the total GB that I have been backing up each night say for the last week or two? or even the past couple of days a select query perhaps? I would like to increase my disk pool and would like to check each nights backup say for the last couple days or more. TSM version 5.2.3.5 AIX 5.2 Thanks for any help!
