Hi Robert,
I use run this script every morning via a scheduled admin command to
list what was backed up the previous day. It's fairly simple but it allows
me to track things nicely:
Name Line Command
Number
---------- ------
------------------------------------------------------------
LIST_BACK- 10 select bytes,entity from summary where
activity='BACKUP' and
UP_TOTALS (date(end_time)=date(current_date-1 day)) and
bytes>0 order
by bytes desc
20 select sum(bytes) as total_bytes from summary
where
activity='BACKUP' and
(date(end_time)=date(current_date-1
day))
Take care,
Al
Alan Davenport
Senior Storage Administrator
Selective Insurance
[EMAIL PROTECTED]
(973) 948-1306
-----Original Message-----
From: Robert Dowsett [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 27, 2002 7:47 AM
To: [EMAIL PROTECTED]
Subject: Calculating amount of data being backed up every 24 hours.
Hi everyone.
Does anyone have any suggestions regarding how to calculate how much data
is being handled by TSM every day ??
Ideally I would like to write a script which tells me how much data is
being backed up by TSM every day (in total), how much is going to disk
storage pools and how much is going to tape storage pools. The trouble is I
can't seem to think up a simple way to measure these statistics without
resorting to complicated select statements and mathematics.
Thanks in advance for your help.
Robert Dowsett
