Thanks Curtis,Terry, Steve and Stef for your replies!
Terry, I have operational reporting but it only covers a 24hr period. So I can check last nights total, but what if I want it to check say the previous nights GB total. Or the night before or each night of last weeks backup total GB. Can I configure it to show the past? Thanks again! Curtis Stewart wrote: > $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!
