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>
>
> curtis.stewart AT lawson DOT com
>
> Timothy Hughes <Timothy.Hughes AT OIT.STATE.NJ DOT US>
> Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
> 12/09/2004 12:08 PM
> Please respond to
> "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> To
> ADSM-L AT VM.MARIST DOT EDU
> 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!