Consider activating the accounting records feature on your TSM server.
There is a lot of information to be had from the accounting records.
Another alternative would be to look at the SUMMARY table on the TSM
server.

Regards,

Andy

Andy Raibeck
IBM Tivoli Systems
Tivoli Storage Manager Client Development
e-mail: araibeck AT tivoli DOT com
"The only dumb question is the one that goes unasked."


Bill Robb <robbwd AT HOME DOT COM>@VM.MARIST.EDU> on 04/18/2001 04:22:09 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  SQL for Amount Backed up Daily:



Folks...

I'm running TSM 4.1 on an S390 server, and have 85 clients divided into two
domains - Novell and AIX.  Many of the clients run multiple backup sessions
per day.

I'm new to SQL, and have been trying to write the command that will show me
the amount backed up, in MB per day, per client.  My problem is that my
command only shows me the amount from the last session, not the last 24
hours.

Has anyone ever succeeded at writing such a command?

Thanks.

Bill Robb