On Mar 22, 2007, at 2:13 PM, Luc Beaudoin wrote:
I have a blank
I want to know how many GB I'm taking in backup everyday ... I would
like the TOTAL not by nodes ...
any ideas
Something like the following, for backups ended thus far today:
SELECT Dec((SUM(BYTES) / (1024 * 1024 *1024)),15) as "BACKUP GB TODAY" -
from SUMMARY where (DATE(END_TIME) = CURRENT DATE) and ACTIVITY =
'BACKUP'
But the TSM accounting log is a better data source.
Richard Sims
|