Not sure if this is what you are looking for.
NOTE: Need to adjust the start and stop time for the time frame that you need.
- TSM version 6.X
SERVER1> SELECT CAST(FLOAT(SUM(bytes))/1024/1024/1024 AS DEC(8,2)) AS "Backed up data in GB" FROm summary WHERE activity='ARCHIVE' AND start_time >{'2007-06-01 00:00:00'} AND start_time <{'2007-07-01 00:00:00'}
- TSM version 5.X
SERVER1> SELECT CAST(FLOAT(SUM(bytes))/1024/1024/1024 AS DEC(8,2)) AS "Backed up data in GB" FROm summary WHERE activity='BACKUP' AND start_time >{ts '2007-06-01 00:00:00'} AND start_time <{ts '2007-07-01 00:00:00'}
Example of out put:
Backed up data in GB
--------------------
38829.70
Good Luck,
Sias