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: [EMAIL PROTECTED]
"The only dumb question is the one that goes unasked."
Bill Robb <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 04/18/2001 04:22:09 PM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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
