TSM select for total data transferred by node and date

Spidzior

Newcomer
Joined
Nov 29, 2015
Messages
1
Reaction score
0
Points
0
PREDATAR Control23

I've been trying to crack that one up for the past hour, but I give up.

I need to create a report for customer with total data transferred in November for all their nodes.

Thank in advance for any help.
 
PREDATAR Control23

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
 
Top